storing generated string in db

[up2trouble]

I wrote a program to generate a random code that the user would use to
gain access to a survey page. I got the code to generate fine;
however it will not store into the db. It gave me the generated code
then:
************************
hn3fXAaah1
Query failed cause: You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for the right
syntax to use near '' '' at line 1
************************
Help please.

<?PHP

if(isset($_POST['getcodes']))
{
$num = $_POST['num'];
$got = 0;

while ($got < $num)
{
$random = " ";// Initialize the string to store random numbers

srand((double)microtime()*1000000);

$block = "ABCDEFGHJKLMNPQRSTUVWXYZ";
$block .= "abcdefghjkmnpqrstuvwxyz";
$block .= "0123456789";

for($i = 0; $i < 10; $i++)
{
$random.= substr($block,(rand()%(strlen($block))), 1);
}

echo "$random<BR>";
$sql= "INSERT into $db_table10 (id) VALUES '$random'" ;
mysql_query ($sql) or die('Query failed cause: ' . mysql_error());
$got++;
}
}
?>

[Michael Austin]

up2trouble wrote:

I wrote a program to generate a random code that the user would use to
gain access to a survey page. I got the code to generate fine;
however it will not store into the db. It gave me the generated code
then:
************************
hn3fXAaah1
Query failed cause: You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for the right
syntax to use near '' '' at line 1
************************
Help please.

<?PHP

if(isset($_POST['getcodes']))
{
$num = $_POST['num'];
$got = 0;

while ($got < $num)
{
$random = " ";// Initialize the string to store random numbers

srand((double)microtime()*1000000);

$block = "ABCDEFGHJKLMNPQRSTUVWXYZ";
$block .= "abcdefghjkmnpqrstuvwxyz";
$block .= "0123456789";

for($i = 0; $i < 10; $i++)
{
$random.= substr($block,(rand()%(strlen($block))), 1);
}

echo "$random<BR>";
$sql= "INSERT into $db_table10 (id) VALUES '$random'" ;
mysql_query ($sql) or die('Query failed cause: ' . mysql_error());
$got++;
}
}
?>

what is the datatype of $db_table10 (id)?? Is ID a number? or varchar
field? My guess is a number - in which case you cannot store a text
value in a number field.

[Michael Fesser]

..oO(up2trouble)

>I wrote a program to generate a random code that the user would use to
gain access to a survey page. I got the code to generate fine;
however it will not store into the db. It gave me the generated code
then:
************************
hn3fXAaah1
Query failed cause: You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for the right
syntax to use near '' '' at line 1
************************
[...]

echo "$random<BR>";
$sql= "INSERT into $db_table10 (id) VALUES '$random'" ;
mysql_query ($sql) or die('Query failed cause: ' . mysql_error());
$got++;

$sql= "INSERT into $db_table10 (id) VALUES ('$random')";

Micha

[Michael Fesser]

..oO(up2trouble)

>while ($got < $num)
{
$random = " ";// Initialize the string to store random numbers

srand((double)microtime()*1000000);

$block = "ABCDEFGHJKLMNPQRSTUVWXYZ";
$block .= "abcdefghjkmnpqrstuvwxyz";
$block .= "0123456789";

for($i = 0; $i < 10; $i++)
{
$random.= substr($block,(rand()%(strlen($block))), 1);
}

BTW:

You can access single characters in a string directly with [] instead of
substr() and calling srand() is not necessary anymore as of PHP 4.2:

$random = '';
$length = strlen($block)-1;
for ($i = 0; $i < 10; $i++) {
$random .= $block[rand(0, $length)];
}

Micha

[C. (http://symcbean.blogspot.com/)]

On 20 Mar, 00:54, up2trouble <[e-mail]:

I wrote a program to generate a random code that the user would use to
gain access to a survey page. I got the code to generate fine;
however it will not store into the db. It gave me the generated code
then:
************************
hn3fXAaah1
Query failed cause: You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for the right
syntax to use near '' '' at line 1
************************
Help please.

<?PHP

if(isset($_POST['getcodes']))
{
$num = $_POST['num'];
$got = 0;

while ($got < $num)
{
$random = " ";// Initialize the string to store random numbers

srand((double)microtime()*1000000);

$block = "ABCDEFGHJKLMNPQRSTUVWXYZ";
$block .= "abcdefghjkmnpqrstuvwxyz";
$block .= "0123456789";

for($i = 0; $i < 10; $i++)
{
$random.= substr($block,(rand()%(strlen($block))), 1);

}

echo "$random<BR>";
$sql= "INSERT into $db_table10 (id) VALUES '$random'" ;
mysql_query ($sql) or die('Query failed cause: ' . mysql_error());
$got++;}
}

?>

Rather than publishing so much code it would have been so much easier
to just print $sql and send that in your posting. The code above won't
produce valid SQL because $db_table10 is not defined.

C.

[Betikci Boris]

up2trouble wrote:

I wrote a program to generate a random code that the user would use to
gain access to a survey page. I got the code to generate fine;
however it will not store into the db. It gave me the generated code
then:
************************
hn3fXAaah1
Query failed cause: You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for the right
syntax to use near '' '' at line 1
************************
Help please.

<?PHP

if(isset($_POST['getcodes']))
{
$num = $_POST['num'];
$got = 0;

while ($got < $num)
{
$random = " ";// Initialize the string to store random numbers

srand((double)microtime()*1000000);

$block = "ABCDEFGHJKLMNPQRSTUVWXYZ";
$block .= "abcdefghjkmnpqrstuvwxyz";
$block .= "0123456789";

for($i = 0; $i < 10; $i++)
{
$random.= substr($block,(rand()%(strlen($block))), 1);
}

echo "$random<BR>";
$sql= "INSERT into $db_table10 (id) VALUES '$random'" ;
mysql_query ($sql) or die('Query failed cause: ' . mysql_error());
$got++;
}
}
?>

Store the gain access code in a session variable.. No need sql'ing
stuff...

[up2trouble]

Thanks. I have it working now and storing into db. Others problems
have now arisen. I think I'm supposed to put them in a new post cause
it is a new problem.