PHP Script Help?

ben2005

I have a table wihtin an HTML page named usersdata.html and also have a mysql table in database that looks like this:

id username

0 user1

1 user2

the table within the HTML page stored in /var/www/html/usersdata.html

<table>
<tr><th>Username</th><th>head1</th><th>head2</th><th>head3</th></tr>
<tr><td><a href="users.php?showuser=y&account=user1">user1</a></td><td>1269</td><td>0.00</td><td>0.00</tr></tr>
<tr><td><a href="users.php?showuser=y&account=user2">user2</a></td><td>338</td><td>12.49</td><td>10.64</tr></tr>
</table>

Question: How do I accomplish this by writing a PHP script that should look like this:

<?php

loop fo each user in the mysql table {

while opening and searching through the file "userdata.html" {

match the first corresponding amount for the user ( example user1's amount is 0.00, user2's amount is: 12.49 as shown in the HTML table)
store the match (amount) in a variable "let's say $useramount"
store the variable $useramount in another table ( I can manage to do this myself, just to explain the purpose of doing this)

}

Any help will be appreciated, thanks guys!!
mouncifb@yahoo.com

bradgrafelman

Have you tried reading the PHP manual and attempting this?

How much do you already know about PHP and connecting/querying a MySQL database? Try looking at the man pages for [man]mysql_query/man and [man]mysql_fetch_assoc[/man] (or any of the other MySQL fetching-functions; I just use the _assoc one the most) and giving it a shot. Then, post what you came up with and we can show you where you went astray.

ben2005

<?php

$dbhost = 'localhost';
$dbuser = user;
$dbpass = 'xxxxxxx';

$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to mysql');

$dbname = 'database';
mysql_select_db($dbname);

$query="select username from usertable ;";
$result = mysql_query($query);
while($row = mysql_fetch_array($result, MYSQL_ASSOC))

{

// this is the part where I don't know how to proceed with

while opening and searching through the file "userdata.html" {

//end

}

Thank you so much for helping me out!

m_tt

Are you trying to pull each users amount from the HTML source?

If so, you could probably do it with a combination of strip_tags and preg_match

ben2005

Yes I am trying to pull each users amount from the HTML source, any example on how do it in my situation? Thank you

Blulagoon

Where does the data in head1, head2 and head3 columns in your html table come from, is it hard coded, is it from user input or is it from a mysql db.

There may be easier ways to do this, depending on the answers to the above.

Blu

ben2005

It's hard coded, I need to access the HTML source and do the rest of the stuff I mentioned above. I care about this line:

once the user's amount is matched and stored in a variable I would like put it in a table database which makes it easier for me to access and manipulate.

head1, head2,... do not matter.

Thanks

Blulagoon

OK, so let me see if I have got this right, as I don't think I have.

For user1 the 1269, the 0.00 and the 0.00 are hard coded in the html
For user2 the 338, the 12.49 and the 10.64 are hard coded in the html

or are you getting these from user input or a db ?

If these are hard coded, can't you also simply hard code them into a variable as input type = hidden and pass them from page to page via form ?

ben2005

The HTML page is generated from a DB but I do not have access to this DB, I have to grab all information using the script and do the manupulation.

I want these 2:

user1's amount is: 0.00
user2's amount is: 12.49

these amounts varie everyday, I have to download the source page every single day,
call the script to do the rest of what I mentioned above on this page.

the second's amount's: 0.00 and 10.64 are not my subject in the code.

also I was thinking is it possible to turn the HTML table into CSV file, export to mysql table, then it will be easier for me to the rest with no hassle.

Thank you so much for the help guys!

ben2005

anyone can help? is it possible to do?

samudasu

Yes it's possible. Take a look at php's Dom functions.

ben2005

it did not help me at all, can someone show me another way to do this? thanks

Blulagoon

If you've got to open the file and parse it to find the bits you want, you'll have to look at the following functions:
fopen
fread
fgets
fclose

Not ones I've used much myself, so check the manual at php.net
Blu

samudasu

Ok, i'm going to throw you a bone and show you a way to collect data from the <td> cells. This scipt depends on your server having the DOM functions enabled. This means php5. If you want to use php4 you can use dom xml but you'll need to do some changing.
You're pretty much at the mercy of whoever owns the website your scraping data from. If they change something then it might not work. For line number 2, you'll just use the name of the html file. Line number 5 is important. Counting from zero, you'll need find the table you want from the html file. When you know what table number has the data, set the item number. If you only have 1 table in your file then it'll be 0. The results will be printed out in a multi-dimensional array. From that point you can grab whatever data you need out of the array.

<?php
$doc = new DOMDocument;
$doc->loadHTMLFile('yourfile.html');
$table = $doc->getElementsByTagName('table');
$infotable = $table->item(0);  // IMPORTANT!! change item(0) to correct number
$tablerow = $infotable->getElementsByTagName('tr');
$count = 0;
foreach ($tablerow as $row) {
    $td = $row->getElementsByTagName('td');
    foreach ($td as $val) {
        if ($val->nodeName == 'td') {
            $arr[$count][] = $val->nodeValue;
        }
    }
    $count++;
}
print "<pre>" . print_r($arr, true) . "</pre>";
?>