need help with database insert

ckdoublenecks · July 30th, 2010, 05:07 PM

Will someone tell me why the below does not add a record to my database. It just displays the source code?

<form action="waitinsert.php" method="post> is from my form

waitinsert.php is the name of the program

<?
$username="root";
$password="";
$database="hoappsdb";
$entrytype=$_POST['entrytype'];
$appl=$_POST['appl'];
$date=$_POST['date'];
$time=$_POST['time'];
$name=$_POST['name'];
$racegend=$_POST['racegend'];
$ethnicity=$_POST['ethnicity'];
$laborhsg=$_POST['laborhsg'];
$displ=$_POST['displ'];
$incomelevel=$_POST['incomelevel'];
$brneeded=$_POST['brneeded'];
$moveindate=$_POST['moveindate'];
$removaldate=$_POST['removaldate'];
$code=$_POST['code'];
$comments=$_POST['comments'];
mysql_connect(localhost,$username,$password);
mysql_select_db($database) or die( "Unable to select database");
$query = "INSERT INTO waitlist VALUES ('$entrytype','$appl','$date','$time','$name','$re cegend','$ethnicity','$laborhsg','$displ','$income level','$brneeded','$moveindate','$removaldate','$ code','$comments')";
mysql_query($query);
mysql_close();
?>

bigmax · August 3rd, 2010, 07:33 AM

Try

Code:

<?php
extract($_POST,EXTR_OVERWRITE);
mysql_connect("localhost","root","");
mysql_select_db("hoappsdb") or die( "Unable to select database");
mysql_query("INSERT INTO waitlist VALUES '$entrytype','$appl','$date','$time','$name','$re cegend','$ethnicity','$laborhsg','$displ','$income level','$brneeded','$moveindate','$removaldate','$code','$comments'"); or die(mysql_error());
mysql_close();
?>

instead. Make sure you use proper php indicators (<?php instead of just <?)

katierosy · August 3rd, 2010, 08:51 AM

If PHP5 is installed properly , this code should works fine.
<?php
$username="root";
$password="";
$database="hoappsdb";
$entrytype=$_POST['entrytype'];
$appl=$_POST['appl'];
$date=$_POST['date'];
$time=$_POST['time'];
$name=$_POST['name'];
$racegend=$_POST['racegend'];
$ethnicity=$_POST['ethnicity'];
$laborhsg=$_POST['laborhsg'];
$displ=$_POST['displ'];
$incomelevel=$_POST['incomelevel'];
$brneeded=$_POST['brneeded'];
$moveindate=$_POST['moveindate'];
$removaldate=$_POST['removaldate'];
$code=$_POST['code'];
$comments=$_POST['comments'];
mysql_connect(localhost,$username,$password);
mysql_select_db($database) or die( "Unable to select database");
$query = "INSERT INTO waitlist VALUES ('$entrytype','$appl','$date','$time','$name','$re cegend','$ethnicity','$laborhsg','$displ','$income level','$brneeded','$moveindate','$removaldate','$ code','$comments')";
mysql_query($query);
mysql_close();
?>