Php insert from Array to database

Question

I am inserting scraped link to my database but when i check in database the number of auto increment records is correct but cado field remains blank. When i insert a default value "test" @ $results_urls[$separate_result] the records is filled. what mistake have i done

$separate_results = explode("<td class=\"image\">", $results_page);   // Expploding the results into separate parts into an array

// For each separate result, scrape the URL
foreach ($separate_results as $separate_result) {
    if ($separate_result != "") {
        $results_urls[] = "http://www.imdb.com" . scrape_between($separate_result, "href=\"", "\" title="); // Scraping the page ID number and appending to the IMDb URL - Adding this URL to our URL array
        $add = "INSERT INTO pourqui(
                   cado
               ) VALUES (
                  '$results_urls[$separate_result]'
               )";

        $result_add = mysql_query($add);
        if (!$result_add) {
            die("Database query failed: " . mysql_error()); 
        }
    }

Please read the first question and answer in the related column to the right before you continue. — Marty
– Marty, Commented Jun 20, 2013 at 7:11

Yogesh Suthar · Accepted Answer · 2013-06-20 07:11:24Z

1

use {} for inserting data from array

$add = "INSERT INTO pourqui(cado) VALUES ('{$results_urls[$separate_result]}')";
                                           ^                               ^

answered Jun 20, 2013 at 7:11

Yogesh Suthar

30.5k18 gold badges75 silver badges100 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Dimitri Over a year ago

following your answer : $add = "INSERT INTO table_name(table_column) VALUES ('{$results_urls[$separate_result]}')"; but dbase still empty

Yogesh Suthar Over a year ago

@Dimitri Because you are assigning the value to 0th element and accessing it using associative array. Assign it in this way $results_urls[$separate_result] = "http://www.imdb.co.....

Collectives™ on Stack Overflow

Php insert from Array to database

1 Answer 1

2 Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Related