Tātad ievadu kodu, kodu pārbauda, ja ir pareizs, tad izvada failu uz servera, attiecīgajam id, bet uzmet baltu lapu?
DB Struktūra
id|nosaukums|apraksts|koda_id|fails_uz_servera|cat
<?php
$kodinsh = $_POST['code'];
$ip = $_SERVER['REMOTE_ADDR'];
mysql_connect("localhost","asdasdasd","asdadsasdasdas");
mysql_select_db("other");
$result = mysql_fetch_assoc(mysql_query("SELECT code FROM codes WHERE code = '$kodinsh'"));
$result2 = mysql_fetch_assoc(mysql_query("SELECT id,fails_uz_servera FROM sms_shop_faili WHERE id={$_GET['id']}"));
$kodinsh2 = $result['code'];
function createRandomPassword() {
$chars = "abcdefghijkmnopqrstuvwxyz023456789";
srand((double)microtime()*1000000);
$i = 0;
$pass = '';
while ($i <= 7) {
$num = rand() % 33;
$tmp = substr($chars, $num, 1);
$pass = $pass . $tmp;
$i++;
}
return $pass;
}
$password = createRandomPassword();
$q2 = "UPDATE codes SET code = '3$password' WHERE code = '$kodinsh2'";
if ($_POST['submit1'] and $kodinsh2 > 0) {
mysql_query($q2,$result2) or die(mysql_error());
echo $row['fails_uz_servera'];
} else if ($_POST['submit1']) {
echo "<font color='white'>Wrong Code!</font>";
mysql_close();
}
?>