[RESOLVED] Updating Mysql Records Using Php

anjuraju

Hi!
I have programmed the code to display the information of a particular person in the form so that he/she can change his/her details in the form and hence update his/her records.I have tried with the following code.It displays the form with the previous data.But when I submit,it blanks the fields (excepting the name,surname and dob which I have blocked from making any correction).The remaining 7 fields become blank with the last field's (ExamsPending) value to be zero.Can anyone let me know what's the problem?I am stuck with this problem for a month and it's driving me mad.

<html><head><TITLE>display.php</TITLE></head>
<body bgcolor="#FFFFFF">
<h3><center><bold>Your Details</bold></center></h3>
<form name="mydisplay.php" method="POST" enctype="multipart/form-data" action="mydisplay.php">
<?
print "<br>";
$Ph=$POST['Mobile'];
$Em=$POST['Email'];
$Qu=$POST['Qualification'];
$Un=$POST['University'];
$Br=$POST['Branch'];
$Co=$POST['Course'];
$Av=$POST['Average'];
$Ex=$POST['ExamsPending'];
$myph=$Ph;
$myem=$Em;
$myqu=$Qu;
$myun=$Un;
$mybr=$Br;
$myco=$Co;
$myav=$Av;
$myex=$Ex;
$db="mydb";
$link=mysql_connect("localhost","username","passwordhere") or die("couldn't connect to Mysql");
mysql_select_db($db) or die("Select Error:".mysql_error());
$query="SELECT * FROM work";
$rt=mysql_query($query);
$anju=$_GET['Reference'];
while($nt=mysql_fetch_array($rt)){
if($nt[ref]==$anju){
//echo "$nt[Name] $nt[Surname]<br> $nt[DOB]<br> $nt[PhoneNumber]<br> $nt[Email]<br> $nt[Qualification]<br> $nt[University]<br> $nt[Branch]<br> $nt[Course]<br> $nt[Average]<br> $nt[ExamsPending]<br>";
$myref=$anju;
$myname=$nt[Name];
$mysur=$nt[Surname];
$mydob=$nt[DOB];
print "<b>Name:<br>
<input type=text name=Name value=$nt[Name] size=10 maxlength=10 disabled></b><br>\n";
print "<b>Surname:<br>
<input type=text name=Surname value=$nt[Surname] size=10 maxlength=10 disabled></b><br>\n";
print "<b>Date of Birth(dd/mm/yyyy):<br>
<input type=text name=DOB value=$nt[DOB] size=10 maxlength=10 disabled></b><br>\n";
print "<b>Mobile:<br>
<input type=text name=Mobile value=$nt[PhoneNumber] size=20 maxlength=20></b><br>\n";
print "<b>Email:<br>
<input type=text name=Email value=$nt[Email] size=30 maxlength=30></b><br>\n";
print "<b>Qualification:<br>
<input type=text name=Qualification value=$nt[Qualification] size=10 maxlength=10></b><br>\n";
print "<b>University:<br>
<input type=text name=University value=$nt[University] size=20 maxlength=20></b><br>\n";
print "<b>Branch:<br>
<input type=text name=Branch value=$nt[Branch] size=30 maxlength=30></b><br>\n";
print "<b>Course:<br>
<input type=text name=Course value=$nt[Course] size=5 maxlength=5></b><br>\n";
print "<b>Average:<br>
<input type=text name=Average value=$nt[Average] size=2 maxlength=2></b><br>\n";
print "<b>ExamsPending:<br>
<input type=text name=ExamsPending value=$nt[ExamsPending] size=2 maxlength=2></b><br>\n";
print "<input type =submit value=submit><br>\n";
}
}
//$myresult6=mysql_query("UPDATE work SET work.PhoneNumber='$myph', work.Email='$myem', work.Qualification= '$myqu', work.University= '$myun', work.Branch='$mybr', work.Course='$myco',work.Average='$myav',work.ExamsPending= '$myex' WHERE work.ref='myref'");
$sql = "UPDATE work SET Name = '$myname', Surname = '$mysur', DOB = '$mydob', PhoneNumber = '$myph', Email = '$myem', Qualification = '$myqu', University = '$myun', Branch = '$mybr', Course = '$myco', Average = '$myav', ExamsPending = '$myex' WHERE ref = '$myref'";
if (mysql_query($sql))
{
echo("<P>info updated.</P>");
}
else
{
echo("<P>error updating: " . mysql_error() . "</P>");
}
mysql_close($link);
echo $myref;
echo $myname;
echo $mysur;
echo $mydob;
echo $myph;
echo $myem;
echo $myqu;
echo $myun;
echo $mybr;
echo $myco;
echo $myav;
echo $myex;
?>
</form>
</body>
</html>

