MySQL

Insert HMTL Code into MySQL Database through a Form with PHP

Please support our MySQL advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

Thread Solved

•

Join Date: May 2009

Posts: 7

Reputation: MArun25039 is an unknown quantity at this point

Solved Threads: 0

MArun25039 MArun25039 is offline

Offline

Newbie Poster

Insert HMTL Code into MySQL Database through a Form with PHP

May 19th, 2009

Hello,

I'm having an issue with a MySQL/PHP site I'm working on. I'm new to both. I've seen several posts that were similar or same but was unable to derive a solution based on my code.

I have a form that will submit HTML code to a database. I know the form/php/database works since I've test it with non-code text and it works fine.

An example of the HTML code I'd like to submit is as follows; it will be for a link within an image (the image located on the web).

 Help with Code Tags 
 MySQL Syntax (Toggle Plain Text) 
<a target='new' href='http://www.destination.com><IMG alt='ALT TAG' border='0' src='http://www.imagelocation.com></a><IMG border='0' width='1' height='1' src='http://www.image sourece.com>
 
<a target='new' href='http://www.destination.com><IMG alt='ALT TAG' border='0' src='http://www.imagelocation.com></a><IMG border='0' width='1' height='1' src='http://www.image sourece.com>

The Error reads as follows:

 Help with Code Tags 
 MySQL Syntax (Toggle Plain Text) 
ERROR: You have an error IN your SQL syntax; CHECK the manual that corresponds to your MySQL server version for the RIGHT syntax to USE near 'new' href='http://www.destination.com>ALT TAG
 
ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'new' href='http://www.destination.com>ALT TAG

Below is the code for the 'add' which contains the form and 'added' which sends to the database.

add.php

 Help with Code Tags 
 MySQL Syntax (Toggle Plain Text) 
<form method="post" action="added.php">
<b>Please enter the catalog item information:</b><br>
 
<table>
<tr>
	<td>
		<label for="link"><b>Link:</b></label>
	</td>
	<td>
		<input id="link" name="link"  size="100" />
	</td>
</tr>
</table>
 
<input type="submit" name="submit" value="Add" />
</form>
<form method="post" action="added.php">
<b>Please enter the catalog item information:</b><br>

<table>
<tr>
	<td>
		<label for="link"><b>Link:</b></label>
	</td>
	<td>
		<input id="link" name="link"  size="100" />
	</td>
</tr>
</table>

<input type="submit" name="submit" value="Add" />
</form>

added.php

 Help with Code Tags 
 MySQL Syntax (Toggle Plain Text) 
<?php
 
include("connect.php");
 
mysql_select_db("dbase", $con);
 
	$sql="INSERT INTO catalog (link)
	VALUES('$_POST[link]')";
 
	if (!mysql_query($sql,$con))
	{
	die('ERROR: '. mysql_error());
	}
 
 if(isset($_POST['submit']))
 {
 
	echo "<h1>Success!</h1><br>Catalog item has been entered into database.<br><br>";
 
 }
 ELSE
 {
  header("Location: add.php", 301);
 }  
 
 mysql_close($con)
 
 ?>
<?php

include("connect.php");
	
mysql_select_db("dbase", $con);
	
	$sql="INSERT INTO catalog (link)
	VALUES('$_POST[link]')";

	if (!mysql_query($sql,$con))
	{
	die('ERROR: '. mysql_error());
	}

 if(isset($_POST['submit']))
 {
 	
	echo "<h1>Success!</h1><br>Catalog item has been entered into database.<br><br>";
 	
 }
 else
 {
  header("Location: add.php", 301);
 }  
 
 mysql_close($con)
 
 ?>

•

Join Date: Nov 2007

Posts: 3,750

Reputation: nav33n is a jewel in the rough

Solved Threads: 331

nav33n

Offline

Senior Poster

Re: Insert HMTL Code into MySQL Database through a Form with PHP

May 22nd, 2009

You should escape ' before adding it to the database.
Use,

 Help with Code Tags 
 php Syntax (Toggle Plain Text) 
       $link = mysql_real_escape_string($_POST['link']);
	$sql="INSERT INTO catalog (link)
	VALUES ('$link')";
       $link = mysql_real_escape_string($_POST['link']);
	$sql="INSERT INTO catalog (link)
	VALUES ('$link')";

You got that error because, the opening ' in your query is terminated when it encounters

•

<a target='

Ignorance is definitely not bliss!

*PM asking for help will be ignored*

•

Join Date: Jun 2009

Posts: 44

Reputation: guru12 is an unknown quantity at this point

Solved Threads: 6

guru12

Offline

Light Poster

Re: Insert HMTL Code into MySQL Database through a Form with PHP

-1

Jul 15th, 2009

Dear friend

Use the insert code like this

 Help with Code Tags 
 sql Syntax (Toggle Plain Text) 
INSERT INTO `tablename` (`id`, `name`) VALUES
(30, '<a href=ww.yahoo.com>Yahoo</a>');
INSERT INTO `tablename` (`id`, `name`) VALUES
(30, '<a href=ww.yahoo.com>Yahoo</a>');

THanks and Regards

Last edited by peter_budo; Jul 15th, 2009 at 7:33 am. Reason: Keep It Organized - For easy readability, always wrap programming code within posts in [code] (code blocks) and [icode] (inline code) tags.

Joomla Web Design
Joomla Web Development