bores_escalovsk

didnt declare $id ~~facepalm~~

<?php $db = new PDO('mysql:host=localhost;dbname=wordpress', 'root',''); //---------prepare $delete3 = $db->prepare("DELETE FROM wp_term_relationships WHERE object_id=:id"); $delete2 = $db->prepare("DELETE FROM wp_posts WHERE ID=:id"); $delete = $db->prepare("DELETE FROM wp_postmeta WHERE post_id=:id"); $select = $db->prepare("SELECT post_id FROM reference WHERE x_id=?"); $delete->bindValue(':id', $id, PDO::PARAM_STR); $delete2->bindValue(':id', $id, PDO::PARAM_STR); $delete3->bindValue(':id', $id, PDO::PARAM_STR); //---------- echo 'conected-----'; { $delfeed = '';} $array = explode(',',$delfeed); foreach($array as $deadman){ $select->execute(array($deadman)); $row = $select->Fetch(PDO::FETCH_ASSOC); $id = $row['post_id']; if ($id == null){} else { echo "$id"."\n"; $delete->execute(); $delete2->execute(); $delete3->execute(); } $id++; } echo 'done!'; ?> its a simple delete script but it doesnt delete, it does print the right $id's witch means is working till there but delete goes bananas,double checked table names ,colums... tryied working with question mark place holders insted of bind parameter but nothing

as always i screwed up everything(sorry) , thanks for the patience , i will follow the tips and figure out the rest my self

php obi-wan kenobi i will solve that but how can is solve my ram problems , seriously is using more than 2gb of ram ...run line by line or something

<?php $db2 = new PDO('mysql:host=localhost; dbname=dbname1;', 'root', ''); $db2->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING); $sql = "INSERT INTO wp2_posts(post_content) VALUES (:parameter)"; $content = "#####$tags##### %%%%%$category%%%%% !!!!!$title!!!!!"; addslashes($content); foreach($db2->query('SELECT * FROM dbname2') as $row) { $href = $row['href']; $title = $row['title']; $thumb = $row['thumb']; $tags = $row['tags']; $category = $row['category']; $q = $db2->prepare($sql); $q->execute(array(':parameter'=>$content)); } ?> so final result should be this ?? .-. im confused, should i dump the variables at the end of the loop or im talking non sense ?

the code works with 10 lines but when i jump to a million it just go crazy on ram memory... any help? <?php $db2 = new PDO('mysql:host=localhost; dbname=dbname1;', 'root', ''); $db2->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING); foreach($db2->query('SELECT * FROM dbname2') as $row) { $href = $row['href']; $title = $row['title']; $thumb = $row['thumb']; $tags = $row['tags']; $category = $row['category']; $content = " file=$strfinal image=$thumb]\"; [/php] #####$tags##### %%%%%$category%%%%% !!!!!$title!!!!!"; addslashes($content); $sql = "INSERT INTO wp2_posts(post_content) VALUES (:parameter)"; $q = $db2->prepare($sql); $q->execute(array(':parameter'=>$content)); } ?>

thanks a freaking lot, but how do i modify what i am writing in database 2 in this way?

sorry by the extreme n00b question but i can insert and select from different databases in the same query???? mind blow

im modifying data in the process , i tried with out the limit 1 but database 1 got many many rows and i eventually run out of memory

finally got some time to code anyway i cant figure out why this doesnt work, i think its an error in my logic... <?php $db = new PDO('mysql:host=localhost; dbname=test;', 'root', ''); $db2 = new PDO('mysql:host=localhost; dbname=test2;', 'root', ''); foreach($db->query('SELECT * FROM database1 LIMIT 1') as $row) { $thing1 = $row['COL 1']; $thing2 = $row['COL 2']; $thing3 = $row['COL 4']; $thing4 = $row['COL 6']; $thing5 = $row['COL 7']; $content = "\"big text with $things\""; addslashes($content); $db2->exec("INSERT INTO database2(col1,col2,col3) VALUES ('$thing1','text','$content')"); } ?> my foreach command should read all lines from database one and write one by one on database two? thx in advance

just for the record , i solved by using dbforge and transforming the csv in a mysql table, way easier than what i was trying to do. thank you all guys

this is worst than the time i learned regex ,-, i was trying to do that, but the file have 2gb , not the easyest thing

its a part of my code , the echo is only for testing ...the code needs to read 1 line per run ,return the value as a string and at the next run read the next line.

if i take out the counter it will read one line only ? but on next run it will read same line?