I have given echo statements as the last statements, just to ensure that the changed values are accepted by the variables and they get printed perfectly.

Please reply at the earliest

anjuraju

leatherback

Hi,

First of all

PLEASE format your code, since it will helkp enourmously with error spottin.

Second:

PLEASE use [ p h p ] [ / p h p ] tags around your code for syntax highlightn

Third: Welcome to PhPBuilder

Fourth. Your problem:

You try to do two things simultaneously. And in the wrong order.

//FIRST: you check whether data has been submitted:

If(isset($_POST[Mobile]))

  {  // true? Set the vars

  $Ph=$_POST['Mobile'];
$Em=$_POST['Email'];
$Qu=$_POST['Qualification'];
$Un=$_POST['University'];
$Br=$_POST['Branch'];
$Co=$_POST['Course'];
$Av=$_POST['Average'];
$Ex=$_POST['ExamsPending']; 

// and update

//$myresult6=mysql_query("UPDATE work SET work.PhoneNumber='$myph', work.Email='$myem', work.Qualification= '$myqu', work.University= '$myun', work.Branch='$mybr', work.Course='$myco',work.Average='$myav',work.ExamsPending= '$myex' WHERE work.ref='myref'");
$sql = "UPDATE work SET Name = '$myname', Surname = '$mysur', DOB = '$mydob', PhoneNumber = '$myph', Email = '$myem', Qualification = '$myqu', University = '$myun', Branch = '$mybr', Course = '$myco', Average = '$myav', ExamsPending = '$myex' WHERE ref = '$myref'";
if (mysql_query($sql))
{
echo("<P>info updated.</P>");
}
else
{
echo("<P>error updating: " . mysql_error() . "</P>");
}
mysql_close($link); 

}

// Then get data from database and display form

$link=mysql_connect("localhost","username","passwordhere") or die("couldn't connect to Mysql");
mysql_select_db($db) or die("Select Error:".mysql_error());
$query="SELECT * FROM work";
$rt=mysql_query($query);
$anju=$_GET['Reference'];
while($nt=mysql_fetch_array($rt)){
if($nt[ref]==$anju){
//echo "$nt[Name] $nt[Surname]<br> $nt[DOB]<br> $nt[PhoneNumber]<br> $nt[Email]<br> $nt[Qualification]<br> $nt[University]<br> $nt[Branch]<br> $nt[Course]<br> $nt[Average]<br> $nt[ExamsPending]<br>";
$myref=$anju;
$myname=$nt[Name];
$mysur=$nt[Surname];
$mydob=$nt[DOB];
print "<b>Name:<br>
<input type=text name=Name value=$nt[Name] size=10 maxlength=10 disabled></b><br>\n";
print "<b>Surname:<br>
<input type=text name=Surname value=$nt[Surname] size=10 maxlength=10 disabled></b><br>\n";
print "<b>Date of Birth(dd/mm/yyyy):<br>
<input type=text name=DOB value=$nt[DOB] size=10 maxlength=10 disabled></b><br>\n";
print "<b>Mobile:<br>
<input type=text name=Mobile value=$nt[PhoneNumber] size=20 maxlength=20></b><br>\n";
print "<b>Email:<br>
<input type=text name=Email value=$nt[Email] size=30 maxlength=30></b><br>\n";
print "<b>Qualification:<br>
<input type=text name=Qualification value=$nt[Qualification] size=10 maxlength=10></b><br>\n";
print "<b>University:<br>
<input type=text name=University value=$nt[University] size=20 maxlength=20></b><br>\n";
print "<b>Branch:<br>
<input type=text name=Branch value=$nt[Branch] size=30 maxlength=30></b><br>\n";
print "<b>Course:<br>
<input type=text name=Course value=$nt[Course] size=5 maxlength=5></b><br>\n";
print "<b>Average:<br>
<input type=text name=Average value=$nt[Average] size=2 maxlength=2></b><br>\n";
print "<b>ExamsPending:<br>
<input type=text name=ExamsPending value=$nt[ExamsPending] size=2 maxlength=2></b><br>\n";
print "<input type =submit value=submit><br>\n";
}
}

