form - add new record

[-LEVI-]

im trying to create a form where the user can add a new record to the database.
I haven't really found anything useful (maybe i didnt look hard enough ) but here's what ive come up with:

<?php
include_once('header.inc');
$title = $_POST['title'];
$joke = $_POST['joke'];
$author = $_POST['author'];

$connection = mysql_connect("localhost", "root") or die ("Unable to Connect to database");
mysql_select_db("levinteractive") or die ("Unable ro select database");
$last_id = ("SELECT id FROM jokes LAST_INSERT_ID");
$id = ($last_id + '1');
$sqladd = ("INSERT INTO jokes VALUES ($id, $title, $joke, $language, $date, $author)");
$result = mysql_query($sqladd)
dbase_add_record ($sqladd);

mysql_close($connection);
?>

So the form is submitted and I think something like this needs to happen. title, joke, author variables are coming from the form.
The id should be determined by the biggest id number in the database.
The date is a datetime in the database so I'm not sure what to do with that.
help's appreciated.

[zhabala]

You can use AUTO_INCREMENT field in MySQL for columns which will contain ID for row. MySQL then automatically increments value of this field.

For actual date or time you can probably use MySQL function named now();

SELECT now();

this statement returns actual date and time. You can write statement like:

INSERT INTO table ( column ) values ( now() );

it will insert actual date into column if the column is type of date

Zdenek

[-LEVI-]

cool thanks, it seems to go through that part of the code now.

it still doesn't like the code dbase_add_record($sqladd). There's some unexpected T-STRING error.
Is that the right code at all? Am I suppose to use dbase_add_record?

thanks for the help

[zhabala]

It seems, that this is unnecessary, the INSERT is executed with mysql_query function.

Why do you have this dbase_add_record($sqladd) statement there ?

Zdenek

[-LEVI-]

well im totally new to this im just kinda trying to put it together with what i see online :/

I'm thinking I should be getting an integer for the $id variable. when I echo that though, all I get is the code I put there.

[zhabala]

Ohh, I see,

now I see the mistake:

$last_id = ("SELECT id FROM jokes LAST_INSERT_ID");
$id = ($last_id + '1');
$sqladd = ("INSERT INTO jokes VALUES ($id, $title, $joke, $language, $date, $author)");
$result = mysql_query($sqladd);
dbase_add_record ($sqladd);

the row:

$last_id = ("SELECT id FROM jokes LAST_INSERT_ID");

does nothing with DB, you have and $last_id variable which contains a string "SELECT id FROM jokes LAST_INSERT_ID".
But it is not executed anywhere, and each SQL statement must be executed. And it should be probaly SQL statement which returns the maximal inserted ID. It should look like:

SELECT max(id) FROM jokes;

then
$sql = "SELECT max(id) as last_id FROM jokes";
$result = mysql_query($sql);
$row = mysql_fetch_array($result);

then
$row["last_id"] should contain the maximum id from table named jokes

But as I mentioned before you can use an AUTO_INCREMENT. In this case you do not insert into this column and MySQL will do that automatically.

It is not so easy ;-)

Zdenek

[-LEVI-]

he it sure is not easy, but at least it makes some sense🙂 thanks, I'll try the code. if u ever need help in flash just let me know hehe🙂

[Imitation]

I am a newbie and I am having similar problems.. I ended up butchering my code so much trying to get it to work that I will have to rewrite it. I am also getting t_string errors but I have no idea what it actually means. Is there an actual definition for the error because there is nothing I could find to help me on this. I would post my code.. but... there's not much of it left 🙂

[zhabala]

OK, post here a source if you want me to inspect it.

I think, that the actual definition does not exist for t_string errors.

Zdenek

[-LEVI-]

i got the t-string error when i didnt put the strings in quotations

like this:

$sqladd = ("INSERT INTO jokes (title, joke, language, date, author) VALUES('$title', '$joke', '$language', 'now()', '$author')");

so it's not $string, instead '$string'

for the id this is what i used finally:

$id = mysql_insert_id();

oh the date still doesn't work. I just get 0's for those values :/ Do you have any ideas zdenek?

[zhabala]

now() is a function, it can't be enclosed in apostrophes. Try this:

$sqladd = ("INSERT INTO jokes (title, joke, language, date, author) VALUES('$title', '$joke', '$language', now(), '$author')")

Zdenek

[-LEVI-]

oh yea it works now, thanks again🙂