php - mystery number stuck in cache? -
when first ran code, worked fine , uploaded 2 test records different numbers. left day or 2 , when upload test data, enters first number ever entered, in. record deleted. ????
<?php require_once('auth.php'); require_once('config.php'); ?> <!doctype html public "-//w3c//dtd xhtml 1.0 transitional//en" "http://www.w3.org/tr/xhtml1/dtd/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="content-type" content="text/html; charset=iso-8859-1" /> <title>member index</title> <link href="loginmodule.css" rel="stylesheet" type="text/css" /> <script type="text/javascript" src="js/jquery.js"></script> <script type="text/javascript" src="js/subnav.js"></script> </head> <body> <h1>welcome <?php echo $_session['sess_first_name'];?></h1> <a href="member-profile.php">my profile</a> | <a href="logout.php">logout</a> <p>welcome tpc holdings sms campaign builder</p> <p></p> <ul class="topnav"> <li><a href="#">home</a></li> <li> <a href="#">tutorials</a> <ul class="subnav"> <li><a href="#">sub nav link</a></li> <li><a href="#">sub nav link</a></li> </ul> </li> <li> <a href="#">resources</a> <ul class="subnav"> <li><a href="#">sub nav link</a></li> <li><a href="#">sub nav link</a></li> </ul> </li> <li><a href="#">about us</a></li> <li><a href="#">submit</a></li> <li><a href="#">contact us</a></li> </ul> <p></p> <p>view stats</p> <p>change ip</p> <p>pay bill</p> <form enctype="multipart/form-data" method="post"> <input name="userfile" type="file"> <input type="submit" value="upload"> </form> <?php $dsn = "mysql:host=$host;port=$port;dbname=$dbname"; //data source name = mysql $db = new pdo($dsn, $db_username, $db_password); //connect db $do = $db->prepare("insert customer_list values(?,?,?,?)"); $csv_file = $_files['userfile']['tmp_name']; if ( ! is_file( $csv_file ) ) exit('file not found.'); if (($handle = fopen($csv_file, "r")) !== false) { while (($data = fgetcsv($handle, 1000, ",")) !== false) { $do->execute($data); //var_dump($data); } fclose($handle); } exit( "complete!" ); ?> </body> </html> ***************************************************** mysql> desc customer_list -> ; +---------------+-------------+------+-----+---------+----------------+ | field | type | null | key | default | | +---------------+-------------+------+-----+---------+----------------+ | id | smallint(6) | no | pri | null | auto_increment | | contact_first | char(30) | yes | | null | | | contact_last | char(30) | yes | | null | | | sms_num | int(10) | yes | | null | | +---------------+-------------+------+-----+---------+----------------+ 4 rows in set (0.00 sec) mysql> `select * customer_list id=id;` +----+---------------+---------------+------------+ | id | contact_first | contact_last | sms_num | +----+---------------+---------------+------------+ | 57 | mary | lamb | 2147483647 | | 56 | joe | shmoe | 2122223344 | | 55 | contact_first | contact_last | 0 | +----+---------------+---------------+------------+ 3 rows in set (0.00 sec) mysql> mysql> mysql> `select * customer_list id=id;` +----+---------------+--------------+------------+ | id | contact_first | contact_last | sms_num | +----+---------------+--------------+------------+ | 64 | blow | me | 2147483647 | | 63 | jack | ass | 2147483647 | | 62 | mary | lamb | 2147483647 | +----+---------------+--------------+------------+ 3 rows in set (0.00 sec) data being uploaded
,mary,lamb,3457890000 ,jack,ass,7776763412 ,blow,me,8008883232
Comments
Post a Comment