Retrieving Data

Anon

Greetings everyone

I am a PHP novice, and I have created as simple script which allows users to input information, and save it to an SQL databse. The problem I am facing now is, what options do I have for extracting that inforamtion? All I have been able to find so far are programs which simply dump the data into a query, and then print the query. I am looking for either:

a seperate web site which could list the information

or to make the SQL databse into its own file, which could be opened by MS Access.

Any thouhgts or suggestions?

Thanks
Chris

Anon

If I got your question:

Let me explain it by example:
Table = TableName
and Contains fields: Field1, Field2, Field3,...

$query = "select * from TableName where where_condition order FieldName ....
$result = mysql_query($query);

// now you can use mysql_fetch_object() or mysql_fetch_array().

// If you want to use mysql_fetch_object, it works as follows
echo "<table>",
while($data = mysql_fetch_object($result)){
echo <tr><td>$data->Field1</td><td>$data->Field2</td><td>.........</td></tr>";
}
echo "</table>";
// mysql_fetch_array()
echo "<table>";
while($data = mysql_fetch_array(4result)){
echo "<tr><td>$data['Field1']</td><td>$data['Field2']</td><td>......</td></tr>";
}
echo "<table>";

Solomon

Anon

Hi, my name is Ivan

I've created a text where I the traffic from
all user in my local system. I've got difficulties extracting the exact string from the file. Can anybody give me an example script of how this works?

the file conains rows like this iptables:

4354k 49779M eth0 * all 10.0.0.99

and so. I need to extract the numbers
10x

Anon

Do you want to read text file or what?

If you want to read a text file named filename.txt, you can use the following method:
<?
$file_open=fopen("filename.txt",'r');
while (!feof($file_open))
{
$store_content[]=fgets($file_open,3997);
}
fclose($file_open);
for ($i=0;$i<count($store_content);$i++)
{
print $store_content[$i];
}
?>

Anon

Thanks for that code Soloman, I will try it. Do you have code for dumping an SQL databse into a text file?