Ok ths is great, a lovely Random Code Generator!
Thanks a lot. I always wanted one of these. Actually
my problem was a little different, but i was able to
solve it. I was using $result twice to store to
different SQL Queries, i changed the other one to
$result2 and it worked. But in fact, i will now change
my code to generate the Random Number which of course
is much better! Thanks...
T. Edison Jr.
--- Wouter van Vliet <[EMAIL PROTECTED]> wrote:
> I don't see why your code is so wrong .... but
> neither do I see what it
> reall does. YOu are changing the clientID with some
> simple function into a
> password? As in everybody can do that trick by
> himself and login as whoever
> he wants ..
>
> What I'll mostly do for such things, is use this
> self written function to
> generate a random string and use this as generated
> password. it takes an
> integer as argument, and gives back a random code
> with only [A-Z][a-z]
> characters of a length of the given argument.
>
> And then, I'd just use the loop to roll through the
> ID's and insert a random
> code password.
>
> function generateRandomString($length) {
> srand ((float) microtime() * 1000000);
> for ($i=65;$i<91;$i++) {
> $chars[] = chr($i);
> };
> for ($i=97;$i<122;$i++) {
> $chars[] = chr($i);
> };
> $chrs = count($chars) - 1;
> for ($i=0; $i<$length; $i++) {
> $asc = rand(0, $chrs);
> $code .= $chars[$asc];
> };
> return $code;
> };
>
> $result = mysql_query("SELECT clientid FROM
> Clientdetails");
> while ($myrow = mysql_fetch_assoc($result)) {
> $code = generateRandomString(8);
> mysql_query("INSERT INTO authentication (id, pass)
> VALUES
> ($myrow[clientid], '".$code."'");
> };
>
> Hope this helped you !
>
> Greetz,
> Wouter
>
>
> -----Oorspronkelijk bericht-----
> Van: Thomas Edison Jr.
> [mailto:[EMAIL PROTECTED]]
> Verzonden: woensdag 24 juli 2002 9:02
> Aan: [EMAIL PROTECTED]
> Onderwerp: [PHP] Inserting Processed Data from One
> Table 2 Another!
>
>
> Ok i have simple issue, i'm stuck at one point.
>
> I have a table "Clientdetails" which contains
> ClientID.
> I have created another table "Authentication" with 2
> fields, "ClientID" and "Password".
>
> I want to pick up the ClientID from table
> "Clientdetails" and insert "ClientID" and a Password
> i
> have generated using a code, into "Authentication".
>
> So if there are 13000 ClientID's in "Clientdetails",
> as, many rows with the ClientID & it's corresponding
> password should be Inserted into table
> "Authentication".
>
> I'm using the following code which i know is wrong,
> what would be correct?
>
> <?
> $db = mysql_connect("localhost","user","pwd");
> mysql_select_db("myDB",$db);
>
> $result = mysql_query("SELECT * FROM
> clientdetails",$db);
> if ($myrow = mysql_fetch_array($result)) {
> do {
>
> $some = $myrow[clientid]
> $newid = eregi_replace('100', '', $myrow[clientid]);
> $date = date("dn");
> $stuff = $newid.def.$date;
>
> $sql = "INSERT INTO authentication
> VALUES('$some','$stuff')";
> $result = mysql_query($sql);
> echo "All Done!";
>
> } while ($myrow = mysql_fetch_array($result));
> }
>
> ?>
>
> Thanks,
> T. Edison Jr.
>
>
>
>
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! Health - Feel better, live better
> http://health.yahoo.com
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
>
__________________________________________________
Do You Yahoo!?
Yahoo! Health - Feel better, live better
http://health.yahoo.com
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
