never thought of that...

jam_wil

I am currently trying to make a small php / mySQL forum. I have hit a small problem however. I have completed the installation wizard for the forum (sets up mySQL dbase and sets up admin account) and I am now starting development on the actuall forum. My problem is that I need a way to transfer the mySQL username / password entered in the installation to the forum. I can't store it in a variable because the user would have to enter it in at the beginning of each session. I though of storing it in the database but I realized that I needed to connect to the dbase before I can get info from it. Does anybody have a good idea as to how to store this information. I thought about a text file, but that would not be secure enough. any thoughts?

drawmack

store it in a text file and then when someone first goes to the board plop it from the text file into the database.

tommynanda

Adding to drawmack's idea... I would say, store it in a PHP file than a simple text file and include that file... use fopen() to write to a PHP file just like a text file

Good Luck
TommYNandA

jam_wil

I never realized you could write to another php file with file() and it's related functions. Where would I put the all of the <html> and <body> etc. tags though?

tommynanda

You dont need HTML tags in this file coz you are just saving some variables.... something like this might work for you

Say you have a HTML form that POSTs username and password fields to config.php at the time of installation

config.php

$acname = $_POST['username'];
$pass = $_POST['password'];
$fname = fopen("storepass.php","wt");
fwrite($fname,"\$username=\"$acname\"\n");
fwrite($fname,"\$password=\"$pass\"\n");
fclose($fname);

now you have storepass.php in which you have variable $username and $password

Include them where ever you need username and pass... say u got another code where u want access DB with these username and pass...

somefile.php

include("storepass.php");
mysql_connect("localhost", "$username", "$password");
....
...

There might be some syntax errors.. with escape characters.. so take a look at config.php 😉

Have Fun!
TommYNandA

jam_wil

Thank-you muchly, that was very helpful

tommynanda

YW, Mark this thread resolved.. link is at the bottom of this page

Have Fun Coding!
TommYNandA