Run script in php for items not modified yet in 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 out put 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) Thanks

Answer 1

Looks like your get_redirect is just a function that connects to DB and gets the redirect URL for a given URL.

You can write a SQL query to get redirects for all the items:

Select urls,link from apps.items;

You could also modify the function defenition so it expects multiple items and returns approporate redirects:

function get_multiple_redirect($aItems){

$SQL = "Select urls,link from apps.items WHERE url IN ('" . implode("','",$aItems) ."')";
#... add mysql calls here


print_r( get_multiple_redirect(array("http://abc","http://def")) );
}

Answer 2

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