insert problem

[divinedesigns1]

hey guys, im having a problem inserting information into my database once again i dont know what im doing wrong i even check the w3s tutorial on this and its exactly what im doing

<?phpif(isset($_GET['action'])){$action = $_GET['action'];if($action == "news"){  // creating a new Blog	    echo '<h3>New Blog</h3>';   if(isset($_POST['submit'])){    [color=#ff0000]$title = $_POST['title'];    $article = $_POST['article'];[/color]       if(empty($title) && empty($article)){	 echo 'Please Fill In All Fields';    }elseif(!empty($title) && empty($article)){	 echo 'Article: ' . 'Some text is required';    }elseif(empty($title) && !empty($article)){	 echo 'Title: ' . 'A Title Is Required';    }elseif(!empty($title) && !empty($article)){	 // filter the title and article	 $title = mysqli_real_escape_string($con, $title);	 $article = mysqli_real_escape_string($con, $article);	 $title = stripslashes($title);	 $title = strip_tags($title);	 $article = stripslashes($article);	 $article = strip_tags($article); 		 [color=#00ff00]$query = "INSERT INTO  `php`.`ent` (`id` ,`title` ,`body` ,`user`)	 VALUES ('' ,  '$title',  '$article',  '" . $_SESSION['uid'] . "')" or die('Error: ' . mysqli_error());[/color]		 echo 'Your Blog Have Been Post';    }   }else{			 echo '<table align="center" border="0" width="500" bgcolor="#ccc">';			 echo '<form action="admin.php?action=new" method="post">';			 echo '<tr>';			 echo '<td>Title</td>';			 echo '<td><input type="text" [color=#ff0000]name="title"[/color] /></td>';			 echo '</tr>';			 echo '<tr>';			 echo '<td>Article</td>';			 echo '<td><textarea [color=#ff0000]name="article"[/color] row="7"></textarea></td>';			 echo '</tr>';			 echo '<tr>';			 echo '<td colspan="2"><input type="submit" name="submit" value="Save" /></td>';			 echo '</tr>';			 echo '</form>';			 echo '</table>';      }}elseif($action == "edit"){  // Editing the blog  ?>

see its correct just as it should$query = "INSERT INTO `php`.`ent` (`id` ,`title` ,`body` ,`user`) VALUES ('' , '$title', '$article', '" . $_SESSION['uid'] . "')" or die('Error: ' . mysqli_error());and i place the value in the correct order also, the $_session['uid'] come from the the session set on the login page and there is a session_start(); at the top of the page, ahhh can someone help me with this please and thanks

[divinedesigns1]

Ok im still having problems with this, i fix part of the error but it still not inserting the information into the database, anyone can help?

Edited July 29, 2012 by DDs1

[dsonesuk]

What is `php`.`ent` supposed to represent or refer to?

[divinedesigns1]

What is `php`.`ent` supposed to represent or refer to?

php is the database name and ent is the table in that database

[dsonesuk]

you refer to table name in INSERT, the db is defined through mysql_select_db().

[divinedesigns1]

you refer to table name in INSERT, the db is defined through mysql_select_db().

correct, but even if i just refer the table name "ent" the information still wouldnt insert into the db, this is the updated code which still giving the query problem, well i dont think its the query, because when i do a var_dump() and print_r() i get back the value, mostly when i do a var_dump(); i get back boolen true/false depending on the situation but this time it give me the value

<?phpif(isset($_SESSION['uid'])){// if log in display the below menu?><table align="center" width="800"><tr><td width="663"><?phpif(isset($_GET['action'])){$action = $_GET['action'];if($action == "news"){  // creating a new Blog		echo '<h3>New Blog</h3>';   if(isset($_POST['submit'])){	$title = $_POST['title'];	$article = $_POST['article'];  	if(empty($title) && empty($article)){	 echo 'Please Fill In All Fields';	}	if(!empty($title) && empty($article)){	 echo 'Article: ' . 'Some text is required';	}	if(empty($title) && !empty($article)){	 echo 'Title: ' . 'A Title Is Required';	}	if(!empty($title) && !empty($article)){	 // filter the title and article	 $title = mysqli_real_escape_string($con, $title);	 $article = mysqli_real_escape_string($con, $article);	 $title = stripslashes($title);	 $title = strip_tags($title);	 $article = stripslashes($article);	 $article = strip_tags($article);		 $query = "INSERT INTO article(title, body, post_user) VALUES('$title', '$article', '" . $_SESSION['uid'] . "')";	 if(!$query){	  die('Error: ' . mysqli_error());	 }		 echo 'Your Blog Have Been Post';	}   }else{	?>

note: the connection to the db is at the very top with the session_start() function

Edited July 29, 2012 by DDs1

[dsonesuk]

Also instead of '' for the value of id, try NULL.

[divinedesigns1]

Also instead of '' for the value of id, try NULL.

yup i tired that also, still nothing ahhh this is giving me a headache

[birbal]

without using mysql_select_db() it is also possible to get any database's table specifying db schema like "databasename.tablename"

[divinedesigns1]

without using mysql_select_db() it is also possible to get any database's table specifying db schema like "databasename.tablename"

okie thanks birbal and dsonesuk i got it working thanks to birbal, i forgot the mysqli_query