Database insert record php problem.

futureking

include "libs/Smarty.class.php";


if ($_SERVER['REQUEST_METHOD'] == 'POST')
{

createdisk($_POST["title"],$_POST["desc"]);
}



function createdisk($title,$desc)
{
include "config.php";
$isemp="y";
	$conn=mysql_connect($dbhost,$dbuser,$dbpass,$dbname) or die("error connecting");
$query="INSERT INTO disk_main 
	(main_title, main_date, main_isemp, main_desc, main_avl)
	values ('$title', '".date("Ymd")."', '$isemp', '$desc', 'y')";



echo $query;
[B]	mysql_query($query) or die("error");[/B]

mysql_close($conn);
echo "Success!";
}

The above code is not working.
on line mysql_query($query) or die("error");
it gives "error" i.e. dies.

If I echo query then I get
INSERT INTO disk_main (main_title, main_date, main_isemp, main_desc, main_avl) values ('asa', '20081205', 'y', 'asaasa', 'y')

If I copy this SQL to MySql query manager then it runs fine.

Please help. I am very new to PHP.

YAOMK

could you post the error as it is given by the Php parser?

futureking

YAOMK;10895037 wrote:
could you post the error as it is given by the Php parser?

If I remove "die" statement then it does not show any error. But still does not insert any record in db.

no error is coming from php

YAOMK

I suspect you have an extra parameter in mysql_connect(). Try to use this code instead and see for yourself:

$conn=mysql_connect($dbhost,$dbuser,$dbpass,$dbname) or die(mysql_error())

futureking

I tried this and
mysql_query($query) or die(mysql_error());
I got this error:
No database selected.
But I already selected database in
$conn=mysql_connect($dbhost,$dbuser,$dbpass,$dbname) or die(mysql_error());

YAOMK

I know, you do not select the database with mysql_connect() for that you use mysql_select_db(). For more information please refer to the Php Manual.

futureking

YAOMK;10895042 wrote:
I know, you do not select the database with mysql_connect() for that you use mysql_select_db(). For more information please refer to the Php Manual.

thanks, it worked. Thank you very much.

YAOMK

No problem, don't forget to mark the thread as resolved. Take care.