raymak

<?php //error_reporting(E_ALL); $psPath = "powershell.exe"; $psDir = "C:\\wamp\\www\\ps\\"; $psScript = "SampleHTML.ps1"; $runScript = $psDir. $psScript; $prem = "-Action enable"; $runCMD = $psPath. " " .$runScript. " " .$prem; var_dump($runCMD); $output = proc_open($runCMD); $exitcode = proc_close($output); echo $exitcode; ?> string(59) "powershell.exe C:\wamp\www\ps\SampleHTML.ps1 -Action enable" Warning: proc_open() expects at least 3 parameters, 1 given in C:\wamp\www\powershell.php on line 13 Warning: proc_close() expects parameter 1 to be resource, boolean given in C:\wamp\www\powershell.php on line 15 Hi, I tried the proc_open function. I think I am missing some parameters to make it functional. Here is the error I am receiving: Here is the modified code:

Thanks Requinix. I will try out proc_open function and see how it goes.

<?php error_reporting(E_ALL); $psPath = "powershell.exe"; $psDir = "C:\\wamp\\www\\ps\\"; $psScript = "SampleHTML.ps1"; $runScript = $psDir. $psScript; $prem = "-Action enable"; $runCMD = $psPath. " " .$runScript. " " .$prem; //var_dump($runCMD); $output = exec($runCMD); echo $output; ?> Hello, I am working on a small project to get results from powershell script by using PHP. For some reason in PHP logs I get Exec unable to fork. Above is the script I wrote to execute powershell script within php. My webserver is IIS 7, and app pool is using a domain user that has full rights for Powershell to execute and get remote server results.

Mac_gyver, Thank you very much for your help. From your code, I learned a new concept of storing values in multiple array inside one variable.

Mac_gyver, Thank so much for your time and knowledge for above suggestions. My code looks same as your reversed engineered code. And I apologize for not posting the actual code in time, and it would have saved you a lot of time. I am posting my code anyways, and I will review your suggestions and get back to you. <?php $application = array(); $application[0] = array( "id" => 1, "appname" => "NotePad++" ); $application[1] = array( "id" => 2, "appname" => "7Zip" ); $application[2] = array( "id" => 3, "appname" => "MS Office 2010++" ); $application[3] = array( "id" => 4, "appname" => "Norton Anti Virus" ); $application[4] = array( "id" => 5, "appname" => "Chrome" ); $application[5] = array( "id" => 6, "appname" => "Adobe Reader" ); $serverlist = array(); $serverlist[0] = array( "appid" => 1, "Environment" => "Prod", "servername" => "server1" ); $serverlist[1] = array( "appid" => 1, "Environment" => "Prod", "servername" => "server2" ); $serverlist[2] = array( "appid" => 1, "Environment" => "DEV", "servername" => "devserver1" ); $serverlist[3] = array( "appid" => 1, "Environment" => "DEV", "servername" => "devserver2" ); $serverlist[4] = array( "appid" => 2, "Environment" => "Prod", "servername" => "server3" ); $serverlist[5] = array( "appid" => 2, "Environment" => "Prod", "servername" => "server4" ); $serverlist[6] = array( "appid" => 2, "Environment" => "DEV", "servername" => "devserver3" ); $serverlist[7] = array( "appid" => 2, "Environment" => "DEV", "servername" => "devserver4" ); $data = array(); $doc = new DOMDocument("1.0"); $doc->formatOutput = true; $main = $doc->createElement("Applications"); $doc->appendChild( $main); Foreach ($application as $app) { Foreach ($serverlist as $serverenv) { if ($serverenv['appid'] == $app['id']) { $appchild = $doc->createElement( "App" ); $appattr = $main->appendChild($appchild); $appattr->setAttribute("AppName", $app['appname']); $envchild = $doc->createElement("Env"); $envattr = $appchild->appendChild($envchild); $envattr->setAttribute($serverenv['Environment'], $serverenv['servername']); } } } echo $doc->saveXML(); ?>

Hello, I am working on creating an XML document. I am trying to accomplish following format, but the code I wrote is giving me different result. I need some help on which type of loop I can use, so I can store all the Env in one element as a attribute. Output I am trying to accomplish this: <Applications> <App AppName="NotePad++"> <Env Prod="server1,server2" DEV="devserver1,devserver2" /> </App> <App AppName="7Zip"> <Env Prod="server3,server4" DEV="devserver3,devserver4" /> </App> </Applications> But, I am getting this: <?xml version="1.0" ?> <Applications> <App AppName="NotePad++"> <Env Prod="server1" /> </App> <App AppName="NotePad++"> <Env Prod="server2" /> </App> <App AppName="NotePad++"> <Env DEV="devserver1" /> </App> <App AppName="NotePad++"> <Env DEV="devserver2" /> </App> <App AppName="7Zip"> <Env Prod="server3" /> </App> <App AppName="7Zip"> <Env Prod="server4" /> </App> <App AppName="7Zip"> <Env DEV="devserver3" /> </App> <App AppName="7Zip"> <Env DEV="devserver4" /> </App> </Applications> Here is the code I wrote: Foreach ($application as $app) { Foreach ($serverlist as $serverenv) { if ($serverenv['appid'] == $app['id']) { $appchild = $doc->createElement( "App" ); $appattr = $main->appendChild($appchild); $appattr->setAttribute("AppName", $app['appname']); $envchild = $doc->createElement("Env"); $envattr = $appchild->appendChild($envchild); $envattr->setAttribute($serverenv['Environment'], $serverenv['servername']); } } } echo $doc->saveXML();

