[RESOLVED] simple php html dom

[0o0o0]

heres my results I get from my php grab code..

Array ( [0] => Array ( [image] => www.example.com/48_14.JPG [title] => Ferrari title Example [details] => Look at this car its beautiful, example example [price] =>   $270,000.00 [timestamp] => june12[link] => http://example.com/ferrari.html ) 

how does this work putting this into a mysql database??

just a quick link to something telling me how to handle this, ive only ever used csv or raw text comma delimted to insert into a mysql db.

any advice or tips would be greatly apprieciated thankyou.

[jeepin81]

Look into json_decode and then loop through your array to input into your DB as desired.

[NogDog]

jeepin81;11006220 wrote:

Look into json_decode and then loop through your array to input into your DB as desired.

I don't see any JSON there, just a PHP print_r() of an array, I believe.

[NogDog]

As far as the original question, I'm not sure exactly what you need. The array presumably has the data you want, so all you need to do is build your SQL query string, inserting the desired array elements as needed (after escaping them properly for whatever database extension you are using).

[0o0o0]

oh so mysql can handle this!

no not json, I always thought csv, raw text, sql file was the only way you can fill a database. Yep im expanding my horizons!

so something like this will work?? noooo.. ya?? nooo.. lemme know thanks.

mysql_select_db('BCR', $connection); 

// inserting data into table 
$success = mysql_query("INSERT INTO `cycle` (`image`, `title`, `details`, `price`, `timestamp`,`link`) VALUES ('".mysql_real_escape_string($data[0])."', '".mysql_real_escape_string($data[2])."', '".mysql_real_escape_string($data[3])."', '".mysql_real_escape_string($data[4])."', '".mysql_real_escape_string($data[10])."')"); 

// check if insert was successful 
if($success) { 
echo 'data inserted'; 
} else { 
echo 'Something went wrong: ' . mysql_error(); 
} 

// closing database 
mysql_close($connection); 
?> 

[NogDog]

Looks like you're on the right track.

[0o0o0]

can you explian one thing cause i kinda did grab parts and peices from tutorials..

'".mysql_real_escape_string($data[10])."'

it says 10.. why 10?? is that 10th item in array.. for my case would just be data[5]
the data 6 for the next right?

[NogDog]

It looks as if you have a 2-dimensional array, so if that array is named $data, you would access the title as $data[0]['title']. What is not known to me for sure at this time if there could ever be more first dimensions in that array (not just 0, but 1, 2, 3,...), in which case you may want to use a foreach() to iterate through each sub-array:

foreach($data as $record) {
   echo "<p>This title is <b>".$record['title']."</b></p>\n";
}

(Instead of echoing, you'd actually do a DB insert for reach record.)

[jeepin81]

the OP said he already works w/ CSV and txt and he showed an array w/ the keys wrapped in [] brackets... so, I thought it looked like JSON to me.

per your last post... yes 10 can be the 10th element of the array or the first i suppose.

Can you post more code?

[0o0o0]

yeah sorry i should have done this from the very start.

<?php

include('simple_html_dom.php');

// Create DOM from URL or file
$html = file_get_html('http://oneofmysites.com/stuffineedthisisjustafakeforpostinghere.html');
foreach($html->find('table.resultsTable') as $article) {
    $item['image']     = $article->find('img[class=thumbnail]',0)->src;
    $item['title']    = $article->find('strong',0)->plaintext;
    $item['details'] = $article->find('div[style=margin-top:5px]',0)->plaintext;
    $item['price'] = $article->find('td[id=price]',0)->plaintext;
    $item['timestamp'] = $article->find('td[width=13%]',0)->plaintext;
    $item['link'] = $article->find('a',0)->href;
    $articles[] = $item;
}
//just to check below
//print_r($articles); 

//the login include file is infact correct
include("./ws3js/loginstuffexample.php");                              

 $connection = mysql_connect($host,$user,$password)   

      or die ("Sorry the server is currently updating,  Check back in a few minutes");
 $db = mysql_select_db($database,$connection)         

      or die ("Couldn't select database");

//below I really dont know what "mysql_real_escape_string" actually means lol ( tutorial)

$success = mysql_query("INSERT INTO `db123` (`image`, `title`, `details`, `price`, `timestamp`,`link`) VALUES ('".mysql_real_escape_string($data[0])."', '".mysql_real_escape_string($data[2])."', '".mysql_real_escape_string($data[3])."', '".mysql_real_escape_string($data[4])."',  '".mysql_real_escape_string($data[5])."',  '".mysql_real_escape_string($data[6])."')"); 


if($success) { 
echo 'data inserted'; 
} else { 
echo 'Something went wrong: ' . mysql_error(); 
} 

mysql_close($connection);

?> 

the above currently connects, and only adds a row of blank.. if I run this again, another row of blank. But the results are in fact 20 rows.. so i know im doin the mysql insert line wrong somehow.

[0o0o0]

i know its obviously not $data tried $items.. no go.. could it be $articles, just a lil afraid to go ahead and try it.. if it none stop fills each row/celll with all of it over and over.. and my hosting co freaks out on me. lol..

yes true newb at this simple html dom stuff.

[NogDog]

The foreach loop is dumping all the data into an array of arrays called $articles. So that is where you would access the data later. So after that, you could simply(?) create a second foreach loop:

foreach($articles as $item) {
    $sql = "INSERT blah blah blah '" . mysql_real_escape_string($item['title'] . "' blah blah blah";
    mysql_query($sql);
}

[0o0o0]

omg. I got it. Thanks!!!

[0o0o0]

is it possible to make this run the "link" array and get more info from each page/link.. in the same swoop??