Request: PHP/MySQL Help

[tikkus]

So I've been taking a break from C++ and have been delving into PHP/MySQL.

I'm having the most insane problem adding information to my database. I have a database named wowqdb with a table called "simple" with only one parameter ("name"). I'm almost 90% confident that my syntax is correct, but for some reason when I get to mysqli_query() it fails .

Any assistance would be appreciated.

$dbName = "wowqdb";
$host = "localhost";
$usrName = "root";
$usrPass = "elofedgela";
$name = $_POST["name"];

$mysqli = mysqli_connect($host, $usrName, $usrPass);

if ($mysqli == TRUE) {
echo "Connected successfully
";
}
else
{
echo "Connection failed";
}

$mysqliQuery = "INSERT INTO simple VALUES ('Bah')";

if (mysqli_query("$mysqliQuery") or die ("Bah!")) {
echo "A record has been inserted.";
}
else {
echo "Couldn't insert record.";
}

mysqli_close($mysqli);

Again, it just dies. =\

[Furism]

I'm not too familiar with this function, as I usually use mysql_query. But a quick look on php.net tells me that you need to specify more arguments in the query.

Anyway, the SQL query itself is not correct. I believe you forgot to specify the field name in the table. With a mysql_query it would look like this:

mysql_query("INSERT INTO simple (name) VALUES ('$foo')")
or DIE("Couldn't insert!" .mysql_error());

Which has the advantage of printing an SQL error message in case the query fails.

[tikkus]

Didn't work. =\

If you don't specify the field name I'm pretty sure it just automatically fills the table with values in order.

It might have something to do with my database configuration, I'm pretty lost on setting up all of the table parameters.

[tikkus]

This is my output, btw:

Testing
Connected successfully
Bah!

[Zippygoose]

Are you certain that your table and column names are correct and that your column type is varchar?

[Furism]

Originally Posted by tikkus

If you don't specify the field name I'm pretty sure it just automatically fills the table with values in order.

Did you actually try to specify the field name even if there's only one?

[tikkus]

Yeah, I did. Same results.

[tikkus]

Originally Posted by Zippygoose

Are you certain that your table and column names are correct and that your column type is varchar?

It was TEXT, I wasn't aware that it should be a certain type. I can't find any reference on the different column types.

Changed it to VARCHAR and am still getting the same results. Also added it as primary key and it didn't change anything. =\

What should the collation be? It's set as utf_general_ci.

[Maio]

Originally Posted by tikkus

if (mysqli_query("$mysqliQuery") or die ("Bah!"))

Try:

Originally Posted by Maio

if (mysqli_query( $mysqliQuery ) or die ("Bah!"))

..without the quotation marks.

[Rufus]

the above should fix this particular issue. You could also have it die and throw the last mysql error, which would help in debugging.

if (mysqli_query( $mysqliQuery ) or die (mysqli_error()))

[Furism]

For my own education, what's the difference between mysqli_query and the regular mysql_query?

[tikkus]

I'm not exactly sure. I installed Apache/PHP/Ruby/MySQL on my own PC using some guide I got from the internet and it told me to uncomment the mysqli portion of the php.ini.

Supposedly, its supposed to be faster but a quick google shows you that it isn't the case in all situations.

mysql functions don't even work for me, I have to use mysqli.

Edit: PHP: MySQL Improved Extension - Manual

[elderec]

After you connect to the database server, you need to select the database you wish to work with before attempting to insert into it.

$jl = mysql_connect('hostname', 'username', 'password') or die('Could not connect: ' . mysql_error());
mysql_select_db("database",$jl) or die(mysql_error());
$sql = 'INSERT INTO simple VALUES ('Bah')';
mysql_query($sql);
mysql_close($jl);

[Rufus]

Originally Posted by Furism

For my own education, what's the difference between mysqli_query and the regular mysql_query?

Some performance differences...

MySQLi vs MySQL (benchmarks)

I also believe mysqli is required to access some of the newer features in mysql 5.

[Furism]

Originally Posted by Rufus

Some performance differences...

MySQLi vs MySQL (benchmarks)

I also believe mysqli is required to access some of the newer features in mysql 5.

Thanks for that link. Looks like for small to medium-sized website you want to stick to mysql_query.