Sort &amp; Strip Character help

Sort & Strip Character help

johnp813

I Have a Form that submits info for Mysql database. The domain feild is a text box that they can put several domains in one per line and this is my code to process this form and save to database table. Which Works ....

<?php
require('config.php');
$urlsplit = preg_split("/\r/", $domain);
$a = count($urlsplit);
sort($urlsplit);
$sql = "SELECT domain FROM usersdomains";
$res = mysql_query($sql);
$i = 0;
while ($a > $i) {
$sqlquery = "INSERT INTO usersdomains (sellerid, domain, category, takeoffers, price, website) VALUES ('$sellerid', '$urlsplit[$i]', '$category', '$takeoffers', '$price', '$website') ";
$result = mysql_query($sqlquery);
$i++;
}
if ($result) {
print "$a Domains Have been Successfully Added ";
print "<a href='javascript:history.go(-1)'>Add Another Domain</a> ";
} else {
print "Domains NOT Added. Please Report This Error ";
echo mysql_error();
}
?>

My Problems and what I am needing help with is... If someone puts a list of domains in the domain text feild and there curser ends up at the bottom on a blank line it puts in a blank record in the table. (Very easy to do)

QUESTION #1. Can I check for a blank and take it out ?? if Yes could someone help with Code Please..

QUESTION #2. I would also like to check my table to insure no duplicate domains are being entered.. I Have played with this and had NO Luck.. I know how to do it for a single field entry, but I am having problem with checking table after the domains from the text feild are seperated..

Any help would be Greatly Appreciated...

laserlight

"Can I check for a blank and take it out ?? if Yes could someone help with Code Please.."

Well, yes
$urlsplit = preg_split("/\r+/", $domain);

"I would also like to check my table to insure no duplicate domains are being entered.."
this might be a little inefficient:
loop through your array and attempt to select using the array element.
if a match is found, remove that array element, say using unset()

johnp813

laserlight thank you for your reply but you lost me...

"Can I check for a blank and take it out ?? if Yes could someone help with Code Please.."

You Said:

Well, yes
$urlsplit = preg_split("/\r+/", $domain);

Correct me if wrong, but isnt this what I have ??? Would you mind showing me a code example.

You also said to check for duplicates ...
loop through your array and attempt to select using the array element.
if a match is found, remove that array element, say using unset()

I'm sorry, but I am pretty new at this and I dont understand what you mean.. Would you please show a code example.

Thank You very much for your help.

laserlight

"but isnt this what I have"
no it isnt. Without the + modifier, it is the same as explode()
With it, the string is split at every point where there is 1 or more carriage returns.

"loop through your array and attempt to select using the array element"
Looking at your code snippet, I think you should define the domains table to have the domains only.
You are inserting duplicate data for each set of domains.

foreach ($urlsplit as $key => $value) {
	$query = mysql_query("SELECT domain FROM usersdomains WHERE domain='$value'");
	if (mysql_num_rows($query) > 0)
		unset($urlsplit[$key]);
}

johnp813

Thank you Very Much laserlight for your replies and help..

I seem to be a little closer....

adding the + in this line seems to do nothing:
$urlsplit = preg_split("/\r+/", $domain);

VERSES

$urlsplit = preg_split("/\r/", $domain);

However; The other code you provided does basically work for checking for duplicates so the most I can have is one blank record in the table as it is then seen as a duplicate, etc..

As of now if the domains are entered (typed) into the form feild it all seems to work fine, however if they are copied and pasted from a text file they do not catch the blank records or sometimes even duplicate entries..

Is there perhaps another format that may work better or atleast worth a try ??

Current code now is:

<?php
require('config.php');
$urlsplit = preg_split("/\r/", $domain);
foreach ($urlsplit as $key => $value) {
$query = mysql_query("SELECT domain FROM usersdomains WHERE domain='$value'");
if (mysql_num_rows($query) > 0)
unset($urlsplit[$key]);
}
$a = count($urlsplit);
sort($urlsplit);
$sql = "SELECT domain FROM usersdomains";
$res = mysql_query($sql);
$i = 0;
while ($a > $i) {
$sqlquery = "INSERT INTO usersdomains (sellerid, domain, category, takeoffers, price, website) VALUES ('$sellerid', '$urlsplit[$i]', '$category', '$takeoffers', '$price', '$website') ";
$result = mysql_query($sqlquery);
$i++;
}
if ($result) {
print "$a Domains Have been Successfully Added ";
print "<a href='javascript:history.go(-1)'>Add More Domains</a> ";
} else {
print "Domains NOT Added. Please Report This Error ";
echo mysql_error();
}
?>

Would perhaps having a error when duplicates or blank rows that forces the user to go back and fix be better and a more sure way ??

Any additional help would really be appreciated...

laserlight

just wondering, but what is the platform you are running on?

If your new line sequence is supposed to be the newline character (\n), then '/\r+/' isnt what you want.
If it is windoze and so should be \r\n, then '/\r+/' also isnt what you want.

johnp813

laserlight

I am on Unix Platform

laserlight

then you should use \n

i.e.

$urlsplit = preg_split("/\n+/", $domain);

johnp813

Just tried it using
$urlsplit = preg_split("/\n+/", $domain);

I put in 12 domains (including blank rows, duplicates and unique domains)

The results count said 12 domains added.

It addedd all with blanks and duplicates

johnp813

Ok I am stupid..

I still get my one blank record, but that I can live with.. otherwise it seems to be ok EXCEPT if a blank is put at the bottom of the form field. Then it puts in the blank ??

Thank you very much for your help

laserlight

hmm... yes, I didnt anticipate that.

You would have to trim() the string first, in that case.

johnp813

I am sorry, but i dont know what you mean by:
You would have to trim() the string first, in that case.

Would you mind explaining or giving me a code sample..

I really do appreciate your help.. You have been Great. Thank you so much...

laserlight

I suggest that you read the PHP Manual on [man]trim/man

johnp813

I actually have been reading the pghp manual on trim() and have tried every example they give multiple ways and so far no good.. But i am still working on it.