在php中运行脚本，查找尚未在mysql中修改的项目

Question

I have db with column named "link". Links have redirect urls, which I want to change. I have php script, which would take the link and gives me output as follows:

$redo = get_redirect('htp://www.mydomain.com/long/url/here&ID=123');

print_r($rez);

this is the output:

Array
(
    [0] => htp://www.otherdomain.com
)

how do I loop all items in my database, and run this script for each item. my db is called "apps" and table is called "items" and column containing urls is called "link" above php script is called getredirect.php

Also when I run script I need to run without the "&ID=123&otherstuff=whatever"

(htp supposed to be http... I can't add links per board rules)

Answer 1

how do I loop all items in my database, and run this script for each item

Can you just do a simple select and put it in an array, and loop through it?

$con = mysql_connect("localhost","peter","abc123");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("my_db", $con);

$result = mysql_query("SELECT link FROM apps");

while($row = mysql_fetch_array($result))
  {
      $url=implode('&', $row[0]);
      include 'getredirect.php?url='.$url;

  }

mysql_close($con);

Not sure whether it helps, your question is kinda unclear to me.

If you aren't sure of the output, you can put a print_r statement, i.e.,

while($row = mysql_fetch_array($result))
  {
      print_r($row);
      include 'getredirect.php?url='.$url;

  }

This would help you understand the PHP code clearer