Adding to database issue

mancombe · 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 :shrug:

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,

MMDE · 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...

mancombe · 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

BlueSkyIS · December 12, 2010

there is no error, or the error message doesn't help you?

mancombe · 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

MMDE · 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.

litebearer · 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

Sign In

Adding to database issue

Recommended Posts

mancombe

Link to comment

Share on other sites

MMDE

Link to comment

Share on other sites

mancombe

Link to comment

Share on other sites

BlueSkyIS

Link to comment

Share on other sites

mancombe

Link to comment

Share on other sites

MMDE

Link to comment

Share on other sites

litebearer

Link to comment

Share on other sites

Join the conversation

Browse

Activity

Important Information