Inserting data

jo · July 2, 2008

Hi everyone, I'm not sure where to post this post as I can't find a relevant place to post it. I'm doing an online form and want to save the data into the MS Access databse. However I can't insert any data as it would give me a HTTP 500 internal error. Can anyone help me out on this ? Here are the codes for the form and data submitting.

Form:

<?php
error_reporting(E_ALL ^ E_NOTICE);
?>
<?php

function checkphone()    {
global $tel;
$phone = $_POST['hometel'];
  if (!preg_match('/^[0-9]{8}$/', $phone)) {
$tel = '<font color="red"><b>Your telephone number is invalad</b></font>';
  $GLOBALS['tel'] = $tel;       }
else{
     $GLOBALS['showtel'] = "true";
  }
}


function checkemail()	{
global $mail;
$email = $_POST['email'];
if (!preg_match('/^([a-zA-Z0-9])+([a-zA-Z0-9\.\\+=_-])*@([a-zA-Z0-9_-])+([a-zA-Z0-9\._-]+)+$/', $email)) {
$mail = '<font color="red"><b>Your Email is invalid</b></font>';

$GLOBALS['mail'] = $mail; }
  else
  {
    $GLOBALS['showmail'] = "true";
  }
}

if($_POST['submit'])
{
checkphone();
checkemail();
}
	if(!$showtel||!$showmail){
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>FYP</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body>
<form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post">
    <p align="center">Name:
      <input type="text" name="name" />
</p>
<p align="center">Admin No.:

  <input type="text" name="admin" />
</p>
<p align="center">Gender:
  <select name="gender">
    <option value="male" selected>Male</option>
    <option value="female">Female</option>
      </select>
</p>
<p align="center">Address:
  <textarea name="address" cols="40"></textarea />
</p>
<p align="center">Home Phone:
<input type="text" name="hometel" />  <br>
<?php echo $tel; ?>
</p>
<p align="center">Mobile Phone:
<input type="text" name="hp" />
</p>
<p align="center">Contact Email:
<input type="text" name="email" /> <br>
<?php echo $mail; ?>
</p>
<p align="center">Course:
<select name="course"></select>
</p>
<p align="center">Acad Year:
<input type="text" name="year" />
</p>
<p align="center">Path:
<select name="path">
  <option value="1">B1</option>
  <option value="2">B2</option>
  <option value="3">B3</option>
</select>
</p>
<p align="center">Project Title:
  <textarea name="title" cols="40"></textarea>
</p>
<p align="center">Project Supervisor:
<select name="supervisor">
  <option value="Mr. Stephen Liew K C" selected>Mr. Stephen Liew K C</option>
  <option value="Mr. Steven Ng">Mr. Steven Ng</option>
</select>
</p>
<p align="center">
<input name="submit" type="submit" />
</p>

</form>

<?php
} else {
?>
<form action="datasubmit.php" enctype="multipart/form-data" method="post">
<?php

echo'<div align="center">';
echo '<p>Name:  '.$_POST["name"].' <br />';
echo 'Admin No.:  '.$_POST["admin"].' <br />';
echo 'Gender:  '.$_POST["gender"].' <br />';
echo 'Address: '.$_POST["address"].' <br />';
echo 'Home Phone:  '.$_POST["hometel"].' <br />';
echo 'Handphone: '.$_POST["hp"].' <br />';
echo 'Contact Email:  '.$_POST["email"].' <br />';
echo 'Course: '.$_POST["course"].' <br />';
echo 'Acad Year: '.$_POST["year"].' <br />';
echo 'Path: '.$_POST["path"].' <br />';
echo 'Project title:'.$_POST["title"].' <br />';
echo 'Project Supervisor: '.$_POST["supervisor"].' <br />';
?>
<p>
    <input type="submit" name="Submit" value="Submit">
</form>
</p>
  <p>
    <input name="button" type=button onClick=window.history.back() value=Back back>
  </p>
  </div>
  <?php }?>
  
</body>
</html>

and here is the data submitting codes:

<?php
error_reporting(E_ALL ^ E_NOTICE);
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<?php
echo "Your data is successfully submitted";
?>
<?php
$name = $_POST['name'];
$admin = $_POST['admin'];
$gender = $_POST['gender'];
$address = $_POST['address'];
$hometel = $_POST['hometel'];
$hp = $_POST['hp'];
$email = $_POST['email'];
$course = $_POST['course'];
$year = $_POST['year'];
$path = $_POST['path'];
$title = $_POST['title'];
$supervisor = $_POST['supervisor'];
?>
<?php

$odbc = odbc_connect('FYP', '', '') or die('Could not connect to ODBC database!');
$query = "INSERT into fyp (Name, AdminNumber, Gender, Address, Hometelephone, MobilePhone, Email, AcadCourse, Year, Path ,Projecttitle, ProjectSupervisor) VALUES ("name", "admin", "gender", "address", "hometel", "hp", "email", "course", "year", "path", "title", "supervisor");"
$result = odbc_exec($odbc, $query) or die (odbc_errormsg());
odbc_close($odbc);
?>
</body>
</html>

mmarif4u · July 2, 2008

i guess you have to use your variables in your query.

whiteboikyle · July 2, 2008

"INSERT into fyp (Name, AdminNumber, Gender, Address, Hometelephone, MobilePhone, Email, AcadCourse, Year, Path ,Projecttitle, ProjectSupervisor) VALUES ("name", "admin", "gender", "address", "hometel", "hp", "email", "course", "year", "path", "title", "supervisor");"

make that to

"INSERT into fyp (Name, AdminNumber, Gender, Address, Hometelephone, MobilePhone, Email, AcadCourse, Year, Path ,Projecttitle, ProjectSupervisor) VALUES ('$name', '$admin', '$gender', '$address', '$hometel', '$hp', '$email', '$course', '$year', '$path', '$title', '$supervisor');"

jo · July 2, 2008

Thanks for the quick reply. I've changed the code to the one you have stated but it still gives the same error. mmarif4u can you explain alittle bit more of you have typed ? I'm new to programming so I don't really know much about terms and stuff.

jo · July 7, 2008

I found out that the error was due to data type mismatch critearia expression. I've fixed the problem but then every single variable in the VALUES becomes undefined. Is there anyone who can help me ?

Sign In

Inserting data

Recommended Posts

jo

Link to comment

Share on other sites

mmarif4u

Link to comment

Share on other sites

whiteboikyle

Link to comment

Share on other sites

jo

Link to comment

Share on other sites

jo

Link to comment

Share on other sites

Join the conversation

Browse

Activity

Important Information