[SOLVED] Help with HTML form to database (mysql/php)!

skuliaxe · #1 Jan 19th, 2008, 20:37

Hi, I'm having a little trouble with my first run at website where users can fill in a HTML form, then that data should be stored in a mysql database. I've read through the sticky on this Forum with no luck.
I've been trying to read tutorials but with no luck

I was wondering if someone could read through my code and give me some pointers...

A) I've created a HTML for the user FORM input.
B) The FORM information is then sent to a PHP file.
C) The PHP file retrieves that informations and (should) inserts it to the database.

B) Here is the PHP code for "form_dyr.php"

PHP: Select all


<html>
<head></head>
<body>

<?php
// collect data sent from form
$form_len = $_POST['form_len'];
$form_riki = $_POST['form_riki'];
$form_fylking = $_POST['form_fylking'];
$form_undirfylking = $_POST['form_undirfylking'];
$form_flokkur = $_POST['form_flokkur'];
$form_undirflokkur = $_POST['form_undirflokkur'];
$form_aettbalkur = $_POST['form_aettbalkur'];
$form_undiraettbalkur = $_POST['form_undiraettbalkur'];
$form_aett = $_POST['form_aett'];
$form_undiraett = $_POST['form_undiraett'];
$form_aettkvisl = $_POST['form_aettkvisl'];
$form_tegund = $_POST['form_tegund'];

// connection variables
$host = "localhost";
$db_name = "NAME";
$db_user = "USER";
$db_pass = "PASS";
$db_table = "Flokkun";

// connect to host and select db
mysql_connect($host, $db_user, $db_pass);
mysql_select_db($db_name);

// create and execute the query to insert data
$query = "INSERT INTO $db_table (Len,Riki,Fylking,Undirfylking,Flokkur,Undirflokkur,Aettbalkur,Undiraettbalkur,Aett,Undiraett,Aettkvisl,Tegund) VALUES ('$form_len','$form_riki','$form_fylking','$form_undirfylking','$form_flokkur','$form_undirflokkur','$form_aettbalkur','$form_undiraettbalkur','$form_aett','$form_undiraett','$form_aettkvisl','$form_tegund')";
$result = mysql_query($query);
?>

<?
echo $form_len;
echo $form_riki;
echo $form_fylking;
echo $form_undirfylking;
echo $form_flokkur;
echo $form_undirflokkur;
echo $form_aettbalkur;
echo $form_undiraettbalkur;
echo $form_aett;
echo $form_undiraett;
echo $form_aettkvisl;
echo $form_tegund;
?> 

</body>
</html>

The database name, table name, host, user name, password have all been double checked for spelling mistakes (copy/paste from hosting provider).

Right now, when I type in some data and hit the submit button the page jumps to the PHP page which is blank (no SQL errors appear). But in phpMyAdmin, the data has not been inserted into the table.

Any help would be great

Jack Franklin · #2 Jan 19th, 2008, 21:05

Hmm.

PHP: Select all


query = "INSERT INTO $db_table (id,Len,Riki,Fylking,Undirfylking,Flokkur,Undirflokkur,Aettbalkur,Undiraettbalkur,Aett,Undiraett,Aettkvisl,Tegund,Heiti) VALUES ('','$form_len','$form_riki','$form_fylking','$form_undirfylking','$form_flokkur','$form_undirflokkur','$form_aettbalkur','$form_undiraettbalkur','$form_aett','$form_undiraett','$form_aettkvisl','$form_tegund')";
$result = mysql_query($query);

The thing I would suggest is, you should not be inserting a value of null into the id field, I presume that is your Primary Key, and in your screen it says it cannot be null.

So try:

PHP: Select all


query = "INSERT INTO $db_table (Len,Riki,Fylking,Undirfylking,Flokkur,Undirflokkur,Aettbalkur,Undiraettbalkur,Aett,Undiraett,Aettkvisl,Tegund,Heiti) VALUES ('$form_len','$form_riki','$form_fylking','$form_undirfylking','$form_flokkur','$form_undirflokkur','$form_aettbalkur','$form_undiraettbalkur','$form_aett','$form_undiraett','$form_aettkvisl','$form_tegund')";
$result = mysql_query($query);

