Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. mamasita60440

    Export data from php page to excel spreadsheet

    The code is printing to the excel sheet, but now only one field is printing. I thought with the foreach statement the entire row would print. Here is the code, any suggestions? Thanks. <?php session_start(); $_SESSION["ReportData"]; ?> <?php foreach($_SESSION as $line) {...
  2. mamasita60440

    Export data from php page to excel spreadsheet

    Ok...so i changed the code again. This time I am no longer querying the db b/c according to print_r all of the session variables are being exported to the spreadsheet. Here is what I have so far <?php session_start(); $ID=$_SESSION["ReportData"]; ?> <?php $line = ''; foreach($ID...
  3. mamasita60440

    Export data from php page to excel spreadsheet

    Yes, I have tested all the code. The information submitted on the 'PfrReports.php' form is displayed on the 'displayReportData.php' page. On the tryexcel.php I started another session and created a variable 'PerformanceID' which is equal to the session variable 'ReportData'. When I run the...
  4. mamasita60440

    Export data from php page to excel spreadsheet

    Here is the code for the form 'PfrReports.php' which submits to the 'displayReportData.php'. <?php session_start(); $PfrDate =$_SESSION["PfrDate"]=$_POST["PfrDate"]; ?> <html> <head> <title>Displaying MySQL Data</title> </head> <body> <?php $db_host = "????"; $db_user = "???"; $db_pwd =...
  5. mamasita60440

    Export data from php page to excel spreadsheet

    I am trying to export contents from a php page to an excel spreadsheet. I am not an expert so my code may not be as sophisticated. For some reason the variables from the previous page are not posting even though I have created a session and listed the variables. Here is the code for the page...
  6. mamasita60440

    Generate dynamic graphs from data in mysql db using php and excel or j

    Instead of generating dynamic graphs I have decided to export the data to an excel spreadsheet. The catch is that I only want the data that has been selected using checkboxes on a previous page to be exported to the spreadsheet. With the code I am using I can generate the excel sheet but the...
  7. mamasita60440

    Generate dynamic graphs from data in mysql db using php and excel or j

    I need to display selected data from a mysql database in basic line graphs using php. I am open to using excel but thought I saw something about php having a tool called jgraphs. To give you a little background info about my application: 1. Users can search the databases by date. They...
  8. mamasita60440

    using checkbox to select row of data from select query

    yes this is what i am trying to do. I would like for the user to be able to select an item, receive a confirmation displaying what they have selected. finally, this information will be sent to an excel spreadsheet to create a graph. Can you help me?
  9. mamasita60440

    using checkbox to select row of data from select query

    I tried the following, but I am still seeing the same results. <?php session_start(); $_SESSION["ReportData"]=$_POST["ReportData"]; $_SESSION["HandleName"]=$_POST["HandleName"]; ?> <form action="insertPfrGraph.xls" method= "post" name="FormName"> <html> <body> <table> <table border='1'>...
  10. mamasita60440

    using checkbox to select row of data from select query

    Could someone give me an example of how I would assign an id to each row? Thanks
  11. mamasita60440

    using checkbox to select row of data from select query

    I tried that code as well as this variation: foreach ($_POST['ReportData'] as $cbox=>$cboxvalue): $HandleName= {$_POST["HandleName"][$cbox]}; $LoadName= {$_POST["LoadName"][$cbox]}; echo "<tr><td><?php echo $_POST["HandleName"]; ?></td> <td></td><?php echo $_POST["LoadName"]; ?></td></tr>"...
  12. mamasita60440

    using checkbox to select row of data from select query

    I incorporated jpadie's code into into my form (PfrReportData.php). <?php session_start(); $PfrDate=$__SESSION["PfrDate"]; ?> <html> <head> <title>Displaying MySQL Data</title> </head> <body> <?php $db_host = "host"; $db_user = "me"; $db_pwd = "43777"; $db_name = "dbname"...
  13. mamasita60440

    using checkbox to select row of data from select query

    Here is my code: <?php session_start(); $PfrDate=$_Session["PfrDate"]; ?> <html> <head> <title>Performance Data By Date</title> </head> <body> <?php $db_host = "host"; $db_user = "me"; $db_pwd = "43777"; $db_name = "name"; mysql_connect($db_host, $db_user, $db_pwd); mysql_select_db($db_name)...
  14. mamasita60440

    using checkbox to select row of data from select query

    I have a page that displays output from a mysql query in a table. I added checkboxes to each row. If the checkboxes are checked when I click the submit button I would like to take the data for just the rows that are checked and send that information to an excell spreadsheet. The problem is I...
  15. mamasita60440

    Creating relationships b/t tables with data from online form

    I have a page that displays output from a mysql query in a table. I added checkboxes to each row. If the checkboxes are checked when I click the submit button I would to take the data for just the rows that are checked and send that information to an excell spreadsheet. The problem is I don't...
  16. mamasita60440

    Creating relationships b/t tables with data from online form

    I'm creating an online form connected to a MYSQL database. The database will have 4 tables (Handle, Load, Server, and Performance). The database will be populated by information entered in the form. I want to create a relationship between Handle-->Performance Load--->Performance...

Part and Inventory Search

Back
Top