bulk uploading

davidaus

Hi
Im new here, this is my first post. :p

Recently im building a domain portfolio where it allow user to manage their domain names in an easy to use web panel. Everything goes smoothly until i had to develop a bulk uploading system. Does anyone has any idea on how to develop it?

The sys should goes like this:
Let's assume that there is a textarea where user may type in as many url as they like seperated by enter. Which means one domain per line. Then there should has a processing script where it will enter that list one by one into mysql database..

My thinking is to explode the list into an array and then insert one by one into the DB but i face difficulties. Can anyone help me to figure out?

Thanks

kburger

Sounds like you're on the right track. What have you tried? Let's see the code.

davidaus

I have not try to insert it into mysql database because im not sure that it will work

This is the processing script that im thinking of

<?php
///exploding list of domain from textarea
$DNlist = explode(' ', $_POST['DNlist']);
$values = 'VALUES ("$DNlist")';
$insert = 'mysql_query("INSERT INTO portfolio(list) " .$values);
?>

But the problem here is that there should be a counter where it counts how many time the looping should be done. I try to figure out on how to determine how many domain list are there in the textarea that are seperated by '\n' and I cant found the answer.

bretticus

Perhaps this will point you in the right direction...

//replace semicolon, comma & linebreak with space.
$patterns = array("/\n/","/,/","/;/");
$domains = preg_replace($patterns, " ", $_POST['txtDomains']);
$sql = "INSERT INTO `portfolio` (`list`) VALUES ('";
$sql .= implode("'),('", explode(" ", $domains));
$sql .= "')";

Code is untested. If you need me to explain it, just let me know.

davidaus

Hi
Im abit confuse with it. would you mind explaining it. You seems to convert the list of domain into array and then convert again to string using implode function before inserting into mysql. Will php understand that there are a list of domain which it should insert one by one?
Thanks

Weedpacket

Using echo $sql after that to see the string being constructed may help. The first two lines do what the comment says, then the implode/explode business replaces spaces (beween the domains) with '),('so that

domain1 domain2 domain3 domain4

becomes

domain1'),('domain2'),('domain3'),('domain4

which, together with the (' and ') on the adjacent lines, makes for a list of records to insert.

I haven't tested it either - I don't use MySQL so I don't recall if it recognises the syntax - so testing would have to be done by someone who's in a position to try it and see if it works.

I do see one fault with it though in that it might accidentally insert empty domains due to two consecutive spaces appearing in the string. I'd replace the $patterns array with the string

/[ \n,;]+/

so that you could happily have

domain1; domain2;
domain3;domain4

and it will be replaced by

domain1 domain2 domain3 domain4

. And then instead of explode/implode, just

str_replace(' ', "'),('", $domains)

to turn each (single) space into that '),(' glue.

bretticus

Ah, thanks Weedpacket. That's what I get for coding off the hip ;-)

Weedpacket

Oh, I only got it because you did the work. I'm sure you would have realised the same when you came back to check how things are going 😉

davidaus

Great great... 🙂 thanks
I will try to apply it