[Resolved] Updateing field using php varuable

chriswheat

Hello,

This I am sure is a rookie question but here goes.

I have a varuable $btn

I want to take what ever data that is currently in the field "news" in table "scrape_btn" and replace it with $btn
I am using php and MYSQL

Here is all of the code... I used or die() statements at the end of my mysql statements then used a print mysql success to determine were the problem is. It appears to connect to the db and the table however it seams to die at the update command.

<?php
mysql_connect ('localhost', 'myuser', 'mypassword')or die();
print "connect success";
mysql_select_db ('mydatabase')or die();
print " select db success";
$open = fopen("http://www.someserver.com/headlines/index.jsp", "r");

// the above statement opens up the page using the socket libraries and reads it,
// fopen takes the pages as the 1st arguement and type of opening (r in this case) as the 2nd

$read = fread($open, 45000);

// fread scours to the 15000th byte and captures all the encountered bytes into $read

fclose($open);

$search = eregi("<IMG SRC=\"/images/tab_headlines.gif\" WIDTH=\"147\" HEIGHT=\"17\" BORDER=\"0\"> (.*)<TD valign=\"top\" ALIGN=\"center\">", $read, $printing);

// Case insensitive search on the data

$printing[1] = str_replace("<TABLE cellspacing=\"2\" cellpadding=\"2\" border=\"0\" width=\"100%\">", "", $printing[1]);
$printing[1] = str_replace("<TR>", "", $printing[1]);
$printing[1] = str_replace("<TD>", "", $printing[1]);
$printing[1] = str_replace("<IMG BORDER=\"0\" HEIGHT=\"12\" WIDTH=\"10\" SRC=\"/images/arrow.gif\">", "", $printing[1]);
$printing[1] = str_replace("", "", $printing[1]);
$printing[1] = str_replace("</TD>", "", $printing[1]);
$printing[1] = str_replace("</TR>", "", $printing[1]);
$printing[1] = str_replace("</TABLE>", "", $printing[1]);
$printing[1] = str_replace(" ", "", $printing[1]);
$printing[1] = str_replace("HREF=\"", "href=\"javascript:New('http://www.someserver.com", $printing[1]);
$printing[1] = str_replace("\">", "');\">", $printing[1]);
$printing[1] = str_replace("</A>", "</A> ", $printing[1]);

// Striping and replacing data

$content = $printing[1];
$content = explode("·", $content);

// well this is also a common cancellation or rather the place where the shifting headlines into
// elements actually takes place with the help of "?" and explode();

$headlines = sizeof($content);

// counting the array elements

for ($i = 0; $i < $headlines; $i++) {

$btn = $content[$i];

// If I use print "$btn"; instead of the below two statements it prints.

mysql_query("UPDATE scrape_btn SET news='".$btn."'")or die();

print " Databes Update Success";

}

What is wrong with my mysql_query statement?

Many Thanks
Chris W.

LordShryku

Change your die statement to include the error. Maybe there's a single quote in your text, or you're going past the allowed length of the field

mysql_query("UPDATE scrape_btn SET news='".$btn."'")or die("Error: ".mysql_error());

chriswheat

Thank YOU! it was a few ' that was causing the issue. I added
$printing[1] = str_replace("'", "", $printing[1]);

And it worked.

I am extremely new to this is their any other charaters that could cause the same problem?

Also as dumb as this sounds how do I know get the info out of the data base and display it?

MANY THANKS!

LordShryku

Single quotes are the killer. They signify the end of your data. As long as you'r inside the single quotes, you should be fine.

As for pulling the data, search the forums. It's a really common question....

chriswheat

From looking around this is what I came up with.

<?php
mysql_connect ('localhost', 'user', 'password')or die();
//print "connect success";
mysql_select_db ('mydb')or die();
//print " select db success";

$result = mysql_query('SELECT news FROM scrape_btn')or die(mysql_error());
print "$result";
?>

This is what is displayed on the screen when the script is ran
Resource id #3

However this is what is in the field news, table scrape_btn

<A href="http://www.server.com/headlines/article_display.jsp?vnu_content_id=1996677" target="blank">Hotel Renovation To Hit Six-Year High</A> 
<A href="http://www.server.com/headlines/article_display.jsp?vnu_content_id=1995340" target="blank">Amex Closes Rosenbluth Deal</A> 
<A href="http://www.server.com/headlines/article_display.jsp?vnu_content_id=1994712" target="_blank">Delta Launching Codeshare E-Tix With CO, NW</A>

What am I not doing?

Man their is a serious learning curve to all of this.

Thanks
Chris W

LordShryku

Close..you need to fetch the results

<?php 
$conn = mysql_connect ('localhost', 'user', 'password')
mysql_select_db ('mydb', $conn)or die(); 
$result = mysql_query('SELECT news FROM scrape_btn');
while($row=mysql_fetch_array($result)) {
   echo $row['news'];
}
mysql_close($conn);
?>

chriswheat

Many Many thanks... You saved my hair line 😕

LordShryku

Really? Can you get me a new hairline then? Mine seems to be leaving me....