i have to read a single line from a csv, its a really big file and i only need one column. i need the response to be a string ,i made a search and found the following code but i dont have any idea how to get a single line from a single string per run . <?php $row = 1; //open the file if (($handle = fopen("file.csv", "r")) !== FALSE) { while (($data = fgetcsv($handle, 0, ",")) !== FALSE) { $num = count($data); echo "<p> $num fields in line $row: <br /></p>\n"; $row++; for ($c=0; $c < $num; $c++) { echo $data[$c] . "<br />\n"; } } fclose($handle); } ?>

this is what i call a forum

really good ideas, my php is not good enough for none of them yet, i will have to learn several things to do this right. time to start reading

im not sure about how much time, and my script is not multi tasking..

it reads from sql database **

Here is the deal, its a simple script. 1-read a site link from a sql table**(sql1) 2-mark the sql1 line as read 3-goes to the site and capture several pieces of data(i used curl) 4-modify the read data 5-writes the data in another sql(sql2) So i did this with a few links, but i have to do this with 5~10 millions of links, what would be the better way to get performance and speed?

CURLOPT_FOLLOWLOCATION i think this is the command i needed anyway ,thanks for the help , how do i close the threat?

thats my semi-monkey IQ hehe , thanks u realy helped . what i was trying to do is check a page of search(not google) and enter on each link of the search. kinda like a spider but with a filter.

the problem was solved by redoing the spaces and replacing the $SERVER2 with $SERVER , but now it shows nothing as result...the first Curl is getting multiple urls, i think i might need a foreach or something no ? i will try to clean the first Curl result <?php $url = "http://www.site.com"; $curl = curl_init(); curl_setopt($curl, CURLOPT_USERAGENT, $_SERVER['HTTP_USER_AGENT']); curl_setopt ($curl, CURLOPT_URL, $url); curl_setopt($curl, CURLOPT_RETURNTRANSFER, 1); $curlresult = curl_exec ($curl); curl_close($curl); preg_match_all("/ href=\"(.*)\">(.*)<\/a><\/p>/", $curlresult, $theurls); $string = serialize($theurls); $curl = curl_init(); curl_setopt($curl, CURLOPT_USERAGENT, $_SERVER['HTTP_USER_AGENT']); curl_setopt ($curl, CURLOPT_URL, $string); curl_setopt($curl, CURLOPT_RETURNTRANSFER, 1); $curlresult2 = curl_exec ($curl); curl_close ($curl); print $curlresult2; ?>

notepad++ he hasnt there before hehehe but same error <?php $url = "http://www.site.com"; $curl = curl_init(); curl_setopt($curl, CURLOPT_USERAGENT, $_SERVER['HTTP_USER_AGENT']); curl_setopt ($curl, CURLOPT_URL, $url); curl_setopt($curl, CURLOPT_RETURNTRANSFER, 1); $curlresult = curl_exec ($curl); curl_close($curl); preg_match_all("/ imsmartasamonkey=\"(.*)\">(.*)<\/a><\/p>/", $curlresult, $theurls); $string = serialize($theurls); $curl = curl_init(); /*ERROR IS IN THIS LINE*/ curl_setopt($curl, CURLOPT_USERAGENT, $_SERVER2['HTTP_USER_AGENT']); curl_setopt ($curl, CURLOPT_URL, $string); curl_setopt($curl, CURLOPT_RETURNTRANSFER, 1); $curlresult2 = curl_exec ($curl); curl_close ($curl); print $curlresult2; ?>

<?php $url = "http://www.something.com"; $curl = curl_init(); curl_setopt($curl, CURLOPT_USERAGENT, $_SERVER['HTTP_USER_AGENT']); curl_setopt ($curl, CURLOPT_URL, $url); curl_setopt($curl, CURLOPT_RETURNTRANSFER, 1); $curlresult = curl_exec ($curl); curl_close($curl); preg_match_all("/ something=something/", $curlresult, $theurls); $string = serialize($theurls); $curl = curl_init(); curl_setopt($curl, CURLOPT_USERAGENT, $_SERVER2['HTTP_USER_AGENT']); curl_setopt ($curl, CURLOPT_URL, $string); curl_setopt($curl, CURLOPT_RETURNTRANSFER, 1); $curlresult2 = curl_exec ($curl); curl_close ($curl); print $curlresult2; ?> so im realy new to php and its probably a silly mistake .-. this is the answer i got from wamp syntax error, unexpected '$curl' (T_VARIABLE) anyway , can some one help me?