mancombe Posted December 12, 2010 Share Posted December 12, 2010 Hey i have set up a database and im trying to ad records to it also upload an image, when i submit my form it clears the fields but does not add to the database. There are no errors that get outputted or anything so it gives no help I have read thru my code over and over and just cant see why its not adding. Any help would be great <html> <script language="JavaScript"> function validated(){ var matric = document.s.matric.value; var name = document.s.name.value; var course = document.s.course.value; var sem = document.s.sem.value; var semint = parseInt(sem); var tel = document.s.tel.value; var telint = parseInt(tel); var address = document.s.address.value; var picture = document.s.picture.value; if(matric==""){ window.alert("Please enter matric number!"); document.s.matric.focus(); return false; } if(name==""){ window.alert("Please enter student name!"); document.s.name.focus(); return false; } if(course==""){ window.alert("Please enter student course!"); document.s.course.focus(); return false; } if(isNaN(semint)){ window.alert("Please enter student semester!"); document.s.sem.focus(); return false; } if(isNaN(telint)){ window.alert("Please enter contact number!"); document.s.tel.focus(); return false; } if(address==""){ window.alert("Please enter student address!"); document.s.address.focus(); return false; } if(picture==""){ window.alert("Please enter student picture!"); document.s.picture.focus(); return false; } } </script> <body> <table width="100%" border="0" cellspacing="0" cellpadding="2"> <tr> <td align="center"><h1><font color="#0000FF" face="Arial">ADD STUDENT PROFILE</font></h1></td> </tr> </table> <br><br> <table width="100%" border="0" cellspacing="0" cellpadding="2"> <tr> <td align="right"><font size="1" face="Arial"><a href='main.php'>Student List</a></font></td> </tr> </table> <br><br> <form method="post" action="student_form.php" enctype="multipart/form-data" name='s' onsubmit='return validated()';> <table width="70%" border="0" align="center" cellpadding="2" cellspacing="2"> <tr> <td width="33%" align="right"><font size="2" face="Arial"><strong>Matric Number</strong></font></td> <td width="5%" align="center">:</td> <td width="62%"><input type='text' name='matric' size=30 maxlength=15></td> </tr> <tr> <td align="right"><font size="2" face="Arial"><strong>Name</strong></font></td> <td align="center">:</td> <td><input type='text' name='name' size=30 maxlength=50></td> </tr> <tr> <td align="right"><font size="2" face="Arial"><strong>Course</strong></font></td> <td align="center">:</td> <td><input type='text' name='course' size=30 maxlength=50></td> </tr> <tr> <td align="right"><font size="2" face="Arial"><strong>Semester</strong></font></td> <td align="center">:</td> <td><input type='text' name='sem' size=5 maxlength=2></td> </tr> <tr> <td align="right"><font size="2" face="Arial"><strong>Sex</strong></font></td> <td align="center">:</td> <td><input type='radio' name='sex' value='Male' checked> Male <input type='radio' name='sex' value='Female'> Female</td> </tr> <tr> <td align="right"><font size="2" face="Arial"><strong>Contact Number</strong></font></td> <td align="center">:</td> <td><input type='text' name='tel' size=30 maxlength=50></td> </tr> <tr> <td align="right"><font size="2" face="Arial"><strong>Address</strong></font></td> <td align="center">:</td> <td><input type='text' name='address' size=50 maxlength=100></td> </tr> <tr> <td align="right"><font size="2" face="Arial"><strong>Picture</strong></font></td> <td align="center">:</td> <td> <input type="hidden" name="MAX_FILE_SIZE" value="10485760"> <input type="file" name="picture" size="40"> <font size="1" face="Arial"> Maxsize 1MB</font> </td> </tr> <tr> <td> </td> <td> </td> <td><input type='submit' name="submit" value='Submit'> <input type='reset' value='Reset'></td> </tr> </table> <?php if ($submit) { include 'db_connect.php'; $data = addslashes(fread(fopen($picture, "r"), filesize($picture))); $pjpeg="image/pjpeg"; $jpeg="image/jpeg"; $gif="image/gif"; $png="image/png"; $bmp="image/bmp"; if ($picture_type == $pjpeg OR $picture_type == $jpeg OR $picture_type == $gif OR $picture_type == $png OR $picture_type == $bmp) { $sql="INSERT INTO info (matric, name, course, sem, sex, tel, address ,bin_data,filename,filesize,filetype) VALUES ('$matric', '$name', '$course', '$sem', '$sex', '$tel', '$address', '$data','$picture_name','$picture_size','$picture_type')"; $result=mysql_query($sql); header ("Location: main.php"); } else{ echo "<script language='JavaScript'>"; echo "window.alert('Error! You only can upload jpeg, gif, png, bmp file type.')"; echo "</script>"; } } ?> </form> </body> </html> Thanks, Link to comment https://forums.phpfreaks.com/topic/221415-adding-to-database-issue/ Share on other sites More sharing options...
MMDE Posted December 12, 2010 Share Posted December 12, 2010 $sql="INSERT INTO info (matric, name, course, sem, sex, tel, address, bin_data,filename,filesize,filetype) VALUES ('$matric', '$name', '$course', '$sem', '$sex', '$tel', '$address', '$data','$picture_name','$picture_size','$picture_type')"; echo $sql; $result=mysql_query($sql) or die(mysql_error()); To see the errors... Link to comment https://forums.phpfreaks.com/topic/221415-adding-to-database-issue/#findComment-1146295 Share on other sites More sharing options...
mancombe Posted December 12, 2010 Author Share Posted December 12, 2010 $sql="INSERT INTO info (matric, name, course, sem, sex, tel, address, bin_data,filename,filesize,filetype) VALUES ('$matric', '$name', '$course', '$sem', '$sex', '$tel', '$address', '$data','$picture_name','$picture_size','$picture_type')"; echo $sql; $result=mysql_query($sql) or die(mysql_error()); To see the errors... it doesn't really help Link to comment https://forums.phpfreaks.com/topic/221415-adding-to-database-issue/#findComment-1146305 Share on other sites More sharing options...
BlueSkyIS Posted December 12, 2010 Share Posted December 12, 2010 there is no error, or the error message doesn't help you? Link to comment https://forums.phpfreaks.com/topic/221415-adding-to-database-issue/#findComment-1146307 Share on other sites More sharing options...
mancombe Posted December 12, 2010 Author Share Posted December 12, 2010 there is no error, or the error message doesn't help you? it doesn't give any error at all when i try to add so i tested the SQL and it said 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 '$sql="INSERT INTO info (matric, name, course, sem, sex, tel, address ,bin_data,f' at line 1 Thanks Link to comment https://forums.phpfreaks.com/topic/221415-adding-to-database-issue/#findComment-1146313 Share on other sites More sharing options...
MMDE Posted December 12, 2010 Share Posted December 12, 2010 it seems like the query string contains '$sql="INSERT INTO ....' (assigning of the mysql query as a string). give us your current code, and I will show you what to test. Link to comment https://forums.phpfreaks.com/topic/221415-adding-to-database-issue/#findComment-1146316 Share on other sites More sharing options...
litebearer Posted December 12, 2010 Share Posted December 12, 2010 1. Do not put your sql insert code in the middle of your form. IF you were using your sql to populate form fields that would eb different. 2. you are NOT grabbing any of your variables - ie - you use $name in your sql query HOWEVER, you have not set its value Link to comment https://forums.phpfreaks.com/topic/221415-adding-to-database-issue/#findComment-1146321 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.