Privet vsem.
Pomogite pojaluista, ya ne mogu rasobratsya, ne poluchaetsya dalshe!
Ya napisal script kotoriy generiruet 8-snachnie chisla. Eti chisla sapominautsya v base dannih.
U menya nikak ne poluchaetsya napisat sleduysheu chast scripta, ya uje proboval raslichnimi metodami
(@ snak pered oshibkoi; raslichnie zikli for; i raslichnie zikli while), no ne kak ne dobilsy resultata.
Esli odno is sgenerirovanih chisel povtoritsy s chislom kotoroe uje sapomnino v base dannih,
ono doljno ne sapominatsy v basu dannih i ne vidavat oshibki,
a generirovat novie/novoe chisla/chislo dla povtornogo sapominaniya.
V etom sluchae doljno sapominatsy po 3 chisla.
Ya privoju sdes moi script s soedineniem s basoi dannih i tablizu v kotoroi vse sapominaetsya.
Jdu pomoshi, spasibo.
//Basa dannih
/*
CREATE TABLE tabelle_1 (
id int(10) unsigned NOT NULL auto_increment,
nums varchar(100) NOT NULL default \'\',
aktiv varchar(7) NOT NULL default \'"no"\',
date date NOT NULL default \'0000-00-00\',
PRIMARY KEY (id),
UNIQUE KEY nums (nums)
) TYPE=MyISAM;
*/
class object {};
$CFG = new object;
$CFG->dbhost = "";
$CFG->dbname = "";
$CFG->dbuser = "";
$CFG->dbpass = "";
$link=mysql_connect($CFG->dbhost,$CFG->dbuser,$CFG->dbpass);
mysql_select_db($CFG->dbname) or die ("Error:");
function send_sql($sql)
{
if (! $res=mysql_query($sql)){
echo mysql_error();
exit;
}
return $res;
}
// Funkziya dla generirovanya chisel.
function number ($begin, $end) {
for (; $i < 1; $i++) {
$nums = rand ($begin, $end);
return $nums;
}
}
for (; $i < 3; $i++) {
$begin = 10;
$end = 99;
$num_block_1=number($begin,$end);
$num_block_2=number($begin,$end);
$num_block_3=number($begin,$end);
$num_block_4=number($begin,$end);
$nums_blocks=$num_block_1.$num_block_2.$num_block_3.$num_block_4;
$arr = explode(" ", $nums_blocks);
foreach ($arr as $nums_blocks)
// Esli chisla kotorie budut generirovatsya mejdu soboi povtoryautsya ne pokasivat.
if (!$cnt[$nums_blocks]++) {
$sql = "insert into tabelle_1 values (\'\', \'$nums_blocks\', \'no\', \'$today\')";
$res=send_sql($sql);
echo "Start of Generator $nums_blocks.\\n
";
}
elseif ($cnt[$nums_blocks]++) {
unset($nums_blocks);
echo "";
}
echo "
";
}