Help with PHP

voodoo465 · #1 Feb 27th, 2007, 15:11

I am a pretty novice programmer, I am a designer so please excuse my stupid mistakes. I am attempting to make a form that put info into a data base that can be called upon at a later time. I think I created the form, and part of the database, but it is not working, here is my code, if anyone can help.

This is the forms code:

<html>
<body>
<form action="http://www.tsunamiproductions.com/tsunami_db.php" method="post">
<strong>Episode Name</strong>:
<input type="text" name="name" />
<strong>Episode Number</strong>:
<input type="text" name="number" />
<p><strong>Segment 1 Run Time</strong>:
<input type="text" name="runtime" /></p>
National Spots Name: <input type="text" name="national_spot_name" />
National Spots Run Time: <input type="text" name="national_spot_run_time" />
<br><br>Local Spots Name: <input type="text" name="local_spot_name" />
Local Spots Run Time: <input type="text" name="local_spot_run_time" /></br></br>

<p><strong>Segment 2 Run Time</strong>:
<input type="text" name="2runtime" /></p>
National Spots Name: <input type="text" name="2national_spot_name" />
National Spots Run Time: <input type="text" name="2national_spot_run_time" />
<br><br>Local Spots Name: <input type="text" name="2local_spot_name" />
Local Spots Run Time: <input type="text" name="2local_spot_run_time" /></br></br>

<p><strong>Segment 3 Run Time</strong>:
<input type="text" name="3runtime" /></p>
National Spots Name: <input type="text" name="3national_spot_name" />
National Spots Run Time: <input type="text" name="3national_spot_run_time" />
<br><br>Local Spots Name: <input type="text" name="3local_spot_name" />
Local Spots Run Time: <input type="text" name="3local_spot_run_time" /></br></br>

<p><strong>Segment 4 Run Time</strong>:
<input type="text" name="4runtime" /></p>
National Spots Name: <input type="text" name="4national_spot_name" />
National Spots Run Time: <input type="text" name="4national_spot_run_time" />
<br><br>Local Spots Name: <input type="text" name="4local_spot_name" />
Local Spots Run Time: <input type="text" name="4local_spot_run_time" /></br></br>

<p><strong>Segment 5 Run Time</strong>:
<input type="text" name="5runtime" /></p>

<p><strong>Total Run Time</strong>:
<input type="text" name="total_runtime" /></p>
<input type="submit" />
</form>
</body>
</html>

and here is the database code for a database called tsunami_db.php

<html>
<head>
<title>Untitled Document</title>
</head>

<body>
<?php
$con = mysql_connect("server","user","PW");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
if (mysql_query("CREATE DATABASE tsunamishows_db",$con))
{
echo "Database created";
}
else
{
echo "Error creating database: " . mysql_error();
}
// Create table in tsunamishows_db database
mysql_select_db("tsunamishows_db", $con);
$sql = "CREATE TABLE GirlsGoneFishin
(
runtime varchar(25),
national_spot_name varchar(25),
Age int
)";
mysql_query($sql,$con);
mysql_close($con);
?>
</body>
</html>

obviously, i covered up the password and user name and all of that for privacy, but can anyone help me figure out what is wrong with this code???

Thank You for your help.

-Scott

karinne · #2 Feb 27th, 2007, 15:31

What's happening? What's not working?! Do you get an error?

voodoo465 · #3 Feb 27th, 2007, 15:36

i don't get anything, I am not sure what is supposed to happen. It just kinda freezes up, which is why I feel like I have something wrong in the code. Like I said I am very beginner with this sort of stuff. What is supposed to happen?? Thanks for your help

voodoo465 · #4 Feb 27th, 2007, 15:38

Could not connect: Lost connection to MySQL server during query

Now it gives me this error after about a minute or two

karinne · #5 Feb 28th, 2007, 13:29

Why are you creating the database and the table every time? You should have it created only once.

BTW ... I trashed the thread you just created in the New to Web Design section ... don't double-post!

voodoo465 · #6 Feb 28th, 2007, 13:32

ok, thats fine. I really don't know what I'm doing, like I said. So is that the problem? that I am creating them twice?

karinne · #7 Feb 28th, 2007, 13:51

Maybe... I'm not sure. I don't have access to my server from here so I can't test but you should definately fix that. You should create the DB twice and the table twice. Check if it's created, if not, create, then go do the inserts.

voodoo465 · #8 Feb 28th, 2007, 13:52

ok i iwll give it a try, thanks again for the help

karinne · #9 Feb 28th, 2007, 13:53

No problem ... let us know how it goes.

		Webforumz.com > Main Forums > Program Your Website > PHP Forum
Help with PHP