Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 195
  • Last Modified:

put script in mysql

how to put my pages on mysql databases so i just need only one page and one database. other pages is in the database. because, the script just act as a text!! is anyone can inside pictures and docs too?
i'm sorry if this question is double, cause i just can't find it on paq. thx.
2 Solutions
stisAuthor Commented:
please, i need urgent.
pls make a blob field in you database and put your image code there and for rest text paes you can simply create text field.... it will work fine.
Put blob fields in their own table. Otherwise, they will slow down your queries.
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

A blob field is the only kind of field that will hold anything other than text.  A blob field will hold images, sound, whatever you like.  But like was stated earlier, this is something you want to keep in a separate table from the rest of your information, then do a query on multiple tables when you need to reference it.
W00t! My place. I know all about this, and I know how to do it.

Alright what you need to do:

Insert the PHP code into the blob field.

To run the code:

// Make sure you connect to your mysql database
$sqlr = mysql_query("SELECT * FROM TABLE_NAME_HERE where id=_ID_OF_THINGY");
while ($sr = mysql_fetch_array($sqlr)) {

I keep an ID columm in all my tables to do the exact thing above. I also have the colum CODE as a blob for PHP coding....

If you need more help download my portal system and review the code at wwww.multicode.net
No comment has been added to this question in more than 21 days, so it is now classified as abandoned.

I will leave the following recommendation for this question in the Cleanup topic area:
    Split: carchitect {http:#8086993} & Morph007x2b {http:#8143415}

Any objections should be posted here in the next 4 days. After that time, the question will be closed.

EE Cleanup Volunteer

Featured Post

[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now