Я пытаюсь экспортировать некоторые записи mysql в файл csv. У меня пользователь выбирает диапазон дат, затем он отображает записи на экране между этими датами. Это работает. Я также могу экспортировать всю базу данных в csv без проблем, но когда я пытаюсь экспортировать файл csv на основе дат, он не работает. Итак, вот мой экспорт в код csv:
header('Content-Disposition: attachment; filename="APGE_ELEC_2013MMDD.csv"'); $hostname = "localhost"; //SET SERVER/HOSTNAME $dbusername = "ysername"; //SET DATABASE USERNAME $dbname = "test"; //SET DATABASE NAME $dbpassword = "password"; //SET DATABASE USERNAME $dbhandle = mysql_connect($hostname, $dbusername, $dbpassword) or die("Unable to connect to MySQL"); $selected = mysql_select_db($dbname,$dbhandle) or die("Could not select Data Base"); $query = "SELECT * FROM v88374 WHERE ((date >= '$from') AND (date <= '$to'))"; $export = mysql_query ($query ) or die ( "Sql error : " . mysql_error( ) ); $fields = mysql_num_fields ( $export ); for ( $i = 0; $i < $fields; $i++ ) { $header .= mysql_field_name( $export , $i ) ."|" . "\t"; } while( $row = mysql_fetch_row( $export ) ) { $line = ''; foreach( $row as $value ) { if ( ( !isset( $value ) ) || ( $value == "" ) ) { $value = "\t"; } else { $value = str_replace( '"' , '""' , $value ); $value = $value . '|' . "\t"; } $line .= $value; } $data .= trim( $line ) . "\n"; } $data = str_replace( "\r" , "" , $data ); if ( $data == "" ) { $data = "\n(0) Records Found!\n"; } print "$header\n$data"; exit(); Теперь это мой файл export.php. У меня есть файл под названием report.php, который фактически показывает записи, а затем вызывает export.php. Вот этот код:
<script type="text/javascript" language="javascript"> jQuery(function() { jQuery( "#from" ).datepicker({ defaultDate: "+1w", changeMonth: true, numberOfMonths: 1, dateFormat: "yy-mm-dd", onClose: function( selectedDate ) { $( "#to" ).datepicker( "option", "minDate", selectedDate ); } }); jQuery( "#to" ).datepicker({ defaultDate: "+1w", changeMonth: true, numberOfMonths: 1, dateFormat: "yy-mm-dd", onClose: function( selectedDate ) { jQuery( "#from" ).datepicker( "option", "maxDate", selectedDate ); } }); }); </script> <h1> Reporting Info</h1> <form method="post"> <p>Select a date range: </p><label style="color:#FFF;" for="from">From</label> <input type="text" id="from" name="from" /> <label style="color:#FFF;" for="to" >to</label> <input type="text" id="to" name="to" /> <input name="export" type="submit" value="Sort" /> </form> <?php $from = $_POST['from']; $to = $_POST['to']; echo "from: " . $from; echo " to: " . $to; $hostname = "localhost"; //SET SERVER/HOSTNAME $dbusername = "ysername"; //SET DATABASE USERNAME $dbname = "test"; //SET DATABASE NAME $dbpassword = "password"; //SET DATABASE USERNAME $link = mysqli_connect($hostname, $dbusername, $dbpassword, $dbname); if (!$link) { die('Connect Error (' . mysqli_connect_errno() . ') ' . mysqli_connect_error()); } $sql = "SELECT * FROM v88374 WHERE date >= DATE_FORMAT('" . $from . "', '%Y/%m/%d') AND date <= DATE_FORMAT('" . $to . "', '%Y/%m/%d')"; //$sql = "SELECT * FROM v88374 WHERE date >= $from AND date <= $to"; //$result = mysqli_query($link, $sql, MYSQLI_USE_RESULT); if ($result = mysqli_query($link, $sql)) { echo " <table width=100% border='1px'> <tr align='center' bgcolor='#999999'> <td> First Name</td><td>Last Name</td><td>Phone Number</td><td>Address</td><td>City</td><td>Zip Code</td><td>Utility</td><td>Acct Num</td><td>Email</td><td>Validation Code</td><td>State</td><td>Date</td> </tr> "; /* Get field information for all fields */ while($row = $result->fetch_assoc()){ $first_name = $row['first_name']; $last_name = $row['last_name']; $home_phone_num = $row['home_phone_num']; $sline1_addr = $row['sline1_addr']; $scity_name = $row['scity_name']; $spostal_code = $row['spostal_code']; $marketer_name = $row['marketer_name']; $ldc_account_num = $row['ldc_account_num']; $email = $row['email']; $validation_code = $row['validation_code']; $state = $row['state']; $date = $row['date']; echo " <tr align='center'><td> " . $first_name; echo "</td><td> " . $last_name; echo " </td><td> " . $home_phone_num; echo " </td><td> " . $sline1_addr; echo "</td><td> " . $scity_name; echo "</td><td> " . $spostal_code; echo " </td><td> " . $marketer_name; echo " </td><td>" . $ldc_account_num; echo " </td><td>" . $email; echo " </td><td> " . $validation_code; echo " </td><td>" . $state; echo " </td><td> " . $date; echo " </td></tr> "; } } echo "</table>"; echo "<form action='export.php'> <input type='submit' name='export' value= 'Export CSV'></form>"; /* close connection */ mysqli_close($link);по<script type="text/javascript" language="javascript"> jQuery(function() { jQuery( "#from" ).datepicker({ defaultDate: "+1w", changeMonth: true, numberOfMonths: 1, dateFormat: "yy-mm-dd", onClose: function( selectedDate ) { $( "#to" ).datepicker( "option", "minDate", selectedDate ); } }); jQuery( "#to" ).datepicker({ defaultDate: "+1w", changeMonth: true, numberOfMonths: 1, dateFormat: "yy-mm-dd", onClose: function( selectedDate ) { jQuery( "#from" ).datepicker( "option", "maxDate", selectedDate ); } }); }); </script> <h1> Reporting Info</h1> <form method="post"> <p>Select a date range: </p><label style="color:#FFF;" for="from">From</label> <input type="text" id="from" name="from" /> <label style="color:#FFF;" for="to" >to</label> <input type="text" id="to" name="to" /> <input name="export" type="submit" value="Sort" /> </form> <?php $from = $_POST['from']; $to = $_POST['to']; echo "from: " . $from; echo " to: " . $to; $hostname = "localhost"; //SET SERVER/HOSTNAME $dbusername = "ysername"; //SET DATABASE USERNAME $dbname = "test"; //SET DATABASE NAME $dbpassword = "password"; //SET DATABASE USERNAME $link = mysqli_connect($hostname, $dbusername, $dbpassword, $dbname); if (!$link) { die('Connect Error (' . mysqli_connect_errno() . ') ' . mysqli_connect_error()); } $sql = "SELECT * FROM v88374 WHERE date >= DATE_FORMAT('" . $from . "', '%Y/%m/%d') AND date <= DATE_FORMAT('" . $to . "', '%Y/%m/%d')"; //$sql = "SELECT * FROM v88374 WHERE date >= $from AND date <= $to"; //$result = mysqli_query($link, $sql, MYSQLI_USE_RESULT); if ($result = mysqli_query($link, $sql)) { echo " <table width=100% border='1px'> <tr align='center' bgcolor='#999999'> <td> First Name</td><td>Last Name</td><td>Phone Number</td><td>Address</td><td>City</td><td>Zip Code</td><td>Utility</td><td>Acct Num</td><td>Email</td><td>Validation Code</td><td>State</td><td>Date</td> </tr> "; /* Get field information for all fields */ while($row = $result->fetch_assoc()){ $first_name = $row['first_name']; $last_name = $row['last_name']; $home_phone_num = $row['home_phone_num']; $sline1_addr = $row['sline1_addr']; $scity_name = $row['scity_name']; $spostal_code = $row['spostal_code']; $marketer_name = $row['marketer_name']; $ldc_account_num = $row['ldc_account_num']; $email = $row['email']; $validation_code = $row['validation_code']; $state = $row['state']; $date = $row['date']; echo " <tr align='center'><td> " . $first_name; echo "</td><td> " . $last_name; echo " </td><td> " . $home_phone_num; echo " </td><td> " . $sline1_addr; echo "</td><td> " . $scity_name; echo "</td><td> " . $spostal_code; echo " </td><td> " . $marketer_name; echo " </td><td>" . $ldc_account_num; echo " </td><td>" . $email; echo " </td><td> " . $validation_code; echo " </td><td>" . $state; echo " </td><td> " . $date; echo " </td></tr> "; } } echo "</table>"; echo "<form action='export.php'> <input type='submit' name='export' value= 'Export CSV'></form>"; /* close connection */ mysqli_close($link);
Надеюсь, я объяснил это достаточно. Любая помощь очень ценится!