Entering Array's into table PHP

Question

im pulling in data from an rss feed, i want to add the title and description into the same row (different fields) in a mysql database

$result = $xml->xpath('//title');  //finding the title tags in the xml document and loading into variable
$result1 = $xml->xpath('//description');  //finding the title tags in the xml document and loading into variable

I'm loading the information into variables but don't understand how i can insert this into a mysql table called data?

It sounds easy but im struggling as its an array.

What is the structure of the RSS file you are reading in? Are you using SimpleXML? — user1191247
– user1191247, Commented Apr 14, 2012 at 2:04

Dr.Kameleon · Accepted Answer · 2012-04-14 01:40:53Z

2

Try something along these lines : (UPDATED)

<?php
    $con = mysql_connect("localhost","yourdbusername","yourdbpassword");
    if (!$con)
    {
        die('Could not connect: ' . mysql_error());
    }

    mysql_select_db("yourdbname", $con);

    $query = sprintf("INSERT INTO `data` (`title`, `description`) VALUES ('%s','%s');",
                         mysql_real_escape_string($result),
                         mysql_real_escape_string($result1));

    mysql_query($query);

    mysql_close($con);
?>

answered Apr 14, 2012 at 1:40

Dr.Kameleon

22.8k21 gold badges124 silver badges241 bronze badges

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

2 Comments

Dr.Kameleon Over a year ago

@Amadan I updated my post, although you REALLY got me wondering as to WHY the answer was downvoted; honestly, all I was trying was not to confuse the OP even more (as he simply IS quite confused on the matter, already...)

Amadan Over a year ago

Because with PHP as insecure as it is, noone should be touching SQL without the clear understanding of the Bobby Tables thing. Teaching someone how to do MySQL and not even mentioning SQL injection is a Bad Thing (tm).

user1191247 · Accepted Answer · 2012-04-14 02:15:06Z

1

You will need to change the node names but this should do it -

<?php
$db = new PDO('mysql:dbname=test;host=127.0.0.1', 'user', 'pass');

$sql = "INSERT INTO tbl (title, description) VALUES (?, ?)";
$stmt = $db->prepare($sql);

$rss = simplexml_load_file('path_to_rss_feed');

foreach ($rss->articles as $article) {
    $stmt->execute(array($article->title, $article->description));
}

answered Apr 14, 2012 at 2:15

user1191247

13k2 gold badges25 silver badges33 bronze badges

Comments

Trey · Accepted Answer · 2012-04-14 01:44:36Z

0

Assuming your table is set up with columns that are named "title" and "description" have you tried something like this?

$rows=array();

foreach($result as $title){
  $rows[]="('".mysql_real_escape_string($title)."','".mysql_real_escape_string(array_shift($result1))."')");
}
mysql_query("INSERT INTO data (title, description) VALUES ".implode(',',$rows);

EDIT: fair enough;) added mysql_real_escape_string

answered Apr 14, 2012 at 1:44

Trey

5,5404 gold badges25 silver badges31 bronze badges

Collectives™ on Stack Overflow

Entering Array's into table PHP

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related