Array values written to SQL Server

Question

My code shown below will successfully return an array of values using print_r. How can I can get each value to be inserted into SQL Server "on its own row" in the same column? So far, I have only been able to get the first value in the array to be written to my table. The additional value(s) are not written. Thx, _ JT

$host = '209.49.180.234';
$hostname = gethostbyaddr( $host );
$rbl  = 'hostkarma.junkemailfilter.com';
$lookup = $hostname . '.' . $rbl;
$value = gethostbynamel($lookup);

    if ($lookup != $value){

       print_r($value);
    }

I am unclear where to insert the loop. Like this?:

$host = '209.49.180.234';
$hostname = gethostbyaddr( $host );
$rbl  = 'hostkarma.junkemailfilter.com';
$lookup = $hostname . '.' . $rbl;
$value = gethostbynamel($lookup);
   if ($lookup != $value)
    foreach($value as $val) {
         mssql_query("INSERT INTO $table5 (Whitelist_code) VALUES ('".$val."')");
     }

mssql_close($conn);

I got it to work. Thanks guys! _ JT

loop through the array with foreach()

user557846
– user557846

2011-06-27 22:11:09 +00:00
Commented Jun 27, 2011 at 22:11 — user557846
– user557846, Commented Jun 27, 2011 at 22:11

Sander · Accepted Answer · 2011-06-27 23:11:52Z

2

Try this

<?php
  foreach($value as $val) {
    mssql_query("INSERT INTO table (value) VALUES ('".$val."')");
  }
?>

answered Jun 27, 2011 at 23:11

Sander

1,4012 gold badges23 silver badges44 bronze badges

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

1 Comment

JT. Over a year ago

Thanks Sander but I am unclear where to insert the loop. Like this?:$host = '209.49.180.234'; $hostname = gethostbyaddr( $host ); $rbl = 'hostkarma.junkemailfilter.com'; $lookup = $hostname . '.' . $rbl; $value = gethostbynamel($lookup); if ($lookup != $value) foreach($value as $val) { mssql_query("INSERT INTO $table5 (Whitelist_code) VALUES ('".$val."')"); } mssql_close($conn);

cwhelms · Accepted Answer · 2011-06-27 23:20:39Z

1

use a foreach loop

foreach ($value as $a):
    //access your rows as $a
    //ex.- echo $a; put your sql stuff here instead
endforeach;

edited Jun 27, 2011 at 23:20

answered Jun 27, 2011 at 23:15

cwhelms

1,7813 gold badges12 silver badges14 bronze badges

Collectives™ on Stack Overflow

Array values written to SQL Server

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related