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!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by 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) {...- mamasita60440
- Post #7
- Forum: PHP
-
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...- mamasita60440
- Post #6
- Forum: PHP
-
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...- mamasita60440
- Post #5
- Forum: PHP
-
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 =...- mamasita60440
- Post #3
- Forum: PHP
-
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...- mamasita60440
- Thread
- Replies: 7
- Forum: PHP
-
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...- mamasita60440
- Post #3
- Forum: PHP
-
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...- mamasita60440
- Thread
- Replies: 3
- Forum: PHP
-
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?- mamasita60440
- Post #18
- Forum: PHP
-
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'>...- mamasita60440
- Post #16
- Forum: PHP
-
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- mamasita60440
- Post #14
- Forum: PHP
-
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>"...- mamasita60440
- Post #11
- Forum: PHP
-
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"...- mamasita60440
- Post #8
- Forum: PHP
-
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)...- mamasita60440
- Post #5
- Forum: PHP
-
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...- mamasita60440
- Thread
- Replies: 19
- Forum: PHP
-
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...- mamasita60440
- Post #3
- Forum: MySQL
