MrShahzodbek
  1. $db->Query("SELECT COUNT(*) FROM db_users_a WHERE user = '$login'");
  2. if($db->FetchRow() == 0){
  3.  
  4. # Foydalanuvchini ro`yhatga olamiz
  5. $db->Query("INSERT INTO db_users_a (user, email, pass, referer, referer_id, date_reg, ip)
  6. VALUES ('$login','{$email}','$md5pass','$referer_name','$referer_id','$time',INET_ATON('$ip'))");
  7.  
  8. $lid = $db->LastInsert();
  9. # BONUS belgilaymiz
  10. $db->Query("INSERT INTO db_users_b (id, user, money_b, money_p, last_sbor) VALUES ('$lid','$login','1009', '1009', '".time()."')");
  11.  
  12. # Statistikani yangilaymiz
  13. $db->Query("UPDATE db_stats SET all_users = all_users +1 WHERE id = '1'");


Shuni PDOga moslab beringlar, sal tushunib olish uchun?
6 daqiqa 33 soniyadan keyin yozdi:
  1. # Statistikani yangilaymiz
  2. $sql = "UPDATE db_stats SET all_users=? WHERE id=1";
  3. $stmt= $dpo->prepare($sql);
  4. $stmt->execute([$all_users+1]);


Shu to'grimi?