Please note: I have assumed your code is principly correct. This is about the wy of thinking and setting it up.

anjuraju

Hi!

Thankyou for replying at the earliest.I am sorry for being ambiguous.I would first collect the info of a person and store it in my database.Later,when he wants to update I ask for his id and then display his form with the PREVIOUS DATA in it.But as per your suggestions,I tried with the following code.Even then, the fields are not updated.But this time they are not becoming blank.

<html><head><TITLE>display.php</TITLE></head>
<body bgcolor="#FFFFFF">
<h3><center><bold>Your Details</bold></center></h3>
<form name="mydisplay1.php" method="POST" enctype="multipart/form-data" action="mydisplay1.php">
<?

$Ph=$POST['Mobile'];
$Em=$POST['Email'];
$Qu=$POST['Qualification'];
$Un=$POST['University'];
$Br=$POST['Branch'];
$Co=$POST['Course'];
$Av=$POST['Average'];
$Ex=$POST['ExamsPending'];
$myph=$Ph;
$myem=$Em;
$myqu=$Qu;
$myun=$Un;
$mybr=$Br;
$myco=$Co;
$myav=$Av;
$myex=$Ex;

// and update
$link=mysql_connect("localhost","user","password") or die("couldn't connect to Mysql");
$db="mydb";
mysql_select_db($db) or die("Select Error:".mysql_error());
$query="SELECT * FROM work";
$rt=mysql_query($query);
$anju=$_GET['Reference'];
while($nt=mysql_fetch_array($rt)){
if($nt[ref]==$anju){
//$myresult6=mysql_query("UPDATE work SET work.PhoneNumber='$myph', work.Email='$myem', work.Qualification= '$myqu', work.University= '$myun', work.Branch='$mybr', work.Course='$myco',work.Average='$myav',work.ExamsPending= '$myex' WHERE work.ref='myref'");
$sql = "UPDATE work SET PhoneNumber = '$myph', Email = '$myem', Qualification = '$myqu', University = '$myun', Branch = '$mybr', Course = '$myco', Average = '$myav', ExamsPending = '$myex' WHERE ref = '$myref'";
if (mysql_query($sql))
{
echo("<P>info updated.</P>");
}
else
{
echo("<P>error updating: " . mysql_error() . "</P>");
}
}
}
mysql_close($link);

// Then get data from database and display form