(Bear in mind I am only capable of simple PHP - some of the more advanced people here might see something I cant.)

HTH, Jack

Bravo81 · #3 Jan 19th, 2008, 21:10

First off, DO NOT include your DB Connection details, edit & remove them for security!

Only thing i can think of is $_GET ? instead of post, but then again im no PHP wiz.

~Dean

skuliaxe · #4 Jan 19th, 2008, 21:20

As you can all see, I´m new to all this. So thanks for all the help.

Quote:

Originally Posted by jackfranklin

The thing I would suggest is, you should not be inserting a value of null into the id field, I presume that is your Primary Key, and in your screen it says it cannot be null....
So try:

I fixed that, thanks. The 'id' is my primary key and is set to auto increment.

Quote:

Originally Posted by Bravo81

First off, DO NOT include your DB Connection details, edit & remove them for security!

Only thing i can think of is $_GET ? instead of post, but then again im no PHP wiz.

I edited that out, thanks. I didn't mean to have that info there. But after using copy/paste a few times I got it in there somehow

This is although just a test database right now.

I´ll read up on $_GET and see if that will help me. Thank you.

The PHP is echoing the right information that is entered in the Forms and there doesn't seem to be a database connection error.
So shouldn't the error lie in the Insert to table part?

PHP: Select all


// create and execute the query to insert data
$query = "INSERT INTO $db_table (Len,Riki,Fylking,Undirfylking,Flokkur,Undirflokkur,Aettbalkur,Undiraettbalkur,Aett,Undiraett,Aettkvisl,Tegund,Heiti) VALUES ('$form_len','$form_riki','$form_fylking','$form_undirfylking','$form_flokkur','$form_undirflokkur','$form_aettbalkur','$form_undiraettbalkur','$form_aett','$form_undiraett','$form_aettkvisl','$form_tegund')";
$result = mysql_query($query);

Bravo81 · #5 Jan 19th, 2008, 21:46

I dont see why you used $db_table in the INSERT, I would of just put the DB name in text..but again, im no PHP wiz and i dont belive that would stop your information going in.

I dont know if this will work, but try:

PHP: Select all


mysql_query($query);

instead of $result=

Thats all i could find after Googling.

Sorry im not much help,

~Dean

skuliaxe · #6 Jan 19th, 2008, 21:56

I just solved my issue.
I had to add $link...

OLD CODE

Code: Select all

mysql_connect($host, $db_user, $db_pass);

NEW CODE

Code: Select all

$link = mysql_connect($host, $db_user, $db_pass);

Thanks for all the help

Quote:

Originally Posted by Bravo81

Sorry im not much help,
~Dean

Any advice was greatly appreciated. Thank you.

Bravo81 · #7 Jan 19th, 2008, 22:05

Congrats on solving it yourself, that was my next suggestion. Honest! lol

[SOLVED]
(Always wanted to do that)

~Dean

alexgeek · #8 Jan 20th, 2008, 00:41

Quote:

Originally Posted by Bravo81

Congrats on solving it yourself, that was my next suggestion. Honest! lol

[SOLVED]
(Always wanted to do that)

~Dean

Always wanted to say "solved"? Ha.
Marked as solved.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
[SOLVED] Creating multiple dynamic list boxes from mysql database	davibugi	PHP Forum	11	Nov 20th, 2007 06:12
[SOLVED] Linking php code to a form & mysql database	longstand	PHP Forum	21	Oct 9th, 2007 16:40
php/mysql database fields into html list/menu	csun	PHP Forum	4	Jul 27th, 2007 16:04
How to connect flash form with Mysql database	shenbagarajan	Flash & Multimedia Forum	6	Jan 20th, 2006 19:59

		Webforumz.com > Main Forums > Program Your Website > PHP Forum
[SOLVED] Help with HTML form to database (mysql/php)!