I have a problem about insert data to database.

Question

0.00/5 (No votes)

See more:

I want to make a messageboard with php.
but I cant't insert data to database.
I dont know what's wrong in my code???
Can someone help me please?

HTML

<!DOCTYPE  HTML>
<html>
<head>
<title> 留言板 </title>
</head>


<body>
<form action="insert.php" method="get">
請輸入名稱: <input type="text" name="name" />
請輸入標題: <input type="text" name="title" />
請輸入留言: <input type="text" name="message"   />
請輸入電子郵件: <input type="text" name="email" />
<input    type="submit"  value="送出留言" name="post"  />
</form>

</body>
</html>

PHP

<?php
//This is insert.php

require_once("connectdb.php");// It is success!!


if(isset($_GET["name"])!=""){
    $query_insert = "INSERT INTO '1100108128'.'MB'
    ('USER','TITLE','MESSAGE','TIME','EMAIL')
VALUES (";$query_insert .= "'".$_GET["name"]."',";
    $query_insert .= "'".$_GET["title"]."',";
    $query_insert .= "'".$_GET["message"]."',";
    $query_insert .= "NOW(),";
    $query_insert .= "'".$_GET["email"]."')";
mysql_query($query_insert);
header("Location:Messageboard.php");
}
 ?>

Posted 24-Dec-12 1:47am

陳建勳

Add a Solution

Comments

snorkie 24-Dec-12 9:01am

What is the error you're getting from the database?

陳建勳 24-Dec-12 9:56am

my code can be execution but my database is not received .

[no name] 24-Dec-12 9:15am

Tip:
print the query using echo $query_insert
check the printed version and check for any errors.

陳建勳 24-Dec-12 9:51am

I use the echo and get this: INSERT INTO '1100108128'.'MB' ('USER','TITLE','MESSAGE','TIME','EMAIL') VALUES ('test','test','test',NOW(),'test')
I think it doesn't have any problem!!

snorkie 24-Dec-12 10:01am

try adding some debugging: http://php.net/manual/en/function.mysql-query.php is a great place to start with query examples and debugging to go with it. see if they query returns true or false. I bet it'll end up being a permission issue.

[no name] 24-Dec-12 10:01am

if you write the error msg here then that would be really helpful

陳建勳 25-Dec-12 2:41am

Ok!
I add if(!@mysql_query($query_insert))
die ("Invalid query");

and it return "Invalid query"
but I don't know why??

umermhr 26-Dec-12 5:52am

I Think mistake in if condition...
just remove isset function and then run the code...

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

umermhr · Answer 1 · 2012-12-25T23:53:00

Solution 1

I Think mistake in if condition...
just remove isset function and then run the code...

Posted 25-Dec-12 23:53pm

umermhr

Graham Breach · Answer 2 · 2012-12-26T00:45:00

Solution 2

I think the problem is in the way you have quoted the table name - they should be quoted with backtick characters ( ` ), but you have used apostrophes ( ' ). See the manual[^] for details.

Posted 26-Dec-12 0:45am

Graham Breach

陳建勳 · Answer 3 · 2012-12-26T05:28:00

OK!
I have solved the problem.
It seems due to the part of NOW();

PHP

require_once("connectdb.php");


if(isset($_GET["name"])!=""){
	$query_insert = "INSERT INTO `1100108128`.`MB` (`ID`,`USER`,`TITLE`,`MESSAGE`,`TIME`,`EMAIL`) VALUES (";
	$query_insert .= "NULL,";
	$query_insert .= "'".$_GET["name"]."',";
	$query_insert .= "'".$_GET["title"]."',";
	$query_insert .= "'".$_GET["message"]."',";
	$query_insert .= "'" . date('Y-m-d') . "',";
	$query_insert .= "'".$_GET["email"]."');";
	
	if(!mysql_query($query_insert))
		die ("Invalid query");
	
	header("Location:Messageboard.php");
}

 ?>