PHP code question!!! pls help!

jwilley

Ok, here's the deal.. i'm working with this code from a previous thread and it works fine when i have two variables i am entering but when i go to three or more it seems to work ok but it does not add any data to the mysql database... here is the code:
<html>
<head>
<title>test2.php</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body>
<form name="test_form" method="post" action="test2.php">
<p>Last Name:
<input type="text" name="lname">
First Name:
<input type="text" name="fname">
</p>
<p>Member Number:
<input name="mnumber" type="text" id="mnumber">
</p>
<p> </p>
<p>
<input name="submit" type=submit>
<input type="reset" name="Reset" value="Reset">
</p>
</form>
<?php
if(isSet($_POST['lname']['fname']['mnumber'])){
$username = "oataorg_ohioata";
$pwd = "atmedical";
$host = "localhost";
$db = "oataorg_memdb";
$table = "membinfo";

mysql_connect($host,$username,$pwd);
mysql_select_db($db);
if(mysql_error())
echo mysql_error();
$lname = $POST['lname'];
$fname = $POST['fname'];
$mnumber = $_POST['mnumber'];
$query = "insert into $table (lastname,firstname,membernumber) values ('".$lname."','".$fname."','".$mnumber."')";

mysql_query($query);

if(mysql_error())
echo mysql_error();
}
?>
<p>Here is the information you entered! This information is now stored in our
membership database.</p>
<p>Last Name: <? echo $lname;?><br>
First name: <? echo $fname;?><br>
Member Numbeer: <? echo $mnumber;?><br>

</p>
</body>
</html>

any ideas why it's not working once i get more than 2 entries?

jonathan

Moonglobe

<html> 
<head> 
<title>test2.php</title> 
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> 
</head> 

<body> 
<form name="test_form" method="post" action="test2.php"> 
<p>Last Name: 
<input type="text" name="lname"> 
First Name: 
<input type="text" name="fname"> 
</p> 
<p>Member Number: 
<input name="mnumber" type="text" id="mnumber"> 
</p> 
<p> </p> 
<p> 
<input name="submit" type=submit name="submit"> <? /*name the submit.....*/ ?>
<input type="reset" name="Reset" value="Reset"> 
</p> 
</form> 
<?php 
if(isSet($_POST['submit'])){ // ...and check for it only. the other way was wrong anyway. 
$username = "oataorg_ohioata"; 
$pwd = "atmedical"; 
$host = "localhost"; 
$db = "oataorg_memdb"; 
$table = "membinfo"; 

mysql_connect($host,$username,$pwd); 
mysql_select_db($db); 
if(mysql_error()) 
echo mysql_error(); 
$lname = $_POST['lname']; 
$fname = $_POST['fname']; 
$mnumber = $_POST['mnumber']; 
$query = "insert into $table (lastname,firstname,membernumber) values ('$lname','$fname','$mnumber')"; //no concatenation needed
mysql_query($query); 

if(mysql_error()) 
echo mysql_error(); 
} 
?> 
<p>Here is the information you entered! This information is now stored in our 
membership database.</p> 
<p>Last Name: <? echo $lname;?><br> 
First name: <? echo $fname;?><br> 
Member Numbeer: <? echo $mnumber;?><br> 

</p> 
</body> 
</html>

try that.
hth, moonglobe

jwilley

Thanks, That worked fine... this is all new to me still...

my other question was this... i wanted to add a unique identification number to the table and it workes for the first one with this code but on the second one is says that it is a duplicate key 1... here is the code...
$query = "insert into $table (uid,lastname,firstname,membernumber,certification_number,address1,address2,address3,city,state,zip,workplace,work_address,class,district,job_description,pager,cell,home,work,fax,email,committees) values (1,'".$lname."','".$fname."','".$mnumber."','".$certnumber."','".$add1."','".$add2."','".$add3."','".$city."','".$state."','".$zip."','".$workplace."','".$workadd."','".$class."','".$district."','".$jobdescript."','".$pager."','".$cell."','".$home."','".$work."','".$fax."','".$email."','".$committees."')";

i think the problem is where the number 1 is... what should i put there so that it does the automatic integer? should i just put uid?

jwilley

OK, i changes the "1" to uid and it works fine... but as i am testing it and deleting the test rows it still keeps counting from where it left off... so when i deleted the first 7 test rows and then did it again it started counting the UID at 8... is there a way to reset this number in PHP Admin?

JOn

Moonglobe

first of all, don't bother to use "." to add in values to your queries (or any string
variables). you don't need to, and it wastes time. second, yes it is if you're using phpMyAdmin, just select the DB on
the right frame, then select the table in the same frame, then click on the empty tab in the main frame. that should do it.
just do that every time you do a test. or not. it's not really necessary, but it does make things look nice.

laserlight

"OK, i changes the "1" to uid and it works fine... but as i am testing it and deleting the test rows it still keeps counting from where it left off... so when i deleted the first 7 test rows and then did it again it started counting the UID at 8... is there a way to reset this number in PHP Admin?"

sounds like the field is an AUTO_INCREMENT field.
Judging from the "uid" thing, it is probably an index field, so dont worry about the number increasing in that fashion, it is supposed to do that.

"first of all, don't bother to use "." to add in values to your queries ... you don't need to, and it wastes time"
Actually, in PHP the opposite is true.
Not having the variables parsed in the string speeds up execution.
My main reason for disregarding that in the case of queries (sometimes) is that the other way may make the query easier to read, despite being very slightly slower.

Moonglobe

actually, i was thinking for in terms of typing, but thanks, g2k. im not really all
that familiar with the workings of the interpreter.