Member Avatar for hinde

I have to write an include file for this independent study thing I am doing, since my boss doesn't feel that mysql stored procedures are enterprise-ready yet. This include file will, among other things, interface with the database that I designed.

Is there anything I should know before doing this? Links and/or your personal opinions would be nice.

  • 2 Contributors
  • 1 Reply
  • 99 Views
  • 6 Days Discussion Span
  • Latest Post Latest Post by TopDogger
Member Avatar for TopDogger

It sounds like you want to use an include file to store your SQL statement. You can just assign the SQL statment to a variable as a string in the include file. As in:

$sql = "SELECT col_1, col_2, col_3 FROM filename WHERE id=3";

If security is the major concern, you should place the include files outside the Web tree. In other words, above the root directory for your site. Most servers have a tmp directory or something similar that you can use to store these types of files. The important part is that it should not be part of the Web site tree and therefore will not be accessible to others.

To call the include file, just fully specify the path to the file as in:

require_once '/home/mysite/tmp/sql01.php';

If you do not know the server path to a directory outside of the Web tree, just ask your Webmaster or hosting company.

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.