sites in the DB itself
and use PHP to call for the HTML file - which would be populated with
Content from another table in MySQL. I was told I could put HTML into
MySQL... so my main question would be: is this possible?, is this a BAD
thing? but most of all... would this be resource
was told I could put HTML into
MySQL... so my main question would be: is this possible?, is this a
BAD
thing? but most of all... would this be resource intensive?
Thanks for any answers! I hope I'm using this list correctly - I did
search
Google and I've been reading
clint lenard wrote:
can anyone help me with this question? (about using Smarty)
No doubt -- but that anyone would likely be on a Smarty-specific
(or at least PHP-oriented) mailing list, eh? :-)
--
Hassan Schroeder - [EMAIL PROTECTED]
Webtuitive Design === (+1)
Hello!
But once you have done that, you can never recover the origional text.
Try it on this email if you doubt it.
Why? Why not to use regular expressions?
Use addslashes($htmlCode) and execute query normally.
$slashedHtmlCode = addslashes($htmlCode);
The problem is not in the executing
Vladimir B. Tsarkov wrote:
After the execution of the script:
?php
$string = \n\n\n\n 1;
echo addslashes($string);
?
we will get:
1
and no empty lines.
If you want to output the same data, that was written using a textarea field
of a form, you should use the br tag.
In one word: kiss.
@lists.mysql.com
Cc: mysql@lists.mysql.com
Subject: Re: HTML in MySQL?
Hello!
But once you have done that, you can never recover the origional text.
Try it on this email if you doubt it.
Why? Why not to use regular expressions?
Use addslashes($htmlCode) and execute query normally
John Trammell wrote:
$input = This is br the \n input;# value from user
$saved = This is br the br input; # value in database
$recovered = This is \n the \n input; # retrieved from db, != $input
Please don't top-post. That is the perfect argument for not applying
nl2br() before saving
Jasper Bryant-Greene wrote:
John Trammell wrote:
$input = This is br the \n input;# value from user
$saved = This is br the br input; # value in database
$recovered = This is \n the \n input; # retrieved from db, != $input
Please don't top-post. That is the perfect argument for not
Wow, thanks for all of the Information guys! I've learned alot and now I've
actually been doing more brain storming... I've been reading all of these
emails over and over - and they're helping me understand more!
What I'm trying to do is save User Sites in MySQL and use PHP to pull them
out
table in MySQL. I was told I could put HTML into
MySQL... so my main question would be: is this possible?, is this a BAD
thing? but most of all... would this be resource intensive?
Thanks for any answers! I hope I'm using this list correctly - I did search
Google and I've been reading an MySQL
that would hold HTML sites in the DB itself
and use PHP to call for the HTML file - which would be populated with
Content from another table in MySQL. I was told I could put HTML into
MySQL... so my main question would be: is this possible?, is this a BAD
thing? but most of all... would
I could put HTML into
MySQL... so my main question would be: is this possible?, is this a BAD
thing? but most of all... would this be resource intensive?
Thanks for any answers! I hope I'm using this list correctly - I did search
Google and I've been reading an MySQL Manual for over a week now
table in MySQL. I was told I could put HTML into
MySQL... so my main question would be: is this possible?, is this a BAD
thing? but most of all... would this be resource intensive?
Of course -- HTML is just a string like any other. Just use a TEXT field
of the appropriate size for the size of your
for the HTML file - which would be populated with
Content from another table in MySQL. I was told I could put HTML into
MySQL... so my main question would be: is this possible?, is this a
BAD
thing? but most of all... would this be resource intensive?
Of course -- HTML is just a string like any
Message-
From: clint lenard [mailto:[EMAIL PROTECTED]
Sent: Friday, 9 September 2005 3:31 PM
To: mysql@lists.mysql.com
Subject: HTML in MySQL?
Hi guys, I'm fairly new to MySQL and I've searched for about a week
looking
for an answer to this...
I'm trying to design a Database that would hold
David and Jasper - thank you both! I will play around with this more now
that you have explained my biggest questions!
Thanks guys,
Clint
:-)
On 9/9/05, Jasper Bryant-Greene [EMAIL PROTECTED] wrote:
clint lenard wrote:
Thanks Jasper for the info! This may sound stupid - but I just want
clint lenard wrote:
Thanks Jasper for the info! This may sound stupid - but I just want to
be sure... do I need to strip the slashes and special characters out and
add them when they're called... or..? I'm just trying to get a clear
picture of exactly what needs to be done with this
Hello, Clint!
I'm trying to design a Database that would hold HTML sites in the DB itself
and use PHP to call for the HTML file - which would be populated with
Content from another table in MySQL. I was told I could put HTML into
MySQL... so my main question would be: is this possible
If you use textarea field of a form, it produces null characters (\n) in
the
end of every string. I recommed to replace them with br tags before
writing into the database. It'll help to avoid output problems. Use
preg_replace(); for it.
Be careful here Vladimir, the (\n) are not 'null'
, September 09, 2005 10:11 AM
To: mysql@lists.mysql.com
Subject: RE: HTML in MySQL?
If you use textarea field of a form, it produces null
characters (\n) in
the
end of every string. I recommed to replace them with br
tags before
writing into the database. It'll help to avoid output
Hello!
Be careful here Vladimir, the (\n) are not 'null' characters; but newline
characters.
Agree, I was wrong.
And i would highly recommend *not* replacing them with br
tags as you write them into the database. This is asking for trouble on
so many levels.
The database will cope
Vladimir B. Tsarkov wrote:
Hello!
Be careful here Vladimir, the (\n) are not 'null' characters; but newline
characters.
Agree, I was wrong.
And i would highly recommend *not* replacing them with br
tags as you write them into the database. This is asking for trouble on
so
Use addslashes($htmlCode) and execute query normally.
?php
$slashedHtmlCode = addslashes($htmlCode);
?
[]´s
Tomita
On 9/9/05, Vladimir B. Tsarkov [EMAIL PROTECTED] wrote:
Hello!
Be careful here Vladimir, the (\n) are not 'null' characters; but
newline
characters.
Agree, I
Some time ago, I posted a question about using HTML in
MySQL tables. For example, if I put the following in a
table cell...
emCowboy State/em (reinforced by logo depicting
cowboy on bucking bronco), emBig Wyoming/em
It will be displayed as...
Cowboy State (reinforced by logo depicting cowboy
David Blomstrom wrote:
Some time ago, I posted a question about using HTML in
MySQL tables.
Someone suggested this is a bad strategy, asking what
I would do if I later decided to change the italicized
words to bold, for example.
I'm just trying to figure out what the options are, as
well
--- Hassan Schroeder [EMAIL PROTECTED] wrote:
If Cowboy State has a semantic meaning, like
nickname, you might want to think about either
having a field for it or, if it's part of a text
segment that doesn't lend itself to that, use a
semantic tag for it, like `nicknameCowboy
State/nickname,
--- Hassan Schroeder [EMAIL PROTECTED] wrote:
If Cowboy State has a semantic meaning, like
nickname, you might want to think about either
having a field for it or, if it's part of a text
segment that doesn't lend itself to that, use a
semantic tag for it, like `nicknameCowboy
State/nickname,
David Blomstrom wrote:
You mean I can make up a name for a semantic tag,
designating every nicknname nickname or every
emphasized word emphasize, for example?
Yep, XML lets you create your own DTD/schema -- though sometimes it
makes sense to use (or leverage) an existing one.
And is this something
On May 21, 2004, at 9:14 PM, David Blomstrom wrote:
--- Hassan Schroeder [EMAIL PROTECTED] wrote:
If Cowboy State has a semantic meaning, like
nickname, you might want to think about either
having a field for it or, if it's part of a text
segment that doesn't lend itself to that, use a
semantic
Brad wrote
Josh Trutwin writes:
Javascript is a client-side language, the code is executed by the user's
browser. It has no way to connect to the database server and run queries
so you need to use a server-side programming language like Java (JDBC),
PhP, Perl, etc. Tomcat is a decent servlet
Hi all,
I have got one serious doubt.
Can we access mysql database from the front end html. If it all it is possible, we
have to right in javascript.
ofcourse we can write it using JDBC(provided we have a servlet engine integrated with
a webserver).
My question is can we access mysql database
Javascript is a client side language. I seriously doubt it alone would do
anything for you.
My Sql [EMAIL PROTECTED]
05/05/2004 12:18 PM
To: [EMAIL PROTECTED]
cc:
Subject:Html and mysql..
Hi all,
I have got one serious doubt.
Can we access mysql
On Wed, 5 May 2004 09:18:01 -0700 (PDT)
My Sql [EMAIL PROTECTED] wrote:
Hi all,
I have got one serious doubt.
Can we access mysql database from the front end html. If it all it
is possible, we have to right in javascript. ofcourse we can write
it using JDBC(provided we have a servlet engine
.
-Original Message-
From: My Sql
To: [EMAIL PROTECTED]
Sent: 5/5/04 11:18 AM
Subject: Html and mysql..
Hi all,
I have got one serious doubt.
Can we access mysql database from the front end html. If it all it is
possible, we have to right in javascript.
ofcourse we can write it using JDBC
Josh Trutwin writes:
Javascript is a client-side language, the code is executed by the user's
browser. It has no way to connect to the database server and run queries
so you need to use a server-side programming language like Java (JDBC),
PhP, Perl, etc. Tomcat is a decent servlet engine with a
Hi all just wanted some professional opinions on my web site located at
http://www.IWantYourStuff.com
I developed the site using HTML (of course) with Perl scripts accessing a
mySQL database. If anyone would like to comment on it or make any
suggestions please drop me a line.
Thanks.
36 matches
Mail list logo