Any ideas people ?

p1tst0p

Hi there,

hope someone can help me,

Basically i have written a Feedback application, for use at my company.. this enables our clients to add feeback on our work..

Each client uses their own table in a database called 'Feedback'

Within the app i have a section to add a new client, which creates the new table, copys a template PHP directory to the new client added.

but, what i need to do, is find a way for php to edit the header.php file, to point to the new table created.. at the moment i have to go into every client added and change the header.php to point to the newly created table.

this is my header.

<?php
$backupnow = date("YmdHis");
$now = date("Y-m-d");
$nowf = date("y-m-d h:i:s");

$sqlhost = "localhost";
$sqlpass = "*******";
$sqlname = "*******";
$sqldb = "feedback";
$sqltable = "ChangeMe";
$sqlselect = "*";
?>

as you can see, the $sqltable needs to be changed for each new client, before its copyed to the new directory.

hope i have explained this enough.

Thanks.

Will Moverley

PHP-Editors_com

are you sure you NEED to create a new copy of the code everytime? one of the benifits of using a Server Script is the ability to to dynamically change how application run based on the current environment - by this you could possible use session variables etc. But it really depends on what you are doing.

There are many option to try - I dont recommend editing the code like this.

p1tst0p

Hi PHP-Editors.com,

well, im quite a newb at this, so i cant think of any other way.. to make the newclient use the newly created table.

what would you suggest ?

Thanks for your reply

Will

PHP-Editors_com

Im not sure how the clients identify themselfs - but if its through a form (username, password) then then table you use to identify them, should also have a field called something like (table_name). OK - so when you validate the client (using whatever you do) simply have the script extract the their 'table_name' - then assign some type of variable to that value. Use this value to build you queries - dynamically building your script.

p1tst0p

Hmm, i think i know what you mean...

they dont really authenticate tho.. its probably quite dirty how i have it..

i just have the clients go to the directory for there form. ie, i create a new client called bob, it copys /Template directory to /bob then i give the client "www.mydomain.com/feedback/bob" to fill out the feedback.

but i think it would be easyer for 1 page, with authentication.. but it starts getting complex for me, being a newbie and all that.. hmmm.

i can get the standard $PHP_AUTH_USER to work for me, as i have a db called, authentication.. which username, password, and company in.. and that works.. but all iv been doing is putting the authentication code, on the index page, in the clients directory..

hmmmm

ahundiak

You might consider pulling the customer directory ('bob' in your example) out of $_SERVER['SCRIPT_FILENAME'] then using it to generate the table name.

p1tst0p

ahundiak, you lost me there
what does that enable me to do ?

ill have a search around for it, see what i can find.

ahundiak

For each client you create a new directory and copy header.php to it?

When header.php is executed, the global variable $_SERVER['SCRIPT_FILENAME'] will be set to wherever the header.php file is actually being executed from i.e. it will be something like /feedback/bob/header.php. A different client (maybe tom) will have a different directory and hence a different value.

You can add some code to header.php which extracts the final directory and builds the table name from it. So you never need to hardcode the table name.

Something like.

  $names = explode('/',$_SERVER['SCRIPT_FILENAME']);
  $dir = $names[count($names) - 2];
  $sqltable = 'prefix_' . $dir;
  echo $sqltable;