Creating a car rental system using php and mysql.

[psd99]

do you know how to change the password?

obviously I have to edit the file but even after doing that no luck

I get:

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'root'@'localhost' (using password: YES) in C:\xampp\htdocs\conn.php on line 6
Error: Couldn't Connect to the database server. For more information and help, consult your IT support.

do u know if I need to add something into my mysql tables?
It must be almost similar to your forum.


I think for the second point that Chris Imrie will know I am going to pm him

 

[Ian]

I'm not sure how to change it, did you use "root" as the username and nothing as the password in the php config file? Thats the only thing I can think of

 

[psd99]

Yes tried that no luck though.

I like the layout of this software phpmyadmin

 

[psd99]

managed to change the mysql password through the security settings on xampp

updated the php file connect still no luck
this time i get the error:


Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\xampp\htdocs\checklogin.php on line 15
Incorrect Username or password entered.


looking in the checklogin i dont see what the problem can be
line 15 is

$_SESSION["valid_user"]="username";
$_SESSION["valid_pass"]="password";

not sure about all of this now

 

[psd99]

Hi admin

do you know how to connect to mysql and my database through telnet

please look at this:

What's the telnet commands to access MySQL?
Use the following outline to connect and begin querying the MySQL server from Telnet. Remember that you can not connect to your databases remotely due to security concerns, you can only connect from localhost.

1. Connect to the MySQL Server
servername:> mysql -u USERNAME -p
Enter Password: PASSWORD
2. Connect To The Database
mysql> use DATABASENAME;
3. Receving Help
mysql> help

I do use phpmyadmin
but that is not complex enough

I tried the above but it didnt work

when i was connecting remotely to uni
i did this open psd.ac.uk
then i get asked for username and password

any ideas how to get this working for the laptop I am trying it from then?

thanks

psd99

 

[Ian]

I'm really not sure PSD, I'm not an expert at PHP/MySQL as I've never been taught anything - I just pick up what I need to know from googling.

I think your best bet would be to check with someone from uni in a similar situation

Sorry I can't be of more help If I think of anything I'll post back

 

[psd99]

no worries thanks for looking.

my system does work

i got the log in to work
now working on getting the bit where customer details are added
and trying to get a query to work

this is pretty difficult
deadline is this week, for the written part
going to hit close to 100 pages

yikes

control and 5 is what I learnt with microsoft word
this creates a space and a half between each word, what my uni requires for the write up specifications