HTML into MYSQL is recommended ?

B

BigStack

Newbie

Dec 10, 2013

9

0

• Dec 10, 2013

• #1

Hello,


I'm working on my first website and I need to know more opinions regarding importing HTML code into MYSQL database.
I will not put sophisticated HTML code, I only use basic commands like bold, br, italic, etc. to give the text article a good shape look.


So what you recommend?


Thanks for any reply.

 

J

Jayar

Junior Member

May 19, 2010

138

45

• Dec 10, 2013

• #2

HTML into SQL? is that even possible?

Put HTML into your page not into your database i see no reason for doing what you want to do, and 99% sure is not even possible

 

HerpDerpSlerp

Power Member

Mar 19, 2013

777

629

• Dec 10, 2013

• #3

It will give you less control over your data. Store what data needs to be stored and manipulate it with css on the front end for easy on the fly changes

 

B

BigStack

Newbie

Dec 10, 2013

9

0

• Dec 10, 2013
• Thread Starter Thread Starter

• #4

Jayar said:

HTML into SQL? is that even possible?


Put HTML into your page not into your database i see no reason for doing what you want to do, and 99% sure is not even possible

Click to expand...

Yeap, it is possible! Do google for "insert html code in mysql" and you get relevant results, my question is if it recommended

HerpDerpSlerp said:

It will give you less control over your data. Store what data needs to be stored and manipulate it with css on the front end for easy on the fly changes

Click to expand...

The HTML code that I want to insert to mysql is part of a page content and it will be something like this:

<p>The<strong>iPhone 2</strong> been fabricated between 2003 and 2007. </ br> This period <strong>Apple</strong> sold about x products.</p>

So will that affect the host server speed activity ?

 

Last edited: Dec 10, 2013

B

BigStack

Newbie

Dec 10, 2013

9

0

• Dec 10, 2013
• Thread Starter Thread Starter

• #5

Or what's the best way to insert static content on a dynamic page ?

 

K

kanun

Newbie

Nov 2, 2013

15

0

• Dec 11, 2013

• #6

I don't get it. There is no need to store HTML code at Databases so your text can have a better shape look.

 

Commoner

Supreme Member

Dec 8, 2013

1,364

400

• Dec 11, 2013

• #7

Nope, not recommended albeit doable
An analogy, "You can put install Diablo II into an old computer but results are as expected"
Utilize SQL Language in MySQL for optimal performance

2 cents worth and Good Luck

 

pxoxrxn

Supreme Member

Dec 21, 2011

1,398

2,084

• Dec 11, 2013

• #8

Have we never heard of a little thing called a Cascading Style Sheet? A language developed for this exact purpose?

 

laowai

Power Member

Feb 27, 2011

523

185

• Dec 11, 2013

• #9

You can definitely do that and many templates are using this approach. For example you can then create custom admin dashboard where you can pull the content from db, edit the content and get changes live to your site when you save it.

 

aimadnet

Registered Member

Aug 13, 2011

50

19

• Dec 11, 2013

• #10

No it's not recommended

 

N

Nit3watch

Registered Member

Jun 13, 2012

53

14

• Dec 11, 2013

• #11

Its very easy, just use str_replace("\r\n","",stripslashes($_POST['$your_string']));

Ive used it on many of my sites - this is taken from wordpress and buddypress:

function settings_screen_save( $group_id ) {
$setting = '';

if ( isset( $_POST['group_extension_example_1_setting'] ) ) {
$setting = str_replace("\r\n","",stripslashes($_POST['group_extension_example_1_setting']));
}

groups_update_groupmeta( $group_id, 'group_extension_example_1_setting', $setting );
}