[RESOLVED] Inserting into MySQL

Yippee

OK, here's the code:

<?php
error_reporting(E_ALL);

include("********");

$connect = mysqli_connect($host,$account,$password);
$db = mysqli_select_db($connect,$dbname);

$testa = 3;
$testb = 7;
$sql = "INSERT INTO testTable (testa,testb) VALUES ($testa,$testb)";
$result = mysqli_query($sql);

mysql_close($connect);
?>

Include has been starred out for security reasons, because I will be using this database, but $host contains the server hosting the database, $account is my account name, $password is the password to the database, and $dbname is the name of the specific database I'm trying to access.

I'm sure, because of tests I put in place, that it's connecting to the server and the database successfully, but it won't insert the information.

Both fields are set up to receive integers, and they're the only two fields in that table. I really don't know what other information you might need, but ask and I'll give it to you, unless you're asking for something like the password to my database...that's just not cool. 😛

Here's the file with the tests in place and the code for it, for those interested:

http://mechhelp.net/database/

<?php
error_reporting(E_ALL);

include("********");
$connect = mysqli_connect($host,$account,$password);

if ($connect) {
echo "Connected to server<br>";
} else {
echo "Server connection error<br>";
}

$db = mysqli_select_db($connect,$dbname);

if ($db) {
echo "Connected to database<br>";
} else {
echo "Database connection error<br>";
}

$testa = 3;
$testb = 7;
$sql = "INSERT INTO testTable (testa,testb) VALUES ($testa,$testb)";
$result = mysqli_query($sql);

if ($result) {
echo "Insert successful";
} else {
echo "Insert error";
}

mysql_close($connect);
?>

bpat1434

Out of curiosity... instead of just saying "Insert error", have you tried echoing mysqli_error() to see the exact error MySQL is throwing?

Yippee

bpat1434;10923614 wrote:
Out of curiosity... instead of just saying "Insert error", have you tried echoing mysqli_error() to see the exact error MySQL is throwing?

Yes, and it doesn't say anything at all. Try http://mechhelp.net/database/ again, it's the same as shown above, except with "echo mysqli_error();" right below the other echo statement.

Oh, the site is hosted at byethost.com, so it's using there php.ini file and whatever, if that helps any.

mblack0508

Yippee;10923621 wrote:
Yes, and it doesn't say anything at all. Try http://mechhelp.net/database/ again, it's the same as shown above, except with "echo mysqli_error();" right below the other echo statement.

Oh, the site is hosted at byethost.com, so it's using there php.ini file and whatever, if that helps any.

I would recommend using PDO, its a lot better in my opinion than using driver specific extensions.

I cant tell with the code exactly but one problem is that php doesnt really use type specific variables, ie integers can be treated as strings, mysql on the other hand needs specifics

So to translate what I'm thinking

I dont see anything indicating you're echoing out the values of mysqli_error or using the function properly (like providing your link idenfitier as a param to mysqli_error). I suspect that the issue is that you're having a syntax error like having a string field but with an integer values.

PDO is fairly simple to use, here is an example of what you're doing but in PDO.

try {
$dbh = PDO("mysql:host=localhost;dbname=mydb", $user, $pass);
}
catch (PDOException $ex) {
   echo $ex->getMessage();
}

$testa = 3;
$testb = 7;

$sql = "INSERT INTO testTable(testa, testb) VALUES(?,?)";

$stmt = $dbh->prepare($sql);
$stmt->bindParam(1, $testa, PDO::PARAM_INT);
$stmt->bindParam(2, $testb, PDO::PARAM_INT);
try {
$stmt->execute();
$res = $stmt->fetch();
}
catch (PDOException $ex) {
echo $ex->getMessage();
}

Yippee

Ah, I wasn't using mysqli_error() correctly, but I think I am now and it's still not outputting anything.

error_reporting(E_ALL);

include("dataInfo.php");
$connect = mysqli_connect($host,$account,$password);

if ($connect) {
echo "Connected to server<br>";
} else {
echo "Server connection error<br>";
}

$db = mysqli_select_db($connect,$dbname);

if ($db) {
echo "Connected to database<br>";
} else {
echo "Database connection error<br>";
}

$testa = 3;
$testb = 7;
$sql = "INSERT INTO testTable (testa,testb) VALUES ($testa,$testb)";
$result = mysqli_query($sql);

if ($result) {
echo "Insert successful";
} else {
echo "Insert error - ";
echo mysqli_error($connect);
}

mysql_close($connect);

As far as the type specific variables, according to the book I've been learning PHP out of, strings get quotes around them, and integers don't. For example, if I was inputting strings, I would type the $sql string as so:

$sql = "INSERT INTO testTable (testa,testb) VALUES ('$testa','$testb')";

I've gone into the database control panel and inserted the query manually, and that works, so there's nothing wrong with "INSERT INTO testTable (testa,testb) VALUES (7,3)". It seems the problem has to be with the $testa and $testb variables, or with sending the query. If it's not either, it has to be something on the database side...do databases have permission settings? :queasy:

As far as the code you gave me, I messed around with it some, but I don't understand enough of it, and I can't even get it to give me an error report. I'm thinking about going through the hassle of setting up a PHP environment right on my computer just to get error reports when I need 'em, lol.

WOOT! I am so stupid...all I had to do was read the book closer.

$result = mysqli_query($sql);

...should have been...

$result = mysqli_query($connect,$sql);

AND IT WORKS!

Sorry about the double post, but I can't find any edit button around here...