input multiple records into mysql db

Question

i'm writing a script to throttle some of the domains i send my newsletter to. I've had issues with getting emails blocked in the past.

All I'm doing is storing the throttling information into the database so my mail script will know which rate to send. Sometimes I'll have lists of 100 or so different destination domains i want to throttle, so to be able to load them all into one box and set the rate will be very convenient for me.

everything works, even the query, but I'm completely lost on getting each line inside the db as it's own record.

here is my html which works fine:

<form method="post" action="throttle_engine.php">
<textarea name="bulk" rows="7" cols="20"></textarea>
<input type="text" name="interval" value="">
<input type="submit" name="submit">
</form>

php on submission page to pass variables:

$bulk = nl2br($_POST['bulk']);
$interval = $_POST['interval'];

processing page 'throttle_engine.php':

foreach($bulk as $key=>$value){
    $query = "INSERT INTO `node".$node_id."` (domain, speed) VALUES ('$bulk', '$interval') ON   DUPLICATE KEY UPDATE `speed` = '$interval'";
    $result = mysql_query($query) or die(mysql_error());
    }

i know the query itself is working just fine, but very confused on how to add the records one line at a time in a loop. any ideas, tips, hints, or tricks are very welcome!

Tyler Carter · Accepted Answer · 2011-04-16 01:49:26Z

1

You need to break up bulk by newlines (or <br> since you've converted them)

$bulk = explode("<br>", $bulk);
foreach($bulk as $domain){
    //stuff ...
}

By making an array of domains, you can add multiple records into the database, based on each domain you've entered (assuming they are separated by a newline)

answered Apr 16, 2011 at 1:49

Tyler Carter

61.7k22 gold badges133 silver badges153 bronze badges

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

1 Comment

john Over a year ago

got it working thanks! gonna save that little snippet for sure.

Collectives™ on Stack Overflow

input multiple records into mysql db

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related