update page help

[rkeppert]

I am trying to get an update record page to work... It is supposed to pull the information from the table and place the information in the text boxes for editing, however, no information shows up...

Here is the code that I'm using, and any help is much appreciated.

DB Query:

session_start(); // Turn on the session variables

ini_set('display_errors', true); // I want PHP Information On Screen
error_reporting( E_ALL ); // I want as much Debug Info I can get when I code

include ('db_conn.php');

$dbc = mysql_connect($servhost, $servuser, $servpwd);
if ( !$dbc ){
    exit( "Connection Failed" );
}
$dbnc = ($dbsname);
if(!mysql_select_db($dbnc, $dbc) ){
    exit( "DB Selection Failed" );
}


// see if SESSION have some such value, otherwise = '' = empty
$recnum_id2 = isset($_GET['recnum']) ? $_GET['recnum'] : '';

if( !empty($recnum_id2) ){
    $sql2 = "SELECT * FROM $tabname WHERE recnum = '$recnum_id2'";
}


// do the sql query and get result
$srchdn2 = mysql_query($sql2);
if($srchdn2 === false)
{
   user_error("Query failed: " . mysql_error() . "<br />\n$sql2");
   // output "nice" error to user, then exit() or whatever is appropriate
} 

// ARRAY to store the rows, if any
$all_rows2 = array(); // make an empty array

while($row2 = mysql_fetch_assoc($srchdn2)){
    $all_rows2[] = $row2; // store each row, if any
}

TEXT BOX CODE:

<input name="lastname" type="text" id="lastname" size="30" maxlength="30" onChange="javascript:this.value=this.value.toUpperCase();" onKeyUp="highlight(event)" onClick="highlight(event)" value="<?php echo $row2['lastname']; ?>">

Thanks.

Rob

[painfull]

I just solved my own problem along this same idea.

http://phpbuilder.com/board/showthread.php?t=10354160

My whole code is there, but the part that needed fixing is the final query and output to the form. I have made these changes from "$user=$_GET['edit'];" onward:

//I used a $_GET to select who I was editing in my form:

$name=$_GET["name"];

//Then query my database using that name: 

$edit=mysql_query("SELECT * FROM users WHERE username = '$name'") or die(mysql_error());

//Then use a "while" loop to display the resulting query in the form:

while($user = mysql_fetch_array($edit)){
//But also include a "form action method=post" to be able to use the same
//page to update the record:

echo "<form action=".$_SERVER['PHP_SELF']." method='post'>";

//NOW display the form in a table with a Submit Button:

echo "<table border='0' cellpadding='0' cellspacing='0' width='50%' id='AutoNumber1' height='185'><tr>";
echo "<td width='64%' align='right' height='35'><font face='Tahoma'><b><font size='4'>Username: </font></b><input type='text' name='username' tabindex=1 maxlength='10' size='20' value= " .$user['username']. "></td>";

//etc etc

Note the use of value= " .$user['username']. " in the form "input type='text'" lines. This reference to my sql query injects the data from the record I have clicked on, ready for editing. 'username' being a variable within my array. I've done the same in subsequent 'input' lines for all other record data; address, phone number etc...

Full code is in my other post, though some variable names were changed, to protect the innocent :p

Hope that helps! 😃

P.