$link=mysql_connect("localhost","user","password") or die("couldn't connect to Mysql");
$db="mydb";
mysql_select_db($db) or die("Select Error:".mysql_error());
$query="SELECT * FROM work";
$rt=mysql_query($query);
$anju=$_GET['Reference'];
while($nt=mysql_fetch_array($rt)){
if($nt[ref]==$anju){
//echo "$nt[Name] $nt[Surname]<br> $nt[DOB]<br> $nt[PhoneNumber]<br> $nt[Email]<br> $nt[Qualification]<br> $nt[University]<br> $nt[Branch]<br> $nt[Course]<br> $nt[Average]<br> $nt[ExamsPending]<br>";
$myref=$anju;
$myname=$nt[Name];
$mysur=$nt[Surname];
$mydob=$nt[DOB];
print "<b>Name:<br>
<input type=text name=Name value=$nt[Name] size=10 maxlength=10 disabled></b><br>\n";
print "<b>Surname:<br>
<input type=text name=Surname value=$nt[Surname] size=10 maxlength=10 disabled></b><br>\n";
print "<b>Date of Birth(dd/mm/yyyy):<br>
<input type=text name=DOB value=$nt[DOB] size=10 maxlength=10 disabled></b><br>\n";
print "<b>Mobile:<br>
<input type=text name=Mobile value=$nt[PhoneNumber] size=20 maxlength=20></b><br>\n";
print "<b>Email:<br>
<input type=text name=Email value=$nt[Email] size=30 maxlength=30></b><br>\n";
print "<b>Qualification:<br>
<input type=text name=Qualification value=$nt[Qualification] size=10 maxlength=10></b><br>\n";
print "<b>University:<br>
<input type=text name=University value=$nt[University] size=20 maxlength=20></b><br>\n";
print "<b>Branch:<br>
<input type=text name=Branch value=$nt[Branch] size=30 maxlength=30></b><br>\n";
print "<b>Course:<br>
<input type=text name=Course value=$nt[Course] size=5 maxlength=5></b><br>\n";
print "<b>Average:<br>
<input type=text name=Average value=$nt[Average] size=2 maxlength=2></b><br>\n";
print "<b>ExamsPending:<br>
<input type=text name=ExamsPending value=$nt[ExamsPending] size=2 maxlength=2></b><br>\n";
print "<input type =submit value=submit><br>\n";
}
}

mysql_close($link);
echo $myph;
echo $myem;
echo $myqu;
echo $myun;
echo $mybr;
echo $myco;
echo $myav;
echo $myex;
?>

However,print_r statement does not give any output.So please tell me how to proceed.

anjuraju

leatherback

Hi,

USE SYNTAX HIGHLIGHTING please

Do you set the $myref variable anywhere for updating?
Why do you double-declare all the variables (eg:

$Ph=$_POST['Mobile']; and $myph=$Ph; ]
use one

