Call from URL showing blank records

Question

I have an option menu (selFilter) that filters a MYSQL query. The option menu choice is used in a link to filter a second PHP page. export.php?recordID=

<select name="selFilter" id="selFilter" onchange="formFilter.submit()">
    <option value="%">all levels</option>
    <?php
do {  
?>
    <option value="<?php echo $row_RecordsetLevel['Level']?>"<?php if   
($varFilter_Recordset3 == $row_RecordsetLevel['Level']) {echo 'selected';}   
?>>level: <?php echo $row_RecordsetLevel['Level']?></option>
    <?php
} while ($row_RecordsetLevel = mysql_fetch_assoc($RecordsetLevel));
$rows = mysql_num_rows($RecordsetLevel);
if($rows > 0) {
  mysql_data_seek($RecordsetLevel, 0);
  $row_RecordsetLevel = mysql_fetch_assoc($RecordsetLevel);
 }
 ?>
  </select>

The second php page uses a query to export to .csv using the following:

$colname = "%";
if (isset($_GET['recordID'])) {
$colname = $_GET['recordID'];
}


$query = sprintf( 'SELECT Name, ID
FROM schedule WHERE Level LIKE %s ORDER BY Name', 
GetSQLValueString("%".$colname."%", "text"));

$result = mysql_query( $query, $conn ) or die( mysql_error( $conn ) );
//
// send response headers to the browser
// following headers instruct the browser to treat the data as a csv file 
called export.csv

//
header( 'Content-Type: text/csv' );
header( 'Content-Disposition: attachment;filename=export.csv' );

Everything works fine when an option (selFilter) is chosen in the index.php file and I click export.php. The problem is if I don't pick anything in the option menu and click export.php link, the URL string is then export.php?recordID= with recordID being blank. That blank causes nothing to export, zero records. If I select an option menu level and then click all levels the URL is export.php?recordID=% and exports correctly. What should I fix so I can export from either call?

I have tried the following but export URL is still blank:

export.php?recordID=<?php $filter=$_POST['selFilter']; if (!empty($filter)) { echo "%"; } ?>

`while (...);` <<< end of statement and is considered as "valid" syntax. — Funk Forty Niner, Mar 31 '16 at 17:02
I'm not sure I understand your recommendation. Can you please elaborate. — user3258571, Mar 31 '16 at 17:05
it means that the semi-colon is "ending" your statement; remove it. — Funk Forty Niner, Mar 31 '16 at 17:06
When I remove the ; in } while ($row_RecordsetLevel = mysql_fetch_assoc($RecordsetLevel)); to } while ($row_RecordsetLevel = mysql_fetch_assoc($RecordsetLevel)) I get an error and page does not load. — user3258571, Mar 31 '16 at 17:10
I still need help. Is there something I should change in $colname = "%"; or in WHERE Level LIKE %s ORDER BY Name', GetSQLValueString("%".$colname."%", "text")); — user3258571, Mar 31 '16 at 17:20
Page wont load. I am using Dreamweaver to edit. Also shows syntax error in Dreamweaver if I remove the semicolon. — user3258571, Mar 31 '16 at 17:22
Add error reporting to the top of your file(s) right after your opening ` — Funk Forty Niner, Mar 31 '16 at 17:24
Parse error: syntax error, unexpected '$rows' (T_VARIABLE), expecting ';'... — user3258571, Mar 31 '16 at 17:25
Should the export link be changed to something else? export.php?recordID= — user3258571, Mar 31 '16 at 17:29
@Fred-ii-: The semicolon would be an issue if it was a `while` loop, but it is actually a `do ... while` loop - and therefor the semicolon is _necessary_ here to end the statement, removing it will cause an error. — CBroe, Mar 31 '16 at 17:58
Just check if `$_GET['recordID']` is an empty string, and if so, modify it accordingly. — CBroe, Mar 31 '16 at 17:59
@CBroe ah ok, thanks for clearing that up for me then. I'll be going to bed tonight feeling a little less stupid *lol* (Expressions in my language don't translate so well, but you get my gist (I hope)). — Funk Forty Niner, Mar 31 '16 at 18:03
Can someone offer an example based on CBroe's response? "Just check if $_GET['recordID'] is an empty string, and if so, modify it accordingly." — user3258571, Mar 31 '16 at 19:32
I have tried the following but export URL is still blank: export.php?recordID= — user3258571, Apr 01 '16 at 18:13

score 0 · Accepted Answer · edited May 23 '17 at 12:07

I found a solution. Changed export link to:

 export.php?recordID=<?php 
$filter=isset($_POST['selFilter']) ? $_POST['selFilter'] : '%';
 echo "/export_student.php?recordID=$filter";
 ?>

Used solution from stackoverflow: PHP: "Notice: Undefined variable", "Notice: Undefined index", and "Notice: Undefined offset"

I just substituted

$filter=isset($_POST['selFilter']) ? $_POST['selFilter'] : '';

with

 $filter=isset($_POST['selFilter']) ? $_POST['selFilter'] : '%';

since my query was triggering an undefined index based on my option menu did not set a value.

Call from URL showing blank records

1 Answers1