Member Avatar for digidreams

Hello All,
Can anyone help me how to insert html code in mysql database coloumn and also how to change the var char to 1000, for now it is 100.

Please help me out

thanks 7 regards
Raj

  • 3 Contributors
  • 2 Replies
  • 66 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by indianrock9
Member Avatar for blocblue

Firsty a VARCHAR cannot exceed 255 characters. You'd need to use a TEXT field type instead.

And when inserting HTML into a database I always escape it before inserting and before redisplaying it onscreeen to prevent XSS. So for a how to, just Google for XSS.

R.

Member Avatar for indianrock9

Hi Raj,
Click on the 'Structure' Tab of the table where you need to make the change. Then click on the Pencil icon against the field that you want to change. This will show you the field & it's assigned type, length, etc. in Edit mode. You will see the 'Length/Values' field as 100. You should be able to change it to 1000 here. Click on Save button & you should be done.

Let us know if this worked for you.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.