jo Posted July 2, 2008 Share Posted 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> Quote Link to comment Share on other sites More sharing options...
mmarif4u Posted July 2, 2008 Share Posted July 2, 2008 i guess you have to use your variables in your query. Quote Link to comment Share on other sites More sharing options...
whiteboikyle Posted July 2, 2008 Share Posted 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');" Quote Link to comment Share on other sites More sharing options...
jo Posted July 2, 2008 Author Share Posted 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. Quote Link to comment Share on other sites More sharing options...
jo Posted July 7, 2008 Author Share Posted 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 ? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.