中文字幕精品亚洲无线码二区,аⅴ资源天堂资源库在线,凌晨三点看的片www高清

亚洲国产日韩欧美一区二区三区,精品亚洲国产成人av在线,国产99视频精品免视看7,99国产精品久久久久久久成人热,欧美日韩亚洲国产综合乱

<p>The main problem in my code is that I cannot update the "date" from the csv file into the mysql database table using php. The line of code $date = mysqli_real_escape_string($connect, $data[1]); is the main problem here. I'm looking for any alternative query for this particular line of code. </p> <p>This is the csv file: https://drive.google.com/file/d/1EdMKo-XH7VOXS5HqUh8-m0uWfomcYL5T/view?usp=sharing</p> <p>This is the complete code: </p> <pre class="brush:php;toolbar:false;"><?php //index.php $connect = mysqli_connect("localhost","root","1234","ml_database"); $message =''; if(isset($_POST["upload"])){ if($_FILES['product_file']['name']){ $filename = explode(".”，$ _FILES ['product_file'] ['name']）; if（end（$ filename）==“csv”）{ $handle = fopen（$ _FILES ['product_file'] ['tmp_name']，“r”）; while（$ data = fgetcsv（$ handle））{ $data_id = mysqli_real_escape_string（$ connect，$ data [0]）; $date = mysqli_real_escape_string（$ connect，$ data [1]）; //我的問題 $births = mysqli_real_escape_string（$ connect，$ data [2]）; $query =“UPDATE my_table SET date ='$ date'， births ='$ births'， WHERE data_id ='$ data_id'”; mysqli_query（$ connect，$ query）; } fclose（$ handle）; header（“l(fā)ocation：index.php？update = 1”); } else { $message ='<label class="text-danger">Please select only CSV files</label>'; } } else { $message ='<label class="text-danger">Please select file</label>'; } } if(isset($_GET["updation"])){ $message ='<label class="text-success">Product update completed</label>'; } $query = "SELECT * FROM my_table"; $result = mysqli_query($connect, $query); ?> <!DOCTYPE html> <html> <head> <title>Update Mysql database by uploading CSV file using PHP</title> <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.1.0/jquery.min.js"></script> <link rel="stylesheet" /> <script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js"></script> </head> <body> <br /> <div class="container"> <h2 align="center">Update Mysql database by uploading CSV file using PHP</a></h2> <br /> <form method="post" enctype='multipart/form-data'> <p><label>Please select a file (CSV format only)</label> <input type = “file” name = “product_file”/></p> <br /> <input type = “submit” name = “upload” class = “btn btn-info” value = “upload”/> </form> <br /> <?php echo $message; ?> <h3 align="center">Birthss</h3> <br /> <div class="table-responsive"> <table class="table table-bordered table-striped"> <tr> <th>Date</th> <th>Birth</th> </tr> <?php while($row = mysqli_fetch_array($result)) { echo ' <tr> <td>'.$row ["date"].'</td> <td>'.$row ["births"].'</td> </tr> '; } ?> </table> </div> </div> </body> </html></pre></p>

<?php //index.php $connect = mysqli_connect("localhost", "root", "1234", "ml_database"); $message = ''; if(isset($_POST["upload"])) { if($_FILES['product_file']['name']) { $filename = explode(".", $_FILES['product_file']['name']); if(end($filename) == "csv") { $handle = fopen($_FILES['product_file']['tmp_name'], "r"); // 讀取并忽略標(biāo)題行 $data = fgetcsv($handle, 1000, ","); // 準(zhǔn)備查詢一次 $query = "UPDATE my_table SET date = ?, births = ? WHERE data_id = ?"; $stmt = $connect->prepare($query); // 循環(huán)遍歷csv剩余的行 while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) { $stmt->bind_param('sss', $data[0],$data[1],$data[2]); $stmt->execute(); } fclose($handle); header("location: index.php?updation=1"); exit; // 重定向后一定要使用exit } else { $message = '請只選擇CSV文件'; } } else { $message = '請選擇文件'; } }