Inserting into Access via php.

joeey

I'm doing an online registration form and using ODBC to connect to my database. I'm new to programming thus I do not know most of the advance features for php and Access. I need help in inserting data into the table in Access. I created a .php file to insert the code but it does not work. Here is the code

Expand|Select|Wrap|Line Numbers

 <?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'];

$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);

?>

If its required, I can post my registration form here. Thanks.

Stewart Ross Inverness

Hi. I have moved this thread from the Access forum, as one thing we Access bods don't tend to be is PHP experts (at least not as far as I know). The INSERT INTO seems fine, so I'm happy to hand this one to the PHP experts for their views...

By the way, saying 'it does not work' is not helpful to any of us - do you get an error message when you try to run it, if so at what line, and what debugging have you done for yourself? It is best that we don't play 'guess the error' when reviewing your code.

-Stewart

Markus

Do you receive any error messages?
What does happen? What doesn't happen?

- oh. I see Stew has already asked that.

Also, you're inserting unescaped data into a datanase - not a good idea!
Read about mysql injection.

Kind regards

Inserting into Access via php.

re: Inserting into Access via php.

re: Inserting into Access via php.

Similar PHP bytes

/bytes/development

/bytes/it

/bytes/about