putting a string into a database table

[Anon]

Hi there, all you brilliant experts.

I have this problem.
In the code below, as You see, I wan't to put the string $keywords into my database. But it just wont!!!
Why???
The echo "$keywords" is just a control to see if all the querywords come out right in the string. And they do. But the don't go into my table.

If I remove the implode-line, the link and text go into the table as strings. But the keywords go into the table as an array.
I want keywords to go into the table as a string, to be searchable.
With the implode-line in the code as below, the string is made, the echo-line shows.
But nothing goes into my table.

Does anyone out there know what is wrong with my coding?

---

$key = explode(",", $querywords);
$keywords = implode(" ",$key);

echo "$keywords";

mysql_query("INSERT INTO links (link, keywords, text)
values('$link', '$keywords', '$text')");
echo "<SCRIPT>alert(\"Updated! \");window.location.href='http://localhost/qrts/functions/listlinks.php';</SCRIPT>";
exit;

---

Sincerely
Kurt

[[deleted]]

Rule #1 in coding: always use errorchecking.

replace this:

mysql_query("INSERT INTO links (link, keywords, text)
values('$link', '$keywords', '$text')");

with this:

$sQuery = "INSERT INTO links (link, keywords, text) values ('$link', '$keywords', '$text')";
if (!mysql_query($sQuery))
{
echo mysql_error().'<BR>'.$sQuery;
}
else
{
echo 'it worked';
}

---

A forum, a FAQ, what else do you need?

Time to YAPF!: http://www.hvt-automation.nl/yapf/

[Anon]

are links, keywords, text single entries, or are they arrays ???

Do you need to create a loop to insert these?

[Anon]

I kind of found out myself.

I didn't quite show you the code as I might have done.
But the problem encountered in the lines of querywords. When I entered the last line whsere I replace "'" with "", there was no problem anymore.

Yes, Vincent.
Rule #1 in coding: always use errorchecking.
You are right. And when I inserted your code, I found out what the problem was.
Thank you for the reminder ;-)

Working code below.

require("common_db.php");

if ($valg==add) {

$noise_words = file("noisewords.txt");
$filtered = $tekst;

$filtered = ereg_replace("^"," ",$filtered);

for ($i=0; $i < count ($noise_words); $i++){
$filterword = trim($noise_words[$i]);
$filtered =
eregi_replace(" $filterword "," ",$filtered);
}

$filtered = trim($filtered);
$filtered = addslashes($filtered);
$querywords = ereg_replace(",","",$filtered);
$querywords = ereg_replace(" ",",",$querywords);
$querywords = ereg_replace("\?","",$querywords);
$querywords = ereg_replace("(","",$querywords);
$querywords = ereg_replace(")","",$querywords);
$querywords = ereg_replace(".","",$querywords);
$querywords = ereg_replace(",","','",$querywords);
$querywords = ereg_replace("^{","'",$querywords);}
$querywords = ereg_replace("$","'",$querywords);
$querywords = ereg_replace("'","",$querywords);

$keywords = explode(",", $querywords);
$keywords = implode(" ", $keywords);

echo "$keywords";

$foresp = "INSERT INTO links (link, keywords, tekst) values ('$link', '$keywords', '$tekst')";
if (!mysql_query($foresp))
{
echo mysql_error().'<BR>'.$sQuery;
}
else
{
echo "<SCRIPT>alert(\"Data opdateret! \");window.location.href='http://localhost/qrts/funktioner/listlinks.php';</SCRIPT>";
exit;

}}

sincerely
Kurt