Re: Inserting PHP5 and HTML code into MySQL
- From: "Du" <vietquest@xxxxxxxxxxx>
- Date: Sun, 30 Oct 2005 19:18:57 -0500
you need to run addslashes before inserting your code into the database
(this will escape all the quote and control character in your code), and you
need run stripslashes after you retrieve the data from the database
http://ca.php.net/manual/en/function.addslashes.php
http://ca.php.net/manual/en/function.stripslashes.php
"Skylinux" <spam@xxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:_M69f.2152$2y.335@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> I'm trying to use my database to store a lot of the redundant PHP and
> HTML code.
> Is there a special function I can use to insert the code into SQL, when
> I try it using the input of a <textarea> the insert fails.
>
> Here is a sample of what I would like to insert into a MySQL database.
> ######### code sample start
> <tbody>
> <tr>
> <td style="vertical-align: top;">
> <table style="width: 100%; text-align: left;" border="0"
> cellpadding="2" cellspacing="2">
> <tbody>
> <tr>
> <td style="vertical-align: top;">
> <?PHP
> //Modified to include options and different templates
> $Sec_run = $_POST['Sec_run'];
> $inc_dir = '/path/to/inc/';
> include $inc_dir.'menu-projects.inc'; //Include Menu
> ###### code sample end
>
>
> And here is an example of how I'm currently adding the <textarea> text
> into the database. It can insert plain text but no code.
>
> ########## PHP code insert example
> $db="nameofdb";
> //make mysql connection
> $conn = @mysql_connect("localhost","$db_un_admin","$db_admin") or
> die("Could not connect to MySQL server");
> //select specified database
> $rs = @mysql_select_db("$db", $conn) or die("Could not select database");
>
> $sql = "insert into $Cat_name(Cat_ID , Title , Article , User_ID ,
> Visible) values(\"$Cat_ID\", \"$Title\", \"$Article\", \"$User_ID\",
> \"$Visible\") ";
> //echo("<br>SQL: " . $sql . "<br><br"); //Debug
> $result = mysql_query( $sql,$conn) or die("Could not insert into table
> $Cat_name"); //Run query;
> ###########3 PHP code end
>
> Any ideas on how to get this done are very appreciated.
>
> Skylinux
>
----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups
----= East and West-Coast Server Farms - Total Privacy via Encryption =----
.
- References:
- Inserting PHP5 and HTML code into MySQL
- From: Skylinux
- Inserting PHP5 and HTML code into MySQL
- Prev by Date: Re: Trouble with sending multipart Email
- Next by Date: meta characters filtering
- Previous by thread: Inserting PHP5 and HTML code into MySQL
- Next by thread: phpBB sites hacked.
- Index(es):
Relevant Pages
|
