error in MySQL in PHP with Dreamweaver
06-03-11, 05:45 PM
New Member
Join Date: Jun 2011
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
error in MySQL in PHP with Dreamweaver
hi
i made a registration form in a website using dreamweaver
i made the database in the remote server, then linked it to the registration page via dreamweaver
i tested the database connection, and it was successful
then i made the form via insert record set in dreamweaver
i uploaded the page to the remote server and tried to enter some data to send it but after i filled the data, and pressed the send button, i got this error message:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
this is the code i use
PHP Code:
<?php require_once( "Connections/con1.php" ); ?> <?php if (! function_exists ( "GetSQLValueString" )) { GetSQLValueString ( $theValue , $theType , $theDefinedValue = "" , $theNotDefinedValue = "" ) PHP_VERSION < 6 ) { $theValue = get_magic_quotes_gpc () ? stripslashes ( $theValue ) : $theValue ; $theValue = function_exists ( "mysql_real_escape_string" ) ? mysql_real_escape_string ( $theValue ) : mysql_escape_string ( $theValue ); $theType ) { "text" : $theValue = ( $theValue != "" ) ? "'" . $theValue . "'" : "NULL" ; "long" : "int" : $theValue = ( $theValue != "" ) ? intval ( $theValue ) : "NULL" ; "double" : $theValue = ( $theValue != "" ) ? doubleval ( $theValue ) : "NULL" ; "date" : $theValue = ( $theValue != "" ) ? "'" . $theValue . "'" : "NULL" ; "defined" : $theValue = ( $theValue != "" ) ? $theDefinedValue : $theNotDefinedValue ; $theValue ; $editFormAction = $_SERVER [ 'PHP_SELF' ]; $_SERVER [ 'QUERY_STRING' ])) { $editFormAction .= "?" . htmlentities ( $_SERVER [ 'QUERY_STRING' ]); $_POST [ "MM_insert" ])) && ( $_POST [ "MM_insert" ] == "form1" )) { $insertSQL = sprintf ( "INSERT INTO students (StuID, ProName, Name1, Name2, Name3, Mob#, Phone#, Email, BirthYear, `Level`, FathName, FathMob#, MothName, MothMob#) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)" , GetSQLValueString ( $_POST [ 'StuID' ], "int" ), GetSQLValueString ( $_POST [ 'ProName' ], "text" ), GetSQLValueString ( $_POST [ 'Name1' ], "text" ), GetSQLValueString ( $_POST [ 'Name2' ], "text" ), GetSQLValueString ( $_POST [ 'Name3' ], "text" ), GetSQLValueString ( $_POST [ 'Mob' ], "int" ), GetSQLValueString ( $_POST [ 'Phone' ], "int" ), GetSQLValueString ( $_POST [ 'Email' ], "text" ), GetSQLValueString ( $_POST [ 'BirthYear' ], "int" ), GetSQLValueString ( $_POST [ 'Level' ], "text" ), GetSQLValueString ( $_POST [ 'FathName' ], "text" ), GetSQLValueString ( $_POST [ 'FathMob' ], "int" ), GetSQLValueString ( $_POST [ 'MothName' ], "text" ), GetSQLValueString ( $_POST [ 'MothMob' ], "int" )); mysql_select_db ( $database_con1 , $con1 ); $Result1 = mysql_query ( $insertSQL , $con1 ) or die( mysql_error ()); $_POST [ "MM_insert" ])) && ( $_POST [ "MM_insert" ] == "form1" )) { $insertSQL = sprintf ( "INSERT INTO students (StuID, Name1, Name2, Name3, Mob#, Phone#, Email, BirthYear, `Level`, FathName, FathMob#, MothName, MothMob#, ProName) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)" , GetSQLValueString ( $_POST [ 'StuID' ], "int" ), GetSQLValueString ( $_POST [ 'Name1' ], "text" ), GetSQLValueString ( $_POST [ 'Name2' ], "text" ), GetSQLValueString ( $_POST [ 'Name3' ], "text" ), GetSQLValueString ( $_POST [ 'Mob' ], "int" ), GetSQLValueString ( $_POST [ 'Phone' ], "int" ), GetSQLValueString ( $_POST [ 'Email' ], "text" ), GetSQLValueString ( $_POST [ 'BirthYear' ], "int" ), GetSQLValueString ( $_POST [ 'Level' ], "text" ), GetSQLValueString ( $_POST [ 'FathName' ], "text" ), GetSQLValueString ( $_POST [ 'FathMob' ], "int" ), GetSQLValueString ( $_POST [ 'MothName' ], "text" ), GetSQLValueString ( $_POST [ 'MothMob' ], "int" ), GetSQLValueString ( $_POST [ 'ProName' ], "text" )); mysql_select_db ( $database_con1 , $con1 ); $Result1 = mysql_query ( $insertSQL , $con1 ) or die( mysql_error ()); mysql_select_db ( $database_con1 , $con1 ); $query_Recordset1 = "SELECT * FROM programs" ; $Recordset1 = mysql_query ( $query_Recordset1 , $con1 ) or die( mysql_error ()); $row_Recordset1 = mysql_fetch_assoc ( $Recordset1 ); $totalRows_Recordset1 = mysql_num_rows ( $Recordset1 ); mysql_select_db ( $database_con1 , $con1 ); $query_Recordset2 = "SELECT * FROM prostatus" ; $Recordset2 = mysql_query ( $query_Recordset2 , $con1 ) or die( mysql_error ()); $row_Recordset2 = mysql_fetch_assoc ( $Recordset2 ); $totalRows_Recordset2 = mysql_num_rows ( $Recordset2 ); mysql_select_db ( $database_con1 , $con1 ); $query_Recordset3 = "SELECT * FROM students" ; $Recordset3 = mysql_query ( $query_Recordset3 , $con1 ) or die( mysql_error ()); $row_Recordset3 = mysql_fetch_assoc ( $Recordset3 ); $totalRows_Recordset3 = mysql_num_rows ( $Recordset3 ); mysql_select_db ( $database_con1 , $con1 ); $query_Recordset4 = "SELECT * FROM stulevel" ; $Recordset4 = mysql_query ( $query_Recordset4 , $con1 ) or die( mysql_error ()); $row_Recordset4 = mysql_fetch_assoc ( $Recordset4 ); $totalRows_Recordset4 = mysql_num_rows ( $Recordset4 ); ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><?php echo $editFormAction ; ?> " method="post" name="form1" id="form1"><?php if (!( strcmp ( "إكليل الصيف" , "" ))) {echo "SELECTED" ;} ?> >إكليل الصيف</option><?php if (!( strcmp ( "متوسط" , "" ))) {echo "SELECTED" ;} ?> >متوسط</option><?php if (!( strcmp ( "ثانوي" , "" ))) {echo "SELECTED" ;} ?> >ثانوي</option><?php if (!( strcmp ( "جامعي" , "" ))) {echo "SELECTED" ;} ?> >جامعي</option><?php if (!( strcmp ( "فوق الجامعي" , "" ))) {echo "SELECTED" ;} ?> >فوق الجامعي</option><?php ( $Recordset1 ); mysql_free_result ( $Recordset2 ); ?>
Last edited by UnrealEd; 06-03-11 at 06:02 PM .
06-03-11, 06:08 PM
Community Liaison
Join Date: May 2005
Location: Antwerp, Belgium
Posts: 3,165
Thanks: 4
Thanked 25 Times in 25 Posts
You'll have to narrow your code down to the part where the error occured. Right now I counted 6 different mysql_query calls that all might result in such an error.
__________________
"Good judgement comes from experience, and experience comes from bad judgement." -
Fred Brooks
07-09-11, 02:10 PM
Newbie Coder
Join Date: Mar 2011
Posts: 23
Thanks: 0
Thanked 0 Times in 0 Posts
you should also try to echo out the queries after you build the query to see if you can figure out what look wrong. If you can't figure it out, post the built query that is causing the issue here.
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Thread Tools
Display Modes
Linear Mode
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
Linear Mode