why did you put all this:
$query="SELECT * FROM work";
$rt=mysql_query($query);
$anju=$_GET['Reference'];
while($nt=mysql_fetch_array($rt)){
if($nt[ref]==$anju){
in there?

anjuraju

Hi!
I have double declared the variables because:
1.I dont get them printed on the screen if i use the same variable names where I have collected the values.
2.I keep them outside the mysql.If I collect them after I have opened my db,The file gets corrupted i.e.,All the fields become blank excepting name,surname and dob.
3.due to the previous reason,I open the db once and get thm updated,close them.I open db second time and get the form.
4.Anyways,the fields become blank in the database-the only diff being the values printed on the screen after double declaration.

I am sorry for not using syntax highlighter.I will rememberto do so next time.

anjuraju 😕

leatherback

try like this, -exactly if possible-


 //FIRST: you check whether data has been submitted:
print_r($_POST)
If(isset($_POST[Mobile]))

  {  // true? Set the vars
$myname = $_POST[name];
$mysur = $_POST[surname];
$myPh=$_POST['Mobile'];
$myem=$_POST['Email'];
$myqu=$_POST['Qualification'];
$myun=$_POST['University'];
$mybr=$_POST['Branch'];
$myco=$_POST['Course'];
$myav=$_POST['Average'];
$myex=$_POST['ExamsPending']; 
$myref = $_POST['reference'];

$anju=$_GET['Reference'];  // Does this get set with login?

// and update

$sql = "UPDATE work SET 
        Name = '$myname', 
        Surname = '$mysur', 
        DOB = '$mydob', 
        PhoneNumber = '$myph', 
        Email = '$myem', 
        Qualification = '$myqu', 
        University = '$myun', 
        Branch = '$mybr', 
        Course = '$myco', 
        Average = '$myav', 
        ExamsPending = '$myex' 
        WHERE ref = '$myref'";

if (mysql_query($sql))
{
echo("<P>info updated.</P>");
}
else
{
echo("<P>error updating: " . mysql_error() . "</P>");
}
mysql_close($link); 

}

// Then get data from database and display form

$link=mysql_connect("localhost","username","passwordhere") or die("couldn't connect to Mysql");
mysql_select_db($db) or die("Select Error:".mysql_error());

$query="SELECT * FROM work where ref='$anju'";
  echo $query;
$rt=mysql_query($query);
while($nt=mysql_fetch_array($rt))
  {
print "<b>Name:<br>
<input type=text name=Name value=$nt[Name] size=10 maxlength=10 disabled></b><br>
<input type=hidden name=Reference value=$MyRef>\n";
print "<b>Surname:<br>
<input type=text name=Surname value=$nt[Surname] size=10 maxlength=10 disabled></b><br>\n";
print "<b>Date of Birth(dd/mm/yyyy):<br>
<input type=text name=DOB value=$nt[DOB] size=10 maxlength=10 disabled></b><br>\n";
print "<b>Mobile:<br>
<input type=text name=Mobile value=$nt[PhoneNumber] size=20 maxlength=20></b><br>\n";
print "<b>Email:<br>
<input type=text name=Email value=$nt[Email] size=30 maxlength=30></b><br>\n";
print "<b>Qualification:<br>
<input type=text name=Qualification value=$nt[Qualification] size=10 maxlength=10></b><br>\n";
print "<b>University:<br>
<input type=text name=University value=$nt[University] size=20 maxlength=20></b><br>\n";
print "<b>Branch:<br>
<input type=text name=Branch value=$nt[Branch] size=30 maxlength=30></b><br>\n";
print "<b>Course:<br>
<input type=text name=Course value=$nt[Course] size=5 maxlength=5></b><br>\n";
print "<b>Average:<br>
<input type=text name=Average value=$nt[Average] size=2 maxlength=2></b><br>\n";
print "<b>ExamsPending:<br>
<input type=text name=ExamsPending value=$nt[ExamsPending] size=2 maxlength=2></b><br>\n";
print "<input type =submit value=submit><br>\n";
}
}

anjuraju

Hi!
I am sorry but its not working.Can you help me out with your own code for updating please?I would be grateful if you do so.Code must display the person's info in the format of a form with its previous data and once I type in the info after eraing the previous data in the form, and I press the SUBMIT button,the record must be updated in the database.

anjuraju

yktan

Hi anjuraju, the code that leatherback posted looks very straightforward, could you be more specific on what isn't working?

anjuraju

Hi!
As you would have read, first I am displaying a page where it contains a ref no textbox where one can enter his/her ref no to update his/her previous records.So when someone enters the ref no and presses SUBMIT button, the page branches to another page where it displays the information from the mysql database and puts it in the form.So the info in the form within the textboxes.Now,If I erase the previous data and say submit, my database should be updated with the new data.Instead,it turns blank. Can you help me oyt with coding?

anjuraju

Hi!
I am finally able to update. I never realised that without having an auto_increment in my database,I would not be able to update.I have introduced an auto increment now and it works perfectly.Is there any way that I can branch to some other page after updating?Is it mandatory that I should have php_self server?I want to know how I can branch to some other page after updating.

anjuraju

leatherback

Hi,

you could convert:
echo("<P>info updated.</P>");

into a header:location=
statement.

Or you could -if you trust your coding- pull the page apart in a display & processing page or.. There is lots of ways. You could also include the next page, if you use a specifc template (Basically: If you seperate content and pagestructure in different files).