php-general Digest 1 Oct 2012 16:37:18 -0000 Issue 7989
Topics (messages 319304 through 319318):
Re: php can't insert data mysql table
319304 by: Tim Dunphy
319305 by: Ken Robinson
319309 by: Jim Giner
319310 by: Tommy Pham
319311 by: Jim Giner
319312 by: Tommy Pham
319313 by: Stuart Dallas
319314 by: Jim Giner
319315 by: Jim Giner
319316 by: Tim Dunphy
319317 by: Jim Giner
SSHA Password Encryption
319306 by: Coþkun Baðrýaçýk
319307 by: Matijn Woudt
319308 by: viper
Basic Statistics
319318 by: George R Smith
Administrivia:
To subscribe to the digest, e-mail:
php-general-digest-subscr...@lists.php.net
To unsubscribe from the digest, e-mail:
php-general-digest-unsubscr...@lists.php.net
To post to the list, e-mail:
php-gene...@lists.php.net
----------------------------------------------------------------------
--- Begin Message ---
Oh btw, forgot to mention...here is the table definition.. sorry just
realized you needed to know that
mysql> describe guitarwars;
+------------+-------------+------+-----+-------------------+-----------------------------+
| Field | Type | Null | Key | Default |
Extra |
+------------+-------------+------+-----+-------------------+-----------------------------+
| id | int(11) | NO | PRI | 0
| |
| date | timestamp | NO | | CURRENT_TIMESTAMP | on update
CURRENT_TIMESTAMP |
| name | varchar(32) | YES | MUL | NULL
| |
| screenshot | varchar(30) | YES | | NULL
| |
+------------+-------------+------+-----+-------------------+-----------------------------+
4 rows in set (0.00 sec)
thanks again!
On Mon, Oct 1, 2012 at 12:32 AM, Tim Dunphy <bluethu...@gmail.com> wrote:
> Hello list,
>
> I'm trying to learn and get comfortable with HTML forms in PHP. In one
> example I am trying to include a file upload in one of the forms. I can
> connect to the database but for some reason the MySQL query string is bad.
> I've been over this for a while now and I think the problem is with the
> form. I was hoping to get the esteemed opinion of the list in where I may
> be going wrong.
>
> This code:
>
> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
> "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd";>
> <html xmlns="http://www.w3.org/1999/xhtml"; xml:lang="en" lang="en">
> <head>
> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
> <title>Guitar Wars - Add Your High Score</title>
> <link rel="stylesheet" type="text/css" href="style.css" />
> </head>
> <body>
> <h2>Guitar Wars - Add Your High Score</h2>
>
> <?php
> if (isset($_POST['submit'])) {
> // Grab the score data from the POST
> $name = $_POST['name'];
> $score = $_POST['score'];
> $screenshot = $_FILES['screenshot']['name'];
>
> if (!empty($name) && !empty($score)) {
> // Connect to the database
> $dbc = mysqli_connect('localhost', 'admin', 'secretsauce', 'gwdb')
> or die('Cannot connect to database');
>
> // Write the data to the database
> $query = "INSERT INTO guitarwars VALUES (0, NOW(), '$name',
> '$score', '$screenshot')";
> mysqli_query($dbc, $query)
> or die('Cannot insert query');
>
> // Confirm success with the user
> echo '<p>Thanks for adding your new high score!</p>';
> echo '<p><strong>Name:</strong> ' . $name . '<br />';
> echo '<strong>Score:</strong> ' . $score . '</p>';
> echo '<p><a href="index.php"><< Back to high scores</a></p>';
>
> // Clear the score data to clear the form
> $name = "";
> $score = "";
>
> mysqli_close($dbc);
> }
> else {
> echo '<p class="error">Please enter all of the information to add
> your high score.</p>';
> }
> }
> ?>
>
> <hr />
> <form enctype="multipart/form-data" method="post" action="<?php echo
> $_SERVER['PHP_SELF']; ?>">
> <input type="hidden" name="MAX_FILE_SIZE" value="32768" />
> <label for="name">Name:</label>
> <input type="text" id="name" name="name" value="<?php if
> (!empty($name)) echo $name; ?>" /><br />
> <label for="score">Score:</label>
> <input type="text" id="score" name="score" value="<?php if
> (!empty($score)) echo $score; ?>" />
> <br />
> <label for="screenshot">Screenshot:</label>
> <input type="file" id="screenshot" name="screenshot" />
> <hr />
> <input type="submit" value="Add" name="submit" />
> </form>
> </body>
> </html>
>
> Results in this output:
>
> Guitar Wars - Add Your High Score Cannot insert query
>
> Thanks again for your help. This is an awesome list!
>
>
> Tim
>
> --
> GPG me!!
>
> gpg --keyserver pool.sks-keyservers.net --recv-keys F186197B
>
>
>
--
GPG me!!
gpg --keyserver pool.sks-keyservers.net --recv-keys F186197B
--- End Message ---
--- Begin Message ---
At 12:32 AM 10/1/2012, Tim Dunphy wrote:
Hello list,
I'm trying to learn and get comfortable with HTML forms in PHP. In one
example I am trying to include a file upload in one of the forms. I can
connect to the database but for some reason the MySQL query string is bad.
I've been over this for a while now and I think the problem is with the
form. I was hoping to get the esteemed opinion of the list in where I may
be going wrong.
This code:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd";>
<html xmlns="http://www.w3.org/1999/xhtml"; xml:lang="en" lang="en">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Guitar Wars - Add Your High Score</title>
<link rel="stylesheet" type="text/css" href="style.css" />
</head>
<body>
<h2>Guitar Wars - Add Your High Score</h2>
<?php
if (isset($_POST['submit'])) {
// Grab the score data from the POST
$name = $_POST['name'];
$score = $_POST['score'];
$screenshot = $_FILES['screenshot']['name'];
if (!empty($name) && !empty($score)) {
// Connect to the database
$dbc = mysqli_connect('localhost', 'xxx', 'xxx', 'gwdb')
or die('Cannot connect to database');
// Write the data to the database
$query = "INSERT INTO guitarwars VALUES (0, NOW(), '$name', '$score',
'$screenshot')";
mysqli_query($dbc, $query)
or die('Cannot insert query');
// Confirm success with the user
echo '<p>Thanks for adding your new high score!</p>';
echo '<p><strong>Name:</strong> ' . $name . '<br />';
echo '<strong>Score:</strong> ' . $score . '</p>';
echo '<p><a href="index.php"><< Back to high scores</a></p>';
// Clear the score data to clear the form
$name = "";
$score = "";
mysqli_close($dbc);
}
else {
echo '<p class="error">Please enter all of the information to add
your high score.</p>';
}
}
?>
[snip]
First -- NEVER post code with your database username/password. Since
you did, change your db password immediately.
Second, when debugging, if you use the die() function, put out
something meaningful like
... or die("Problem with the insert query: $query<br>" . mysqli($dbc));
Once you see the database error, you will probably be able to figure
out the problem.
Ken
--- End Message ---
--- Begin Message ---
On 10/1/2012 12:32 AM, Tim Dunphy wrote:
Hello list,
I'm trying to learn and get comfortable with HTML forms in PHP. In one
example I am trying to include a file upload in one of the forms. I can
connect to the database but for some reason the MySQL query string is bad.
I've been over this for a while now and I think the problem is with the
form. I was hoping to get the esteemed opinion of the list in where I may
be going wrong.
This code:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd";>
<html xmlns="http://www.w3.org/1999/xhtml"; xml:lang="en" lang="en">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Guitar Wars - Add Your High Score</title>
<link rel="stylesheet" type="text/css" href="style.css" />
</head>
<body>
<h2>Guitar Wars - Add Your High Score</h2>
<?php
if (isset($_POST['submit'])) {
// Grab the score data from the POST
$name = $_POST['name'];
$score = $_POST['score'];
$screenshot = $_FILES['screenshot']['name'];
if (!empty($name) && !empty($score)) {
// Connect to the database
$dbc = mysqli_connect('localhost', 'admin', 'secretsauce', 'gwdb')
or die('Cannot connect to database');
// Write the data to the database
$query = "INSERT INTO guitarwars VALUES (0, NOW(), '$name', '$score',
'$screenshot')";
mysqli_query($dbc, $query)
or die('Cannot insert query');
// Confirm success with the user
echo '<p>Thanks for adding your new high score!</p>';
echo '<p><strong>Name:</strong> ' . $name . '<br />';
echo '<strong>Score:</strong> ' . $score . '</p>';
echo '<p><a href="index.php"><< Back to high scores</a></p>';
// Clear the score data to clear the form
$name = "";
$score = "";
mysqli_close($dbc);
}
else {
echo '<p class="error">Please enter all of the information to add
your high score.</p>';
}
}
?>
<hr />
<form enctype="multipart/form-data" method="post" action="<?php echo
$_SERVER['PHP_SELF']; ?>">
<input type="hidden" name="MAX_FILE_SIZE" value="32768" />
<label for="name">Name:</label>
<input type="text" id="name" name="name" value="<?php if
(!empty($name)) echo $name; ?>" /><br />
<label for="score">Score:</label>
<input type="text" id="score" name="score" value="<?php if
(!empty($score)) echo $score; ?>" />
<br />
<label for="screenshot">Screenshot:</label>
<input type="file" id="screenshot" name="screenshot" />
<hr />
<input type="submit" value="Add" name="submit" />
</form>
</body>
</html>
Results in this output:
Guitar Wars - Add Your High Score Cannot insert query
Thanks again for your help. This is an awesome list!
Tim
You should have your error settings set to show everything.
I include these three lines in all my development work:
error_reporting(E_ALL);
ini_set('display_errors', '1');
set_time_limit(2);
In this case, I do think that your insert statement is incorrect - I
could be wrong. I think the VALUES clause s/b just 'VALUE'. Also if
you added MYSQLI_ERROR to your error handling you should get a very
helpful message.
--- End Message ---
--- Begin Message ---
On Mon, Oct 1, 2012 at 6:03 AM, Jim Giner <jim.gi...@albanyhandball.com> wrote:
> In this case, I do think that your insert statement is incorrect - I could
> be wrong. I think the VALUES clause s/b just 'VALUE'. Also if you added
> MYSQLI_ERROR to your error handling you should get a very helpful message.
>
VALUES also work. See http://dev.mysql.com/doc/refman/5.5/en/insert.html
--- End Message ---
--- Begin Message ---
On 10/1/2012 9:12 AM, Tommy Pham wrote:
On Mon, Oct 1, 2012 at 6:03 AM, Jim Giner <jim.gi...@albanyhandball.com> wrote:
In this case, I do think that your insert statement is incorrect - I could
be wrong. I think the VALUES clause s/b just 'VALUE'. Also if you added
MYSQLI_ERROR to your error handling you should get a very helpful message.
VALUES also work. See http://dev.mysql.com/doc/refman/5.5/en/insert.html
Yeah - I just saw it in one of my scripts.
So - adding the error handling and the call to mysqli_error should help
the OP diagnose his problem.
--- End Message ---
--- Begin Message ---
On Sun, Sep 30, 2012 at 9:32 PM, Tim Dunphy <bluethu...@gmail.com> wrote:
> Hello list,
>
> I'm trying to learn and get comfortable with HTML forms in PHP. In one
> example I am trying to include a file upload in one of the forms. I can
> connect to the database but for some reason the MySQL query string is bad.
> I've been over this for a while now and I think the problem is with the
> form. I was hoping to get the esteemed opinion of the list in where I may
> be going wrong.
>
> This code:
>
> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
> "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd";>
> <html xmlns="http://www.w3.org/1999/xhtml"; xml:lang="en" lang="en">
> <head>
> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
> <title>Guitar Wars - Add Your High Score</title>
> <link rel="stylesheet" type="text/css" href="style.css" />
> </head>
> <body>
> <h2>Guitar Wars - Add Your High Score</h2>
>
> <?php
> if (isset($_POST['submit'])) {
> // Grab the score data from the POST
> $name = $_POST['name'];
> $score = $_POST['score'];
> $screenshot = $_FILES['screenshot']['name'];
>
> if (!empty($name) && !empty($score)) {
> // Connect to the database
> $dbc = mysqli_connect('localhost', 'admin', 'secretsauce', 'gwdb')
> or die('Cannot connect to database');
>
> // Write the data to the database
> $query = "INSERT INTO guitarwars VALUES (0, NOW(), '$name', '$score',
> '$screenshot')";
> mysqli_query($dbc, $query)
> or die('Cannot insert query');
>
> // Confirm success with the user
> echo '<p>Thanks for adding your new high score!</p>';
> echo '<p><strong>Name:</strong> ' . $name . '<br />';
> echo '<strong>Score:</strong> ' . $score . '</p>';
> echo '<p><a href="index.php"><< Back to high scores</a></p>';
>
> // Clear the score data to clear the form
> $name = "";
> $score = "";
>
> mysqli_close($dbc);
> }
> else {
> echo '<p class="error">Please enter all of the information to add
> your high score.</p>';
> }
> }
> ?>
>
> <hr />
> <form enctype="multipart/form-data" method="post" action="<?php echo
> $_SERVER['PHP_SELF']; ?>">
> <input type="hidden" name="MAX_FILE_SIZE" value="32768" />
> <label for="name">Name:</label>
> <input type="text" id="name" name="name" value="<?php if
> (!empty($name)) echo $name; ?>" /><br />
> <label for="score">Score:</label>
> <input type="text" id="score" name="score" value="<?php if
> (!empty($score)) echo $score; ?>" />
> <br />
> <label for="screenshot">Screenshot:</label>
> <input type="file" id="screenshot" name="screenshot" />
> <hr />
> <input type="submit" value="Add" name="submit" />
> </form>
> </body>
> </html>
>
> Results in this output:
>
> Guitar Wars - Add Your High Score Cannot insert query
>
> Thanks again for your help. This is an awesome list!
>
>
> Tim
>
> --
> GPG me!!
>
> gpg --keyserver pool.sks-keyservers.net --recv-keys F186197B
What's the result of sql query "describe guitarwars;"? You can run
that query in phpmyadmin or command line.
--- End Message ---
--- Begin Message ---
On 1 Oct 2012, at 05:32, Tim Dunphy <bluethu...@gmail.com> wrote:
> Hello list,
>
> I'm trying to learn and get comfortable with HTML forms in PHP. In one
> example I am trying to include a file upload in one of the forms. I can
> connect to the database but for some reason the MySQL query string is bad.
> I've been over this for a while now and I think the problem is with the
> form. I was hoping to get the esteemed opinion of the list in where I may
> be going wrong.
>
> This code:
>
> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
> "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd";>
> <html xmlns="http://www.w3.org/1999/xhtml"; xml:lang="en" lang="en">
> <head>
> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
> <title>Guitar Wars - Add Your High Score</title>
> <link rel="stylesheet" type="text/css" href="style.css" />
> </head>
> <body>
> <h2>Guitar Wars - Add Your High Score</h2>
>
> <?php
> if (isset($_POST['submit'])) {
> // Grab the score data from the POST
> $name = $_POST['name'];
> $score = $_POST['score'];
> $screenshot = $_FILES['screenshot']['name'];
>
> if (!empty($name) && !empty($score)) {
> // Connect to the database
> $dbc = mysqli_connect('localhost', 'admin', 'secretsauce', 'gwdb')
> or die('Cannot connect to database');
>
> // Write the data to the database
> $query = "INSERT INTO guitarwars VALUES (0, NOW(), '$name', '$score',
> '$screenshot')";
> mysqli_query($dbc, $query)
> or die('Cannot insert query');
>
> // Confirm success with the user
> echo '<p>Thanks for adding your new high score!</p>';
> echo '<p><strong>Name:</strong> ' . $name . '<br />';
> echo '<strong>Score:</strong> ' . $score . '</p>';
> echo '<p><a href="index.php"><< Back to high scores</a></p>';
>
> // Clear the score data to clear the form
> $name = "";
> $score = "";
>
> mysqli_close($dbc);
> }
> else {
> echo '<p class="error">Please enter all of the information to add
> your high score.</p>';
> }
> }
> ?>
>
> <hr />
> <form enctype="multipart/form-data" method="post" action="<?php echo
> $_SERVER['PHP_SELF']; ?>">
> <input type="hidden" name="MAX_FILE_SIZE" value="32768" />
> <label for="name">Name:</label>
> <input type="text" id="name" name="name" value="<?php if
> (!empty($name)) echo $name; ?>" /><br />
> <label for="score">Score:</label>
> <input type="text" id="score" name="score" value="<?php if
> (!empty($score)) echo $score; ?>" />
> <br />
> <label for="screenshot">Screenshot:</label>
> <input type="file" id="screenshot" name="screenshot" />
> <hr />
> <input type="submit" value="Add" name="submit" />
> </form>
> </body>
> </html>
>
> Results in this output:
>
> Guitar Wars - Add Your High Score Cannot insert query
Assuming the first field is an autonumber you don't want to set it. Otherwise
every row you try to insert will have an ID of 0, which will be a unique index
clash after the first one.
But take note of what everyone else is saying. You should be getting the error
message when this happens which will tell you exactly what the problem is,
above and beyond "Cannot insert query" (which, btw, makes no sense at all :)).
-Stuart
--
Stuart Dallas
3ft9 Ltd
http://3ft9.com/
--- End Message ---
--- Begin Message ---
On 10/1/2012 12:32 AM, Tim Dunphy wrote:
Hello list,
I'm trying to learn and get comfortable with HTML forms in PHP. In one
example I am trying to include a file upload in one of the forms. I can
connect to the database but for some reason the MySQL query string is bad.
I've been over this for a while now and I think the problem is with the
form. I was hoping to get the esteemed opinion of the list in where I may
be going wrong.
This code:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd";>
<html xmlns="http://www.w3.org/1999/xhtml"; xml:lang="en" lang="en">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Guitar Wars - Add Your High Score</title>
<link rel="stylesheet" type="text/css" href="style.css" />
</head>
<body>
<h2>Guitar Wars - Add Your High Score</h2>
<?php
if (isset($_POST['submit'])) {
// Grab the score data from the POST
$name = $_POST['name'];
$score = $_POST['score'];
$screenshot = $_FILES['screenshot']['name'];
if (!empty($name) && !empty($score)) {
// Connect to the database
$dbc = mysqli_connect('localhost', 'admin', 'secretsauce', 'gwdb')
or die('Cannot connect to database');
// Write the data to the database
$query = "INSERT INTO guitarwars VALUES (0, NOW(), '$name', '$score',
'$screenshot')";
mysqli_query($dbc, $query)
or die('Cannot insert query');
// Confirm success with the user
echo '<p>Thanks for adding your new high score!</p>';
echo '<p><strong>Name:</strong> ' . $name . '<br />';
echo '<strong>Score:</strong> ' . $score . '</p>';
echo '<p><a href="index.php"><< Back to high scores</a></p>';
// Clear the score data to clear the form
$name = "";
$score = "";
mysqli_close($dbc);
}
else {
echo '<p class="error">Please enter all of the information to add
your high score.</p>';
}
}
?>
<hr />
<form enctype="multipart/form-data" method="post" action="<?php echo
$_SERVER['PHP_SELF']; ?>">
<input type="hidden" name="MAX_FILE_SIZE" value="32768" />
<label for="name">Name:</label>
<input type="text" id="name" name="name" value="<?php if
(!empty($name)) echo $name; ?>" /><br />
<label for="score">Score:</label>
<input type="text" id="score" name="score" value="<?php if
(!empty($score)) echo $score; ?>" />
<br />
<label for="screenshot">Screenshot:</label>
<input type="file" id="screenshot" name="screenshot" />
<hr />
<input type="submit" value="Add" name="submit" />
</form>
</body>
</html>
Results in this output:
Guitar Wars - Add Your High Score Cannot insert query
Thanks again for your help. This is an awesome list!
Tim
ON second glance - your table seems to have 4 fields:
id,date,id,name,screenshot.
Your insert has 5 values: VALUES (0, NOW(), '$name', '$score',
'$screenshot')
That right there is going to throw an error.
BTW - You're saving the name of the screen shot file but are you
actually saving the uploaded file somewhere else in your code? Didn't
see it here and just wondered.
--- End Message ---
--- Begin Message ---
oops - I added a an extra "id" field. There were only 4 in OP's
DESCRIBE email.
--- End Message ---
--- Begin Message ---
hey thanks guys adding debugging info worked.
Actually it was mysqli_error() providing me with a specific error of where
the problem was.
Cannot insert query:Duplicate entry '0' for key 'PRIMARY'
This is the data in the table
mysql> select * from guitarwars;
+----+---------------------+-------------------+-------+-------------------+
| id | date | name | score | screenshot |
+----+---------------------+-------------------+-------+-------------------+
| 0 | 2012-10-01 11:55:45 | Tommy Tutone | 2442 | bg_titlestrip.jpg |
| 1 | 2012-10-01 08:34:18 | Dunphy | 20000 | proof.jpg |
| 2 | 2012-10-01 00:25:53 | ray davies | NULL | 2241 |
| 3 | 2008-04-22 14:37:34 | Paco Jastorius | NULL | NULL |
| 4 | 2008-04-22 21:27:54 | Nevil Johansson | NULL | NULL |
| 5 | 2008-04-23 09:12:53 | Belita Chevy | NULL | NULL |
| 6 | 2008-04-23 14:09:50 | Kenny Lavitz | NULL | NULL |
| 7 | 2008-04-24 08:13:52 | Phiz Lairston | NULL | NULL |
| 8 | 2008-04-25 07:22:19 | Jean Paul Jones | NULL | NULL |
| 9 | 2008-04-25 11:49:23 | Jacob Scorcherson | NULL | NULL |
+----+---------------------+-------------------+-------+-------------------+
This was the query I was using:
$query = "INSERT INTO guitarwars (date, name, score, screenshot) VALUES
(NOW(), '$name', '$score', '$screenshot')";
It seems to be inserting a default value of 0 since the id is not being
specified and that's when I realized that I had failed to auto_increment
the id column. D'oh! So once I did that everything worked like a charm.
@Ken
>First -- NEVER post code with your database username/password. Since you
did, change your db password immediately.
Well actually I did not. Did you really think 'secretsauce' was my
password? :) But I guess you're right in that this may be a little
ambiguous when seeking advice in lists so from now on I will take your
advice on making login information unambiguously fake in the form of
user='xxxx' and password='xxx'.
@Stuart
But take note of what everyone else is saying. You should be getting the
error message when this happens which will tell you exactly what the
problem is, above and beyond "Cannot insert query" (which, btw, makes no
sense at all :)).
Ok well I'm using an 'insert' query so I'm not sure why you say that this
makes no sense at all. :)) If you don't mind giving this n00b advice what
would be a better/more accurate error message?
They take away from this for me was.. don't skimp on the error messages!
The one I got was so clear that fixing the problem was easy at that point.
But thanks again guys.. this list has been an indispensable source source
of wisdom on my journey in learning PHP.
Tim
Thanks again guys,
Tim
--
GPG me!!
gpg --keyserver pool.sks-keyservers.net --recv-keys F186197B
--- End Message ---
--- Begin Message ---
On 10/1/2012 12:20 PM, Tim Dunphy wrote:
hey thanks guys adding debugging info worked.
Actually it was mysqli_error() providing me with a specific error of where
the problem was.
Cannot insert query:Duplicate entry '0' for key 'PRIMARY'
This is the data in the table
mysql> select * from guitarwars;
+----+---------------------+-------------------+-------+-------------------+
| id | date | name | score | screenshot |
+----+---------------------+-------------------+-------+-------------------+
| 0 | 2012-10-01 11:55:45 | Tommy Tutone | 2442 | bg_titlestrip.jpg |
| 1 | 2012-10-01 08:34:18 | Dunphy | 20000 | proof.jpg |
| 2 | 2012-10-01 00:25:53 | ray davies | NULL | 2241 |
| 3 | 2008-04-22 14:37:34 | Paco Jastorius | NULL | NULL |
| 4 | 2008-04-22 21:27:54 | Nevil Johansson | NULL | NULL |
| 5 | 2008-04-23 09:12:53 | Belita Chevy | NULL | NULL |
| 6 | 2008-04-23 14:09:50 | Kenny Lavitz | NULL | NULL |
| 7 | 2008-04-24 08:13:52 | Phiz Lairston | NULL | NULL |
| 8 | 2008-04-25 07:22:19 | Jean Paul Jones | NULL | NULL |
| 9 | 2008-04-25 11:49:23 | Jacob Scorcherson | NULL | NULL |
+----+---------------------+-------------------+-------+-------------------+
This was the query I was using:
$query = "INSERT INTO guitarwars (date, name, score, screenshot) VALUES
(NOW(), '$name', '$score', '$screenshot')";
It seems to be inserting a default value of 0 since the id is not being
specified and that's when I realized that I had failed to auto_increment
the id column. D'oh! So once I did that everything worked like a charm.
@Ken
First -- NEVER post code with your database username/password. Since you
did, change your db password immediately.
Well actually I did not. Did you really think 'secretsauce' was my
password? :) But I guess you're right in that this may be a little
ambiguous when seeking advice in lists so from now on I will take your
advice on making login information unambiguously fake in the form of
user='xxxx' and password='xxx'.
@Stuart
But take note of what everyone else is saying. You should be getting the
error message when this happens which will tell you exactly what the
problem is, above and beyond "Cannot insert query" (which, btw, makes no
sense at all :)).
Ok well I'm using an 'insert' query so I'm not sure why you say that this
makes no sense at all. :)) If you don't mind giving this n00b advice what
would be a better/more accurate error message?
They take away from this for me was.. don't skimp on the error messages!
The one I got was so clear that fixing the problem was easy at that point.
But thanks again guys.. this list has been an indispensable source source
of wisdom on my journey in learning PHP.
Tim
Thanks again guys,
Tim
I think the comment about your "cannot insert query" was because it
really did not make sense. Once truly cannot "insert a query". Since
you ask tho, a more approp message might be
"Insert query failed to execute.<br>Error returned was " .
mysqli_error() . "<br>Query was $q"
As for your index issue - you are using an autoincrement(?) field as the
primary key. Is this related to another record in your db? If not, why
even have the primary key?
--- End Message ---
--- Begin Message ---
Hi guys,
I wanna change password into ldap directory, but password's encryption is
SSHA.
How do I encrypt the string to SSHA from php ?
Thanks.
--
*Coşkun Bağrıaçık*
*Mustafa Kemal Üniversitesi BAUM*
--- End Message ---
--- Begin Message ---
On Mon, Oct 1, 2012 at 1:01 PM, Coşkun Bağrıaçık
<coskun.bagria...@gmail.com> wrote:
> Hi guys,
>
> I wanna change password into ldap directory, but password's encryption is
> SSHA.
> How do I encrypt the string to SSHA from php ?
>
> Thanks.
>
Don't want to be rude, but did you try Google? There are plenty
examples out there how to do it in PHP.
- Matijn
--- End Message ---
--- Begin Message ---
On Mon, Oct 1, 2012 at 1:01 PM, Coşkun Bağrıaçık
<coskun.bagria...@gmail.com> wrote:
> Hi guys,
>
> I wanna change password into ldap directory, but password's encryption is
> SSHA.
> How do I encrypt the string to SSHA from php ?
http://php.net/manual/en/function.sha1.php
look @ user contribuited notes for "SSHA LDAP password generation
algorithm for standard PHP > 5.0 "
$salt = sha1(rand());
$salt = substr($salt, 0, 4);
$hash = base64_encode( sha1($password . $salt, true) . $salt );
return $hash;
--
+ http://vipertechnology.dyndns.org
() ascii ribbon campaign - against html e-mail
/\ www.asciiribbon.org - against proprietary attachments
+ http://vipertechnology.dyndns.org/cotnact/
--- End Message ---
--- Begin Message ---
Can anyone recommend a basic php stat package, easy to install and use.
Just basic stuff like mean, median, range std dev etc
thanks
george
--- End Message ---
