芝麻web文件管理V1.00

编辑当前文件:/home/jambtst2015/public_html/giraffeng.com/admin/update_staff_code.php
<?php include("lib/conn.php"); function random_no() { $staff_code_rand = rand(10000,99999); $check = mysql_num_rows(mysql_query("SELECT staff_id FROM sat_staff WHERE staff_code = '".$staff_code_rand."'")); if($check == 0) { return $staff_code_rand; } else { random_no(); } } $sql = mysql_query("SELECT * FROM sat_staff WHERE 1"); while($row = mysql_fetch_array($sql)) { $staff_code = random_no(); $update1 = mysql_query("UPDATE sat_staff SET staff_code = '".$staff_code."' WHERE staff_id = '".$row['staff_id']."'"); }