How To? - Codewalkers

Codewalkers Forums Sponsor:

October 16th, 2003, 07:02 PM

Anonymous

Registered User

Codewalkers God 35th Plane (22000 - 22499 posts)

Join Date: Apr 2007

Posts: 22,309

Time spent in forums: < 1 sec
Reputation Power: 24

How To?

Question: How would one extract data from a file and format it in HTML.

Example: User inputs account number and extracts current month transactions. Transactions are then formatted for HTML display. Would I use PHP, MySQL??? Any help would be appreciated..

Thanks in advance,
Barry.

October 16th, 2003, 10:36 PM

usulix

Join Date: Apr 2007

Location: Tucson, Arizona, US

Posts: 16

Time spent in forums: < 1 sec
Reputation Power: 0

RE: How To?

I'd say if you have a file... upload the file contents into a table in MySQL -- LOAD DATA LOCAL INFILE from the MySQL manual or some such depending on how you get to the MySQL server.

Then use php to process the form and return the HTML.

Just a sketch but it should get you started.

Assuming PHP and MySQL on the server.

Assuming table transactions with primary key account_num

HTML form is sent to client with action="getTrans.php" the php file which will process the script.

Client fills in the form and clicks submit

Here's the connection and formatting stuff straight out of the php manual modified a bit for the situation. This would be in the getTrans.php file on the server.

php Code:

Original - php Code

 
 
 
/* Connecting, selecting database */
$html="<html><head><title>RESULTS</title></head>";
   $link = mysql_connect("mysql_host", "mysql_user", "mysql_password")
       or die("Could not connect");
   $html.= "<h4>Connected successfully</h4>";
   mysql_select_db("my_database") or die("Could not select database");
 
   /* Performing SQL query */
   $query = "SELECT * FROM transactions where
account_num='".$_POST['account_num']."'";
   $result = mysql_query($query) or die("Query failed");
 
   /* Printing results in HTML */
   $html.= "<table>n";
   
   /* do header rows for labeling */
   $html.="<tr>
   <th>Date</th>
   <th>Amount</th>
   <th>Payee</th>
   <th>Transaction Number</th>
   </tr>";
 
/* cycle through results returned - format them */
   while ($line = mysql_fetch_array($result)){
       $html.= "<tr>n";
       $html.= "<td>".$line['date']."</td>
       <td>".$line['amount']."</td>
       <td>".$line['payee']."</td>
       <td>".$line['transaction_num']."</td>";
       $html.= "</tr>n";
   }
   $html.= "</table></body></html>n";
 
   /* Free resultset */
   mysql_free_result($result);
 
   /* Closing connection */
   mysql_close($link);
 
    /* send page to client */
   echo $html;

Cheers,
Greg

Viewing: Codewalkers Forums > Other Technologies > Client Side Things > How To?

« Previous Thread | Next Thread »

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off

View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox

Forum Jump