Thank you boompa. That worked

Hello, I am trying to generate XML file and print the xml value in the browser. I am having had time create child element and adding attribute inside the child element. Structure I am trying to create is: <applications> <app appname="Notepad++" /> </applications> Here is the code I'm trying to accomplish the above format: $doc = new DOMDocument("1.0"); $doc->formatOutput = true; $main = $doc->createElement("Applications"); $doc->appendChild( $main); $child = $doc->createElement( "app" ); $attr = $doc->appendChild($child); $attr->setAttribute("AppName", "NotePad++"); echo $doc->saveXML(); I am not sure what I'm doing wrong, but I get below error when I browse the php page: The XML page cannot be displayed Cannot view XML input using XSL style sheet. Please correct the error and then click the Refresh button, or try again later. Only one top level element is allowed in an XML document. Error processing resource 'http://localhost/servers/xmldoc.php'. ... <app AppName="NotePad++"/>-^

I think I solved the problem for html code. I added exit(); end of the code and it stopped adding html code in the csv file. Thanks everyone for your support.

Thank you Now I was able to download csv file. However, I receive all html code inside CSV file. I think I should put the code after closing tag of </html>?

Ch0cu3r, Sorry I didn't move function right above echocsv($headers);. After moving the function, I was able to see data in the header. However, it didn't prompt me for downloadable, but it did display information in the header of the page. Thanks for all your help. Ray

