help me up

[roger5089]

if i create one system use php script the method read data from database and post data to http, but when i insert data into database how can i make php script automaticlly send data to http

[sijis]

huh?

i'm sorry but what you are saying doesn't make any sense to me.

[Psyche]

Reformulate that please.

[roger5089]

<?

require("db.php");

$web_link =pg_connect("host=$psql_server port=5432 dbname=$psql_notes_dbname user=$psql_web_username password=$psql_web_password");

$query ="select deliver_date,target,message,response_url from a order by id desc limit 1";

$result = pg_query ($web_link,$query);

$qr = pg_fetch_object ($result, 0);

$agentid =2123;
$target =$qr->target;
$message =$qr->message;
$deliver_date =$qr->deliver_date;
$response_url =$qr->response_url;
$url="http://211.21.147.30:7744/sendmessage.php?agentid=$agentid&target=$target&message=\"$message\"&deliver_date=$deliver_date&response_url=$response_url";
header("location:$url");

if($result){

    session_register("m_target");
    session_register("m_message");
    session_register("m_deliver_date");
    session_register("m_response_url");

    $m_target=$target;
    $m_password=$message;
    $m_name=$deliver_date;
    $m_pstate=$response_url;

for($row =0; $row < pg_numrows($result);$row++){

$fullname .=pg_result($result,$row,'target')."";
$fullname .=pg_result($result,$row,'message')."";
$fullname .=pg_result($result,$row,'deliver_date')."";
$fullname .=pg_result($result,$row,'response_url');


echo($url);

echo"<table border = 5>";

// echo "<META HTTP-EQUIV=Refresh Content='3; URL=http://61.218.68.20/~roger/testresponse.php'>";
while ($a_row=pg_fetch_row($result)){

echo"<tr>";
foreach ($a_row as $field)
echo"<td><h5>$field</h5></td>";
echo"</tr>";

}

echo "</table>";
}

}else{
echo"The query failed with the follow erro:<br>\n";
echo pg_errormessage($web_link);
}

?>

[sijis]

correct me if i'm wrong but once you put
header(location:$url);
the page should redirect to that page immediately, so any code after that isnt executed.

i'm really don't understand the question fully.
but i think you want to do this:

remove the header(location: $url) statement.

change:
"<META HTTP-EQUIV=Refresh Content='3; URL=http://61.218.68.20/~roger/testresponse.php'>";
to
"<META HTTP-EQUIV=Refresh Content='3; URL=$url>";

is that what you want.

[roger5089]

hi man thank you suggestion

roger

[roger5089]

hi every body

and sijis

thank you suggestion and it worked right now,but if the system does not run on website run on unix system how can i do it.

if run on website the system will keep send me message and in my system i should add delete isn't it.

once again thank' sijis

[roger5089]

other help
if in my script how can i use socket methods