[RESOLVED] Using \ns to add to MySQL table...

lupus2k5

OK, here's my sample code:

<form action="result.php" method="POST">
<textarea name="input" class="form">Image 1 URL
Image 2 URL
Image 3 URL</textarea>
</form>

My goal is to set each "Image URL" as a different entry, e.g.
img_1 = "Image 1 URL";
img_2 = "Image 2 URL";
img_3 = "Image 3 URL";

I also want to be able to determine after the user submits the form how many lines they used so I can use that later.
I have no idea how to do this.

To make it clearer, my goal is to make a script that...
1. The user registers (MySQL registration/login script is done).
2. The user logs in to the authenticated page.
3. The user types the Image URLs (one on each line; maximum of 20 images).
4. The user clicks OK.
5. The script saves the image URLs (with an incrementing ID) to the database under their username.
6. The script creates (via fwrite) a small script that allows the user to add an iframe to their site that will generate a random image from their selection each time the page reloads.
7. The user can relogin and edit the existing image URLs and add/delete them.

I don't know much about MySQL, so help is very much appreciated.

sneakyimp

result.php might look something like this:

$urls = str_replace("\r\n", "\n", $_POST['input']);
$urls_array = explode("\n", $urls);
$clean_urls = array();
foreach($urls_array as $a_url) {
  $tmp = trim($a_url);
  // you might want to do some more cleanup here
  if (!empty($a_url)) {
    $clean_urls[] = $tmp;
  }
} // foreach url
echo sizeof($clean_urls) . ' were found.<br>';
echo 'they are:<br>';
echo implode("<br>\n", $clean_urls);

mjax

sneakyimp was faster!

sneakyimp

haha! perhaps you can help me with my post, mjax!

lupus2k5

sneakyimp wrote:

result.php might look something like this:

$urls = str_replace("\r\n", "\n", $_POST['input']);
$urls_array = explode("\n", $urls);
$clean_urls = array();
foreach($urls_array as $a_url) {
  $tmp = trim($a_url);
  // you might want to do some more cleanup here
  if (!empty($a_url)) {
    $clean_urls[] = $tmp;
  }
} // foreach url
echo sizeof($clean_urls) . ' were found.<br>';
echo 'they are:<br>';
echo implode("<br>\n", $clean_urls);

So, I'm assuming this returns:
$clean_urls[1] = "Image 1 URL";
$clean_urls[2] = "Image 2 URL";
$clean_urls[3] = "Image 3 URL";
so I can just
count($clean_urls);
?

lupus2k5

Oh, wait. I can use implode() to display each URL, but how do I put these URLs into a database as separate entries?

sneakyimp

yes $clean_urls is an array where each element should be a single url.

you can read about implode and explode at php.net:
http://php.net/implode
http://php.net/explode

you can loop through clean_urls to create queries like this:

foreach($clearn_urls as $url) {
  // you should probably do some checks on the urls here
  $sql = 'INSERT INTO url_table SET url="' . mysql_escape_string($url) . '"';
  mysql_query($sql)
    or die ('the url insert query failed');
}

lupus2k5

Well, I am assuming I would want

$sql = 'INSERT INTO url_table SET url'.count($clean_urls).'="'.mysql_escape_string($url).'"';

(By the way, thanks. I've never seen the explode() function before, and I find it very convenient.)

lupus2k5

OK, I think I got it. Here's my script:

function images($images)
{
 connectdb();
 $urls = str_replace("\r\n","\n",$images);
 $urls_array = explode("\n",$urls);
 $clean_urls = array();
 $numurls = count($clean_urls);
 $i = 0;
 foreach($urls_array as $a_url)
 {
  if($i < $numurls + 1)
  {
   $tmp = trim($a_url);
   $sql = 'UPDATE url_table SET url'.$i.'='.mysql_escape_string($a_url).'"';
   mysql_query($sql)or die("<span class='form'><b>Error:</b> Query Error.<hr>".mysql_error());
  }
  $i++;
  if(!empty($a_url))
  {
    $clean_urls[] = $tmp;
  }
 }
 //$output = implode("<br>\n",$clean_urls);
 //$numimg = count($clean_urls);
 //echo "<b>Test:</b> The following URLs are returned:<br>\n";
 //echo $output;
}

I'll just set the table to have 100 fields (url1, url2, url3, url4, url5, url6...) and leave it at that.