RIght now on line 70, this code is defined: echocsv($headers); Here is the full code after all the modification: <?php ini_set('display_errors', 1); error_reporting(E_ALL); include('dbcon.php'); if (isset($_POST['export'])) { if (empty($_POST['service'])) { ?> <div id="message"> <?php echo "Please select service in dropdown" . "</br>"; ?> </div> <?php } else { $service = $_POST['service']; } if (empty($_POST['environment'])) { ?> <div id="message"> <?php echo "Please select Environment in dropdown" . "</br>"; ?> </div> <?php } else { $env = $_POST['environment']; } if ((!empty($service)) && (!empty($env))) { $sql="SELECT servers.ServerName, servers.alias, servers.IPAddress, vip.vipaddress, evn.env, domains.domainname, services.service, tier.tier, os.os, servers.platform, servers.virtualenv, url.url, servers.status FROM servers.servers LEFT OUTER JOIN servers.vip ON (servers.vipaddress = vip.vipid) LEFT OUTER JOIN servers.evn ON (servers.environment = evn.envid) LEFT OUTER JOIN servers.domains ON (servers.Domain = domains.domainid) LEFT OUTER JOIN servers.services ON (servers.service = services.serviceid) LEFT OUTER JOIN servers.tier ON (servers.tier = tier.tierid) LEFT OUTER JOIN servers.os ON (servers.os = os.osid) LEFT OUTER JOIN servers.url ON (servers.endpointurl = url.urlid) where servers.environment = $env and servers.service = $service and servers.status = '$_POST[status]'"; $result = mysqli_query($con,$sql); if (!$result) { die('Error: ' . mysqli_error($con)); } /* * 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'); */ /* * output header row (if atleast one row exists) */ $headers = array(); foreach (mysqli_fetch_fields($result) as $field) { $headers[] = $field->name; } echocsv($headers); /* * echo the input array as csv data maintaining consistency with most CSV implementations * - uses double-quotes as enclosure when necessary * - uses double double-quotes to escape double-quotes * - uses CRLF as a line separator */ function echocsv($fields) { $separator = ''; foreach ($fields as $field) { if (preg_match('/\\r|\\n|,|"/', $field)) { $field = '"' . str_replace('"', '""', $field) . '"'; } echo $separator . $field; $separator = ','; } echo "\r\n"; } while ($row = mysqli_fetch_row($result)) { echocsv($row); } } } ?> <?php include('inc/header.php'); ?> <div id="results"> <form id="searchform" action="index.php" method="post"> <h1>Search</h1> <div id="service"> <label for="service">Service:</label> <select id="service" name="service" class="searchoption"> <option value="">-- Select Service Name --</option> <?php $resultservice = mysqli_query($con,"Select * from services") ?> <?php while ($line = mysqli_fetch_array($resultservice)) { ?> <option value="<?php echo $line['serviceid'];?>"> <?php echo $line['service'];?> </option> <?php } ?> </select> <br /> </div> <div id="env"> <label for="environment">Environment:</label> <select id="environment" name="environment" class="searchoption"> <option value="">-- Select Environment --</option> <?php $resultdomain = mysqli_query($con,"Select * from evn") ?> <?php while ($line = mysqli_fetch_array($resultdomain)) { ?> <option value="<?php echo $line['envid'];?>"> <?php echo $line['env'];?> </option> <?php } ?> </select><br /> </div> <div id="status"> <label for="status">Status:</label> <select id="status" name="status" class="searchoption"> <option value="Active">Active</option> <option value="Inactive">Inactive</option> </select><br /> </div> <div id="button"> <input type="reset" name="reset"> <input type="submit" name="search" value="Search"> <input type="submit" name="export" value="Export" /> </div> </form> <?php if (isset($_POST['search'])) { if (empty($_POST['service'])) { ?> <div id="message"> <?php echo "Please select service in dropdown" . "</br>"; ?> </div> <?php } else { $service = $_POST['service']; } if (empty($_POST['environment'])) { ?> <div id="message"> <?php echo "Please select Environment in dropdown" . "</br>"; ?> </div> <?php } else { $env = $_POST['environment']; } if ((!empty($service)) && (!empty($env))) { $sql="SELECT servers.ServerName, servers.alias, servers.IPAddress, vip.vipaddress, evn.env, domains.domainname, services.service, tier.tier, os.os, servers.platform, servers.virtualenv, url.url, servers.status FROM servers.servers LEFT OUTER JOIN servers.vip ON (servers.vipaddress = vip.vipid) LEFT OUTER JOIN servers.evn ON (servers.environment = evn.envid) LEFT OUTER JOIN servers.domains ON (servers.Domain = domains.domainid) LEFT OUTER JOIN servers.services ON (servers.service = services.serviceid) LEFT OUTER JOIN servers.tier ON (servers.tier = tier.tierid) LEFT OUTER JOIN servers.os ON (servers.os = os.osid) LEFT OUTER JOIN servers.url ON (servers.endpointurl = url.urlid) where servers.environment = $env and servers.service = $service and servers.status = '$_POST[status]'"; if (!mysqli_query($con,$sql)) { die('Error: ' . mysqli_error($con)); } $mydata = mysqli_query($con,$sql); $rowcount = mysqli_num_rows($mydata); if ($rowcount >= 1) { echo "<table id='main-data-table' border=1> <tr> <th> + </th> <th>Server Name</th> <th>IP Address</th> <th>Service</th> <th>Tier</th> </tr>"; while ($record = mysqli_fetch_array($mydata)) { echo "<tr class='main mainrow'>"; echo "<td><a href='#' class='main'>+</a></td>"; echo "<td>" . $record['ServerName'] . "</td>"; echo "<td>" . $record['IPAddress'] . "</td>"; echo "<td>" . $record['service'] . "</td>"; echo "<td>" . $record['tier'] . "</td>"; echo "</tr>"; //echo "<table border=1>"; echo "<tr class='data showhide'>"; echo "<td>" . "</td>"; echo "<td class='innerleftcol'>" . Server . Name . "</td>"; echo "<td>" . $record['ServerName'] . "</td>"; echo "<td class='innerleftcol'>" . IP . Address . "</td>"; echo "<td>" . $record['IPAddress'] . "</td>"; echo "</tr>"; echo "<tr class='data showhide'>"; echo "<td>" . "</td>"; echo "<td class='innerleftcol'>" . Alias . "</td>"; echo "<td>" . $record['alias'] . "</td>"; echo "<td class='innerleftcol'>" . Environment . "</td>"; echo "<td>" . $record['env'] . "</td>"; echo "</tr>"; echo "<tr class='data showhide'>"; echo "<td>" . "</td>"; echo "<td class='innerleftcol'>" . VIP . Address . "</td>"; echo "<td>" . $record['vipaddress'] . "</td>"; echo "<td class='innerleftcol'>" . Domain . Name . "</td>"; echo "<td>" . $record['domainname'] . "</td>"; echo "</tr>"; echo "<tr class='data showhide'>"; echo "<td>" . "</td>"; echo "<td class='innerleftcol'>" . Service . "</td>"; echo "<td>" . $record['service'] . "</td>"; echo "<td class='innerleftcol'>" . Tier . "</td>"; echo "<td>" . $record['tier'] . "</td>"; echo "</tr>"; echo "<tr class='data showhide'>"; echo "<td>" . "</td>"; echo "<td class='innerleftcol'>" . OS . "</td>"; echo "<td>" . $record['os'] . "</td>"; echo "<td class='innerleftcol'>" . EndPoint . "</td>"; echo "<td>" . $record['url'] . "</td>"; echo "</tr>"; echo "<tr class='data showhide'>"; echo "<td>" . "</td>"; echo "<td class='innerleftcol'>" . Platform . "</td>"; echo "<td>" . $record['platform'] . "</td>"; echo "<td class='innerleftcol'>" . Virtual . "</td>"; echo "<td>" . $record['virtualenv'] . "</td>"; echo "</tr>"; } echo "</table>"; ?> <div id="message"> <?php echo "$rowcount record/s found"; ?> </div> <?php } else { ?> <div id="message"> <?php echo "No records found"; ?> </div> <?php } } else { exit(); } mysqli_close($con); } ?> </div> <?php include('inc/footer.php'); ?>

I updated PHP.INI file with correct timezone. I also modified the code as per Ch0cu3r suggestion on post 13. And now I get below error. Fatal error: Call to undefined function echocsv() in /home/vhost/www/rahil.me/public_html/index.php on line 70

After enabling reporting. Here is the error I get: Warning: main(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected the timezone 'UTC' for now, but please set date.timezone to select your timezone. in /home/vhost/www/rahil.me/public_html/index.php on line 45 Notice: Use of undefined constant result - assumed 'result' in /home/vhost/www/rahil.me/public_html/index.php on line 45 Warning: main(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected the timezone 'UTC' for now, but please set date.timezone to select your timezone. in /home/vhost/www/rahil.me/public_html/index.php on line 70 Fatal error: Call to undefined function echocsv() in /home/vhost/www/rahil.me/public_html/index.php on line 70

Thanks for your quick response. I did apply the changes as per your suggestion. However, when I click on export button, it shows me page cannot be disabled. Here is the modified code: <?php include('dbcon.php'); if (isset($_POST['export'])) { if (empty($_POST['service'])) { ?> <div id="message"> <?php echo "Please select service in dropdown" . "</br>"; ?> </div> <?php } else { $service = $_POST['service']; } if (empty($_POST['environment'])) { ?> <div id="message"> <?php echo "Please select Environment in dropdown" . "</br>"; ?> </div> <?php } else { $env = $_POST['environment']; } if ((!empty($service)) && (!empty($env))) { $sql="SELECT servers.ServerName, servers.alias, servers.IPAddress, vip.vipaddress, evn.env, domains.domainname, services.service, tier.tier, os.os, servers.platform, servers.virtualenv, url.url, servers.status FROM servers.servers LEFT OUTER JOIN servers.vip ON (servers.vipaddress = vip.vipid) LEFT OUTER JOIN servers.evn ON (servers.environment = evn.envid) LEFT OUTER JOIN servers.domains ON (servers.Domain = domains.domainid) LEFT OUTER JOIN servers.services ON (servers.service = services.serviceid) LEFT OUTER JOIN servers.tier ON (servers.tier = tier.tierid) LEFT OUTER JOIN servers.os ON (servers.os = os.osid) LEFT OUTER JOIN servers.url ON (servers.endpointurl = url.urlid) where servers.environment = $env and servers.service = $service and servers.status = '$_POST[status]'"; $result = mysqli_query($con,$sql); if (!result) { die('Error: ' . mysqli_error($con)); } /* * 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'); /* * output header row (if atleast one row exists) */ $headers = array(); foreach (mysqli_fetch_fields($result) as $field) { $headers[] = $field->name; } echocsv($headers); /* * echo the input array as csv data maintaining consistency with most CSV implementations * - uses double-quotes as enclosure when necessary * - uses double double-quotes to escape double-quotes * - uses CRLF as a line separator */ while ($row = mysqli_fetch_row($result)) { echocsv($row); } function echocsv($fields) { $separator = ''; foreach ($fields as $field) { if (preg_match('/\\r|\\n|,|"/', $field)) { $field = '"' . str_replace('"', '""', $field) . '"'; } echo $separator . $field; $separator = ','; } echo "\r\n"; } } } ?> <?php include('inc/header.php'); ?> <div id="results"> <form id="searchform" action="index.php" method="post"> <h1>Search</h1> <div id="service"> <label for="service">Service:</label> <select id="service" name="service" class="searchoption"> <option value="">-- Select Service Name --</option> <?php $resultservice = mysqli_query($con,"Select * from services") ?> <?php while ($line = mysqli_fetch_array($resultservice)) { ?> <option value="<?php echo $line['serviceid'];?>"> <?php echo $line['service'];?> </option> <?php } ?> </select> <br /> </div> <div id="env"> <label for="environment">Environment:</label> <select id="environment" name="environment" class="searchoption"> <option value="">-- Select Environment --</option> <?php $resultdomain = mysqli_query($con,"Select * from evn") ?> <?php while ($line = mysqli_fetch_array($resultdomain)) { ?> <option value="<?php echo $line['envid'];?>"> <?php echo $line['env'];?> </option> <?php } ?> </select><br /> </div> <div id="status"> <label for="status">Status:</label> <select id="status" name="status" class="searchoption"> <option value="Active">Active</option> <option value="Inactive">Inactive</option> </select><br /> </div> <div id="button"> <input type="reset" name="reset"> <input type="submit" name="search" value="Search"> <input type="submit" name="export" value="Export" /> </div> </form> <?php if (isset($_POST['search'])) { if (empty($_POST['service'])) { ?> <div id="message"> <?php echo "Please select service in dropdown" . "</br>"; ?> </div> <?php } else { $service = $_POST['service']; } if (empty($_POST['environment'])) { ?> <div id="message"> <?php echo "Please select Environment in dropdown" . "</br>"; ?> </div> <?php } else { $env = $_POST['environment']; } if ((!empty($service)) && (!empty($env))) { $sql="SELECT servers.ServerName, servers.alias, servers.IPAddress, vip.vipaddress, evn.env, domains.domainname, services.service, tier.tier, os.os, servers.platform, servers.virtualenv, url.url, servers.status FROM servers.servers LEFT OUTER JOIN servers.vip ON (servers.vipaddress = vip.vipid) LEFT OUTER JOIN servers.evn ON (servers.environment = evn.envid) LEFT OUTER JOIN servers.domains ON (servers.Domain = domains.domainid) LEFT OUTER JOIN servers.services ON (servers.service = services.serviceid) LEFT OUTER JOIN servers.tier ON (servers.tier = tier.tierid) LEFT OUTER JOIN servers.os ON (servers.os = os.osid) LEFT OUTER JOIN servers.url ON (servers.endpointurl = url.urlid) where servers.environment = $env and servers.service = $service and servers.status = '$_POST[status]'"; if (!mysqli_query($con,$sql)) { die('Error: ' . mysqli_error($con)); } $mydata = mysqli_query($con,$sql); $rowcount = mysqli_num_rows($mydata); if ($rowcount >= 1) { echo "<table id='main-data-table' border=1> <tr> <th> + </th> <th>Server Name</th> <th>IP Address</th> <th>Service</th> <th>Tier</th> </tr>"; while ($record = mysqli_fetch_array($mydata)) { echo "<tr class='main mainrow'>"; echo "<td><a href='#' class='main'>+</a></td>"; echo "<td>" . $record['ServerName'] . "</td>"; echo "<td>" . $record['IPAddress'] . "</td>"; echo "<td>" . $record['service'] . "</td>"; echo "<td>" . $record['tier'] . "</td>"; echo "</tr>"; //echo "<table border=1>"; echo "<tr class='data showhide'>"; echo "<td>" . "</td>"; echo "<td class='innerleftcol'>" . Server . Name . "</td>"; echo "<td>" . $record['ServerName'] . "</td>"; echo "<td class='innerleftcol'>" . IP . Address . "</td>"; echo "<td>" . $record['IPAddress'] . "</td>"; echo "</tr>"; echo "<tr class='data showhide'>"; echo "<td>" . "</td>"; echo "<td class='innerleftcol'>" . Alias . "</td>"; echo "<td>" . $record['alias'] . "</td>"; echo "<td class='innerleftcol'>" . Environment . "</td>"; echo "<td>" . $record['env'] . "</td>"; echo "</tr>"; echo "<tr class='data showhide'>"; echo "<td>" . "</td>"; echo "<td class='innerleftcol'>" . VIP . Address . "</td>"; echo "<td>" . $record['vipaddress'] . "</td>"; echo "<td class='innerleftcol'>" . Domain . Name . "</td>"; echo "<td>" . $record['domainname'] . "</td>"; echo "</tr>"; echo "<tr class='data showhide'>"; echo "<td>" . "</td>"; echo "<td class='innerleftcol'>" . Service . "</td>"; echo "<td>" . $record['service'] . "</td>"; echo "<td class='innerleftcol'>" . Tier . "</td>"; echo "<td>" . $record['tier'] . "</td>"; echo "</tr>"; echo "<tr class='data showhide'>"; echo "<td>" . "</td>"; echo "<td class='innerleftcol'>" . OS . "</td>"; echo "<td>" . $record['os'] . "</td>"; echo "<td class='innerleftcol'>" . EndPoint . "</td>"; echo "<td>" . $record['url'] . "</td>"; echo "</tr>"; echo "<tr class='data showhide'>"; echo "<td>" . "</td>"; echo "<td class='innerleftcol'>" . Platform . "</td>"; echo "<td>" . $record['platform'] . "</td>"; echo "<td class='innerleftcol'>" . Virtual . "</td>"; echo "<td>" . $record['virtualenv'] . "</td>"; echo "</tr>"; } echo "</table>"; ?> <div id="message"> <?php echo "$rowcount record/s found"; ?> </div> <?php } else { ?> <div id="message"> <?php echo "No records found"; ?> </div> <?php } } else { exit(); } mysqli_close($con); } ?> </div> <?php include('inc/footer.php'); ?>

Here is my index.php code: <?php include('inc/header.php'); ?> <div id="results"> <?php include('dbcon.php'); ?> <form id="searchform" action="index.php" method="post"> <h1>Search</h1> <div id="service"> <label for="service">Service:</label> <select id="service" name="service" class="searchoption"> <option value="">-- Select Service Name --</option> <?php $resultservice = mysqli_query($con,"Select * from services") ?> <?php while ($line = mysqli_fetch_array($resultservice)) { ?> <option value="<?php echo $line['serviceid'];?>"> <?php echo $line['service'];?> </option> <?php } ?> </select> <br /> </div> <div id="env"> <label for="environment">Environment:</label> <select id="environment" name="environment" class="searchoption"> <option value="">-- Select Environment --</option> <?php $resultdomain = mysqli_query($con,"Select * from evn") ?> <?php while ($line = mysqli_fetch_array($resultdomain)) { ?> <option value="<?php echo $line['envid'];?>"> <?php echo $line['env'];?> </option> <?php } ?> </select><br /> </div> <div id="status"> <label for="status">Status:</label> <select id="status" name="status" class="searchoption"> <option value="Active">Active</option> <option value="Inactive">Inactive</option> </select><br /> </div> <div id="button"> <input type="reset" name="reset"> <input type="submit" name="search" value="Search"> <input type="submit" name="export" value="Export" /> </div> </form> <?php if (isset($_POST['search'])) { if (empty($_POST['service'])) { ?> <div id="message"> <?php echo "Please select service in dropdown" . "</br>"; ?> </div> <?php } else { $service = $_POST['service']; } if (empty($_POST['environment'])) { ?> <div id="message"> <?php echo "Please select Environment in dropdown" . "</br>"; ?> </div> <?php } else { $env = $_POST['environment']; } if ((!empty($service)) && (!empty($env))) { $sql="SELECT servers.ServerName, servers.alias, servers.IPAddress, vip.vipaddress, evn.env, domains.domainname, services.service, tier.tier, os.os, servers.platform, servers.virtualenv, url.url, servers.status FROM servers.servers LEFT OUTER JOIN servers.vip ON (servers.vipaddress = vip.vipid) LEFT OUTER JOIN servers.evn ON (servers.environment = evn.envid) LEFT OUTER JOIN servers.domains ON (servers.Domain = domains.domainid) LEFT OUTER JOIN servers.services ON (servers.service = services.serviceid) LEFT OUTER JOIN servers.tier ON (servers.tier = tier.tierid) LEFT OUTER JOIN servers.os ON (servers.os = os.osid) LEFT OUTER JOIN servers.url ON (servers.endpointurl = url.urlid) where servers.environment = $env and servers.service = $service and servers.status = '$_POST[status]'"; if (!mysqli_query($con,$sql)) { die('Error: ' . mysqli_error($con)); } $mydata = mysqli_query($con,$sql); $rowcount = mysqli_num_rows($mydata); if ($rowcount >= 1) { echo "<table id='main-data-table' border=1> <tr> <th> + </th> <th>Server Name</th> <th>IP Address</th> <th>Service</th> <th>Tier</th> </tr>"; while ($record = mysqli_fetch_array($mydata)) { echo "<tr class='main mainrow'>"; echo "<td><a href='#' class='main'>+</a></td>"; echo "<td>" . $record['ServerName'] . "</td>"; echo "<td>" . $record['IPAddress'] . "</td>"; echo "<td>" . $record['service'] . "</td>"; echo "<td>" . $record['tier'] . "</td>"; echo "</tr>"; //echo "<table border=1>"; echo "<tr class='data showhide'>"; echo "<td>" . "</td>"; echo "<td class='innerleftcol'>" . Server . Name . "</td>"; echo "<td>" . $record['ServerName'] . "</td>"; echo "<td class='innerleftcol'>" . IP . Address . "</td>"; echo "<td>" . $record['IPAddress'] . "</td>"; echo "</tr>"; echo "<tr class='data showhide'>"; echo "<td>" . "</td>"; echo "<td class='innerleftcol'>" . Alias . "</td>"; echo "<td>" . $record['alias'] . "</td>"; echo "<td class='innerleftcol'>" . Environment . "</td>"; echo "<td>" . $record['env'] . "</td>"; echo "</tr>"; echo "<tr class='data showhide'>"; echo "<td>" . "</td>"; echo "<td class='innerleftcol'>" . VIP . Address . "</td>"; echo "<td>" . $record['vipaddress'] . "</td>"; echo "<td class='innerleftcol'>" . Domain . Name . "</td>"; echo "<td>" . $record['domainname'] . "</td>"; echo "</tr>"; echo "<tr class='data showhide'>"; echo "<td>" . "</td>"; echo "<td class='innerleftcol'>" . Service . "</td>"; echo "<td>" . $record['service'] . "</td>"; echo "<td class='innerleftcol'>" . Tier . "</td>"; echo "<td>" . $record['tier'] . "</td>"; echo "</tr>"; echo "<tr class='data showhide'>"; echo "<td>" . "</td>"; echo "<td class='innerleftcol'>" . OS . "</td>"; echo "<td>" . $record['os'] . "</td>"; echo "<td class='innerleftcol'>" . EndPoint . "</td>"; echo "<td>" . $record['url'] . "</td>"; echo "</tr>"; echo "<tr class='data showhide'>"; echo "<td>" . "</td>"; echo "<td class='innerleftcol'>" . Platform . "</td>"; echo "<td>" . $record['platform'] . "</td>"; echo "<td class='innerleftcol'>" . Virtual . "</td>"; echo "<td>" . $record['virtualenv'] . "</td>"; echo "</tr>"; } echo "</table>"; ?> <div id="message"> <?php echo "$rowcount record/s found"; ?> </div> <?php } else { ?> <div id="message"> <?php echo "No records found"; ?> </div> <?php } } else { exit(); } mysqli_close($con); } if (isset($_POST['export'])) { printf('<pre>%s</pre>', print_r($_POST, true)); if (empty($_POST['service'])) { ?> <div id="message"> <?php echo "Please select service in dropdown" . "</br>"; ?> </div> <?php } else { $service = $_POST['service']; } if (empty($_POST['environment'])) { ?> <div id="message"> <?php echo "Please select Environment in dropdown" . "</br>"; ?> </div> <?php } else { $env = $_POST['environment']; } if ((!empty($service)) && (!empty($env))) { $sql="SELECT servers.ServerName, servers.alias, servers.IPAddress, vip.vipaddress, evn.env, domains.domainname, services.service, tier.tier, os.os, servers.platform, servers.virtualenv, url.url, servers.status FROM servers.servers LEFT OUTER JOIN servers.vip ON (servers.vipaddress = vip.vipid) LEFT OUTER JOIN servers.evn ON (servers.environment = evn.envid) LEFT OUTER JOIN servers.domains ON (servers.Domain = domains.domainid) LEFT OUTER JOIN servers.services ON (servers.service = services.serviceid) LEFT OUTER JOIN servers.tier ON (servers.tier = tier.tierid) LEFT OUTER JOIN servers.os ON (servers.os = os.osid) LEFT OUTER JOIN servers.url ON (servers.endpointurl = url.urlid) where servers.environment = $env and servers.service = $service and servers.status = '$_POST[status]'"; $result = mysqli_query($con,$sql); if (!result) { die('Error: ' . mysqli_error($con)); } /* * 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'); /* * output header row (if atleast one row exists) */ $headers = array(); foreach (mysqli_fetch_fields($result) as $field) { $headers[] = $field->name; } echocsv($headers); /* * echo the input array as csv data maintaining consistency with most CSV implementations * - uses double-quotes as enclosure when necessary * - uses double double-quotes to escape double-quotes * - uses CRLF as a line separator */ while ($row = mysqli_fetch_row($result)) { echocsv($row); } function echocsv($fields) { $separator = ''; foreach ($fields as $field) { if (preg_match('/\\r|\\n|,|"/', $field)) { $field = '"' . str_replace('"', '""', $field) . '"'; } echo $separator . $field; $separator = ','; } echo "\r\n"; } } } ?> </div> <?php include('inc/footer.php'); ?>

I put it inside if isset statement, and here is the result: Array ( [service] => 3 [environment] => 1 [status] => Active [export] => Export )

So do I need to put the above code inside if isset statement? Or all the way at the end of the code?

Ch0cu3r, Thanks for your reply. I modified the code as per your suggestion. Both old and new code work same. However, when I save the code in separate file, I am able to download csv to my computer, but when I add that code to index.php file where user will click on export button and execute the code, it doesnt work. It just refreshes the page upon the click. Below code is added in index.php file. if (isset($_POST['export'])) { if (empty($_POST['service'])) { echo "Please select service in dropdown" . "</br>"; } else { $service = $_POST['service']; } if (empty($_POST['environment'])) { echo "Please select Environment in dropdown" . "</br>"; } else { $env = $_POST['environment']; } if ((!empty($service)) && (!empty($env))) { $sql="SELECT Query Removed"; $result = mysqli_query($con,$sql); if (!result) { die('Error: ' . mysqli_error($con)); } /* * 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'); /* * output header row */ $headers = array(); foreach (mysqli_fetch_fields($result) as $field) { $headers[] = $field->name; } echocsv($headers); /* * echo the input array as csv data maintaining consistency with most CSV implementations * - uses double-quotes as enclosure when necessary * - uses double double-quotes to escape double-quotes * - uses CRLF as a line separator */ while ($row = mysqli_fetch_row($result)) { echocsv($row); } function echocsv($fields) { $separator = ''; foreach ($fields as $field) { if (preg_match('/\\r|\\n|,|"/', $field)) { $field = '"' . str_replace('"', '""', $field) . '"'; } echo $separator . $field; $separator = ','; } echo "\r\n"; } } }

Hello, I created a web page that executes request from mysql and prints it on web page. I also created a export submit button to export mysql query in csv format file. When I select values and then click on export buttons, I get nothing and page gets refreshed. Here is the link of my site: rahil.me/index.php Here is the code: These are the buttons: <input type="submit" name="search" value="Search"> <input type="submit" name="export" value="Export" /> PHP code: if (isset($_POST['export'])) { if (empty($_POST['service'])) { echo "Please select service in dropdown" . "</br>"; } else { $service = $_POST['service']; } if (empty($_POST['environment'])) { echo "Please select Environment in dropdown" . "</br>"; } else { $env = $_POST['environment']; } if ((!empty($service)) && (!empty($env))) { $sql="SQLQUERY REMOVE"; if (!mysqli_query($con,$sql)) { die('Error: ' . mysqli_error($con)); } $result = mysqli_query($con,$sql); /* * 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'); /* * output header row (if atleast one row exists) */ $row = mysqli_fetch_assoc($result); if ($row) { echocsv(array_keys($row)); } /* * output data rows (if atleast one row exists) */ while ($row) { echocsv($row); $row = mysqli_fetch_assoc($result); } /* * echo the input array as csv data maintaining consistency with most CSV implementations * - uses double-quotes as enclosure when necessary * - uses double double-quotes to escape double-quotes * - uses CRLF as a line separator */ function echocsv($fields) { $separator = ''; foreach ($fields as $field) { if (preg_match('/\\r|\\n|,|"/', $field)) { $field = '"' . str_replace('"', '""', $field) . '"'; } echo $separator . $field; $separator = ','; } echo "\r\n"; } } }

Woohoo.....! @Ch0cu3r, you are genius. Your code fixed my problem. Just to recap what I learned here, is that I have to compare value in the while loop, if it is true it will assign that value to selected variable. Then we are echoing selected value in option, if that is not true it will move along and use whatever value it gets from while loop. Thank you so much to all for your involvement in fixing this. I will definitely participate on this community more to learn. Thanks, Ray

Hello bsmither, Thank you for your advice. I really appreciate your help on educating me. I was stuck on post #6 and couldn't figure out how to fix the broken html page. However, the broken html page is still not fixed after making the change. But when I remove the code and keep this original code I am able to browse the page without any issue. Here is the original code which works: <?php include('dbcon.php'); ?> <form id="searchform" action="index.php" method="post"> <table> <tr> <td class="searchleftcol"><h3>Service:</h3></td> <td> <select id="service" name="service" class="searchoption"> <option value="">-- Select Service Name --</option> <?php $resultservice = mysqli_query($con,"Select * from services") ?> <?php while ($line = mysqli_fetch_array($resultservice)) { ?> <option value="<?php echo $line['serviceid']; ?>"> <?php echo $line['service'];?> </option> <?php } ?> </select> </td> </tr> <tr> <td> <h3>Environment:</h3> </td> <td> <select id="environment" name="environment" class="searchoption"> <option value="">-- Select Environment --</option> <?php $resultdomain = mysqli_query($con,"Select * from evn") ?> <?php while ($line = mysqli_fetch_array($resultdomain)) { ?> <option value="<?php echo $line['envid'];?>"> <?php echo $line['env'];?> </option> <?php } ?> </select> </td> </tr> <tr> <td> <h3>Status:</h3> </td> <td> <select name="status" class="searchoption"> <option value="Active">Active</option> <option value="Inactive">Inactive</option> </select> </td> </tr> </table> <input type="reset" name="reset"> <input type="submit" name="submit" value="Search"> </ul> </form> <?php if (isset($_POST['submit'])) { if (empty($_POST['service'])) { echo "Please select service in dropdown" . "</br>"; } else { $service = $_POST['service']; } if (empty($_POST['environment'])) { echo "Please select Environment in dropdown" . "</br>"; } else { $env = $_POST['environment']; } if ((!empty($service)) && (!empty($env))) { $sql="select * from TableName"; //Original Query removed if (!mysqli_query($con,$sql)) { die('Error: ' . mysqli_error($con)); } $mydata = mysqli_query($con,$sql); $rowcount = mysqli_num_rows($mydata); if ($rowcount >= 1) { echo "<table id='main-data-table' border=1> <tr> <th> + </th> <th>Server Name</th> <th>IP Address</th> <th>Service</th> <th>Tier</th> </tr>"; while ($record = mysqli_fetch_array($mydata)) { echo "<tr class='main mainrow'>"; echo "<td><a href='#' class='main'>+</a></td>"; echo "<td>" . $record['ServerName'] . "</td>"; echo "<td>" . $record['IPAddress'] . "</td>"; echo "<td>" . $record['service'] . "</td>"; echo "<td>" . $record['tier'] . "</td>"; echo "</tr>"; //echo "<table border=1>"; echo "<tr class='data showhide'>"; echo "<td>" . "</td>"; echo "<td class='innerleftcol'>" . Server . Name . "</td>"; echo "<td>" . $record['ServerName'] . "</td>"; echo "<td class='innerleftcol'>" . IP . Address . "</td>"; echo "<td>" . $record['IPAddress'] . "</td>"; echo "</tr>"; echo "<tr class='data showhide'>"; echo "<td>" . "</td>"; echo "<td class='innerleftcol'>" . Alias . "</td>"; echo "<td>" . $record['alias'] . "</td>"; echo "<td class='innerleftcol'>" . Environment . "</td>"; echo "<td>" . $record['env'] . "</td>"; echo "</tr>"; echo "<tr class='data showhide'>"; echo "<td>" . "</td>"; echo "<td class='innerleftcol'>" . VIP . Address . "</td>"; echo "<td>" . $record['vipaddress'] . "</td>"; echo "<td class='innerleftcol'>" . Domain . Name . "</td>"; echo "<td>" . $record['domainname'] . "</td>"; echo "</tr>"; echo "<tr class='data showhide'>"; echo "<td>" . "</td>"; echo "<td class='innerleftcol'>" . Service . "</td>"; echo "<td>" . $record['service'] . "</td>"; echo "<td class='innerleftcol'>" . Tier . "</td>"; echo "<td>" . $record['tier'] . "</td>"; echo "</tr>"; echo "<tr class='data showhide'>"; echo "<td>" . "</td>"; echo "<td class='innerleftcol'>" . OS . "</td>"; echo "<td>" . $record['os'] . "</td>"; echo "<td class='innerleftcol'>" . EndPoint . "</td>"; echo "<td>" . $record['url'] . "</td>"; echo "</tr>"; echo "<tr class='data showhide'>"; echo "<td>" . "</td>"; echo "<td class='innerleftcol'>" . Platform . "</td>"; echo "<td>" . $record['platform'] . "</td>"; echo "<td class='innerleftcol'>" . Virtual . "</td>"; echo "<td>" . $record['virtualenv'] . "</td>"; echo "</tr>"; } echo "</table>"; echo "$rowcount record/s found"; } else { echo "No records found"; } } else { exit(); } mysqli_close($con); } ?> </body> </html>

Ahh I see what you mean... I have to replace $_POST['service'] == $service to ($line['serviceid'] == $service) so it would look like this: <option value="<?php echo $line['serviceid']; if ($line['serviceid'] == $service) {echo 'selected="selected"'} echo $line['serviceid']; ?>"> <?php echo $line['service'];?> </option> I will test this and keep you posted Thank you very much. Ray

Hello bsmither, Thank you for your quick response. Once the form is submitted, I am holding that value in below code: <?php if (isset($_POST['submit'])) { if (empty($_POST['service'])) { echo "Please select service in dropdown" . "</br>"; } else { $service = $_POST['service']; } I hope that answers your question. Do you want me to copy paste entire code? Thanks, Ray

I looked at several community forums, and I am unable to figure it out on how to retain select option value after validation fails. Here is the code that works for me, but values disappear when submit button is submitted. <select id="service" name="service" class="searchoption"> <option value="">-- Select Service Name --</option> <?php $resultservice = mysqli_query($con,"Select * from services") ?> <?php while ($line = mysqli_fetch_array($resultservice)) { ?> <option value="<?php echo $line['serviceid'];?>"> <?php echo $line['service'];?> </option> <?php } ?> </select> Here is what I tried and doesn't work for me: <select id="service" name="service" class="searchoption"> <option value="">-- Select Service Name --</option> <?php $resultservice = mysqli_query($con,"Select * from services") ?> <?php while ($line = mysqli_fetch_array($resultservice)) { ?> <option value="<?php echo $line['serviceid']; if ($_POST['service'] == $service) {echo 'selected="selected"'} echo $line['serviceid']; ?>"> <?php echo $line['service'];?> </option> <?php } ?> </select>