Internet CD 2005 March/Internet_CD_032005.iso/Warsztat_PHP/create_db.php

PHP Script | 2005-01-02 | 800 b | 20 lines

<?php
$codeLenght = 6;
$codeQuantity = 5000;
$characters = array(2,3,4,5,6,7,8,9,'a','b','c','d','e','f','g','h','i','j','k','m','n','o','p','q','r','s','t','u','w','x','y','z','A','B','C','D','E','F','G','H','I','J','K','L','M','N','P','Q','R','S','T','U','W','X','Y','Z'); // wykluczone 1 i l, wykluczone 0 i O.

$c = mysql_connect('localhost', 'user', 'haslo');
mysql_select_db('nazwa_bazy', $c);

mysql_query('CREATE TABLE mi_secimg (hash VARCHAR(32) NOT NULL, code VARCHAR('.$codeLenght.') NOT NULL, PRIMARY KEY (hash), UNIQUE (code));');

for($q=0; $q<$codeQuantity; $q++) {
    $code = '';

    for($p=0; $p<$codeLenght; $p++) {
        $code.=$characters[rand(0, count($characters)-1)];
    }
    mysql_query('INSERT INTO mi_secimg VALUES ("'.md5($code).'", "'.$code.'")');
}
echo 'ok!';
?>