$ct is my array: array(4) { ["a"]=> int(1) ["b"]=> int(2) ["z"]=> int(2) ["c"]=> int(1) }

I need to put it in a two column database where "item" is col1 and "count" is col2 where the first row has an "a" in col1 and 1 in col2, 2nd row has a "b" in col1 and 2 in col2, etc.

What do I put after VALUES ($result = mysql_query("INSERT INTO test2(item,ct) VALUES ???) or die(mysql_error())

or do I need to use another approach?

Recommended Answers

All 2 Replies

<?php
$ct = array (
             "a" => 1,
             "b" => 2,
             "z" => 2,
             "c" => 1
            );

$con = mysql_connect('localhost','david','mypwd');
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("daniweb", $con);

foreach($ct as $item => $count){
    $sql = "INSERT INTO test2(item,ct) VALUES ('$item', $count)";
    if ($result = mysql_query($sql)) {
        echo "One row inserted for $item\n";
    }
    else {
        echo "Failed to insert $item\n";
    }
}

mysql_close($con);
?>

Thanks to d5e5. I was slowly coming to a similar answer. You helped me solve the question much faster.

Niche

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.