PHP - Reading Normalized Mysql Database (key/value)

Hey,

I'm trying to work out how I can have a simple script that will work like this:

Page 1 - Heading, Paragraph, Image read from database.
Page 2 - Has text boxes allowing you to change heading, paragraph and image (url) with each edit using a different text box. (Admin panel)

The database connection would be in a separate file.

So far I've got the database connection sorted.

Code: [Select]
<?php
//Database Information
$dbtype = "mysql"; 
$db_host = "localhost";
$db_user = "";
$db_pass = "";
$db_name = "";
$db_port = "";
$db_table_prefix = "userCake_";
?>
At the top of each of the other pages this is what I've got.
Code: [Select]
<?php 
require_once("models/config.php");
?>
Let's say I give each bit stored in the database a page ID and an object ID.

If the page selected is index.php how can we give it a page ID of 1 and give then include all the separate 'objects' throughout the page?

Hopefully this makes sense?

Cheers,
Jack

Where is the best to store the list of categories and menu? Obviously it is better to reduce mysql queries. From a plain list in file, we can create desirable list (menu) from an array. This is quite faster (though SELECT from an indexed table is fast too; but I do know if it is as fast as reading from a php file). Any idea how to code this to create the menu faster ?

As per the client requirement he wants to read words from a file and want to insert them in database  one by one . ie a confirmation is required whether he wants to insert is or not. I have developed the thing but the problem is when i am retrieving the words it asks for all the words. i will show u wat the problem is. My main query is i want to pause the exectution until user's input.

Code: [Select]
<script type="text/javascript" src="jquery.js"></script>
<script type"text/javascript">
function show() {
document.getElementById('form#submit').fadeIn();
alert("Abhinav");
}
$(document).ready(function(){
$("form#submit").submit(function() {
// we want to store the values from the form input box, then send via ajax below
var word    = $('#word').attr('value');
var synonym     = $('#synonym').attr('value');

$.ajax({
type: "POST",
url: "ajax.php",
data: "word="+ word + "&synonym=" + synonym,
success: function(){
$('form#submit').hide();
//$('form#submit :input').val("");
$('div.success').fadeIn();
}
});
return false;
});
});
</script>

<?php 
$file=fopen("welcome.txt","r") or exit("Unable to open file!");
@$word="";
@$c="";
while (!feof($file))
{
  $c=fgetc($file);
if(strcmp($c," ")==0)
{ echo "".
 
"<form id='submit' method='post' name='submit' action='' >".  
        "<fieldset>  ".
            "<legend>Enter Information</legend>  ".
"            <label for='word'>Word:</label>  ".
"<input id='word' class='text' name='word' size='20' type='text' value='$word' >  ".
"            <label for='Synonym'>Synonym:</label>  ".
"<input id='synonym' class='text' name='synonym' size='20' type='text'>  ".
"            <button class='button positive' type='submit'>  Add Client </button>  ".
   " </fieldset>  ".
   " </form>  ".
"<div class='success' style='display:none;'>Client has been added.</div>  ".
"</div>";
 
$word="";
}
else
$word=$word.$c;
}
fclose($file);

?>



Now what i want is after user clicks add client then only next insertion box must be shown. please check the attached image to see the output. Guys pls help me over this. Thnx in advance

I'm trying to learn how to code the proper way.

There's a few things im worried about,but overall im worried about clogging up the server.  so what should i keep in mind while coding, to avoid this?

I'm thinking, keep insert and update to a minimum?  as in, when possible, use session to keep track of data until i absolutly have to add that data to a database? is that a correct thought?

what about once the data is in the database, how much trouble is it to ask for the selected data inside a database?  should i be worried about overdoing request of data from databases?   

on the other hand, should i be worried about having too many sessions travelling around with a user.  why?

Im just asking to get a better feel for how to do things the proper way, i would hate to have a website built, only to find out that what i built is only a bat, that would bash the hell out of a server i wanted to put it on.