How to get data from mySQL and insert it in Array?

[rodman]

My mySQL table is on one server but PHP file which I want insert some info from this mySQL table is on another server. And also I need insert this information into Array in PHP file.

I know how to conect to mySQL server and how to get info from there and write it but I do not know how to insert it into Array in PHP file spesially when there is already some info in this Array from before.
So actually I need to update my Array with new info from mySQL table.

Here is what I got so far:

<?php
/ Connecting, selecting database /
$link = mysql_connect("www.domain.com:80/", "user", "pass")
or die("Could not connect : " . mysql_error());
echo "Connected successfully";
mysql_select_db("helpdemo_xcart") or die("Could not select database");

/ Performing SQL query /
$query = "SELECT * FROM xcart_customers";
$result = mysql_query($query) or die("Query failed : " . mysql_error());

/ Inserting results in to PHP file /

$line = mysql_fetch_array($result, MYSQL_ASSOC)) ;

$toSave = $line;
//Open a file in write mode
$fp = fopen("test4/file.txt", "w");
if(fwrite($fp, $line)) echo "writing=Ok";
else echo "writing=Error";
fclose($fp);

/ Free resultset /
mysql_free_result($result);

/ Closing connection /
mysql_close($link);
?>

So I need to update my Array with new info from mySQL table.

any advices are welcome

Thanks a lot!

[dalecosp]

Here's a fairly simple function from Welling & Thompson's PHP & MySQL Web Development:

function db_result_to_array($result) {
   $res_array = array();
   for ($count=0; $row = @mysql_fetch_array($result); $count++) { 
               $res_array[$count] = $row; 
    }
   return $res_array;
        }

Feed it a resource identifier, and you get an array back, e.g.:

$sql="select * from foo where bar=$baz";
$result=mysql_query($sql);
$mydata=db_result_to_array($result);

There are probably slightly better ways, but this is a good starter.

[rodman]

I think you people did not understand me right:

I need to fetch data from mySQL database and update existing Array in a PHP file

Here is file which should update my Array in PHP file:

<?php
/ Connecting, selecting database /
$link = mysql_connect("localhost", "user", "pass")
or die("Could not connect : " . mysql_error());
echo "Connected successfully";
mysql_select_db("helpdemo_xcart") or die("Could not select database");

/ Performing SQL query /
$query = "SELECT url FROM xcart_customers";
$result = mysql_query($query) or die("Query failed : " . mysql_error());

/ Inserting results in alowed IP file /

while ($row = mysql_fetch_array($result)) {
extract($row);
$line[] = $result; / I think mistake is here but I do not know how to fiks it /
}

//Open a file in write mode
$fp = fopen("key.php", "w");
if(fwrite($fp, $line)) echo "writing=Ok";
else echo "writing=Error";
fclose($fp);

/ Free resultset /
mysql_free_result($result);

/ Closing connection /
mysql_close($link);
?>

And here is my PHP file(key.php):

<?php

$line = array("195.39.35.31","81.0.235.34","217.11.238.194");

foreach($line as $ip)
{
if($ip == $_SERVER[REMOTE_ADDR])
{
$allowaccess = 1;
}
}

if($allowaccess)
{
echo "Comments=2";
}

else
{
echo "Comments=3";
}

?>

What I need is to update my array $line with new values from database. The first file should do the job but it does not work.

So I need to update my Array with new info from mySQL table.

any advices are welcome

Thanks a lot!

[dnast]

Why not just retrieve the ip's straight from the database in key.php?

key.php

<?php
....(database connect and query code)...


$line = mysql_fetch_row($result);

foreach($line as $ip)
{
  if($ip == $_SERVER[REMOTE_ADDR])
  {
    $allowaccess = 1;
  }
}

if($allowaccess)
{
  echo "Comments=2";
}

else
{
  echo "Comments=3";
}

?>

This would do exactly the same thing you're trying to do but much easier.