Go4Expert (http://www.go4expert.com/)
-   PHP (http://www.go4expert.com/forums/php/)
-   -   error in inserting record (http://www.go4expert.com/forums/error-inserting-record-t26510/)

ravi951 17Aug2011 10:42

error in inserting record
hi all i have been inserting records in to database using php using the below program which is saved as "insert.php".
but it is displaying the following error
Parse error: syntax error, unexpected '<' in C:\xampp\htdocs\insert1.php on line 18

dont no what went wrong.
can u tell me how to solve it.....
PHP Code:

="localhost"// Host name 
$username="root"// Mysql username 
$password=""// Mysql password 
$db_name="test"// Database name 
$tbl_name="emp"// Table name
// Connect to server and select databse.
mysql_connect("$host""$username""$password")or die("cannot connect"); 
mysql_select_db("$db_name")or die("cannot select DB");
$sql="SELECT * FROM $tbl_name";
// Count table rows 
<td align="center" bgcolor="#FFFFFF"><input name="checkbox[]" type="checkbox" id="checkbox[]" value="y" /></td>
<td align="center"><input name="empno[]" type="text" id="name" value="<? echo $rows['empno'];?>"></td>
<td align="center"><input name="empname[]" type="text" id="empname" value="<? echo $rows['empname'];?>"></td>
<td align="center"><input name="desig[]" type="text" id="desig" value="<? echo $rows['desig'];?>"></td>
<input type="submit" name="Submit" value="Submit">
// Get values from form 
// Check if button name "Submit" is active, do this 
//protect form sql injection
$a = (int) $_POST['empno'][$i]; 
$b mysql_real_escape_string$_POST['empname'][$i] ); 
$c mysql_real_escape_string$_POST['desig'][$i] ); 
//read the query
$sql="INSERT INTO '$tbl_name' (empno, empname, desig) VALUES('{$a}', '{$b}', '{$c}')";
mysql_query($sql) or die(mysql_error());

Webdeveloper 22Aug2011 15:24

Re: error in inserting record

This is because of the syntax error in the SQL query being generated. The best way to identify the error is to echo the query generated on the screen and you will be able to see the error.

Hope this helps.



pein87 23Aug2011 05:54

Re: error in inserting record
I think you need to get the basics of php before you even continue on any further with this project. Your doing so many things wrong its not even funny. Try http://www.w3schools.com/php/default.asp and once you understand the basics come back and do this basic project. Your programming foundation needs to be sturdy before you can attempt to create programs in any language.

All times are GMT +5.5. The time now is 00:35.