[RESOLVED] inserting php_auth_user into mysql table

[rooky]

Hi there

I am simply trying to insert the username('PHP_AUTH_USER') and password('PHP_AUTH_PW') from a HTTPS authentication screen into mysql table

This does not work anymore system uses php4.4.1 with Apache 2

Could someone please help!!

heres the code:-

<?php
$auth=false;
$DBhost = "localhost";
$DBuser = "xxuser";
$DBpass = "xx";
$DBName = "xx";
$table = "xx";

$PHP_AUTH_USER = $SERVER['PHP_AUTH_USER'];
$PHP_AUTH_PW=$SERVER['PHP_AUTH_PW'];

//flash form variables that insert okay into database

$namelog = $POST['projectname2'];
$ownerlog = $POST['projectlocation2'];
$applic = $_POST['application3'];

mysql_connect($DBhost,$DBuser,$DBpass) or die("Unable toconnect to database");
@mysql_select_db("$DBName") or die("Unable to select database $DBName");

$sqlquery = "INSERT INTO $table (projectname,location,application,username,password,date) VALUES ('$namelog','$ownerlog','$applic','$PHP_AUTH_USER',PASSWORD('$PHP_AUTH_PW'),NOW())";

$result = mysql_query($sqlquery);
//get number of rows
$number = mysql_num_rows($result);

$i = 0;

if ($number < 1) {

}
else {
while ($number > $i) {

$thename = mysql_result($result,$i,"name");
$theemail = mysql_result($result,$i,"owner");

$i++;
}
}
?>

query inserts flash form variables fine but not the username and password

I know the password will be encrypted thats fine as long as I get the username aswell

thanks

Chris

[thepeccavi]

There is an unnessescary @ symbol:

mysql_connect($DBhost,$DBuser,$DBpass) or die("Unable toconnect to database");
NOT NEEDED!!!!!@<<<<<<<<<<mysql_select_db("$DBName") or die("Unable to select database $DBName"); 

[rooky]

Hi taken @ symbol out but my problem still exists everything goes into my mysql table fine except username and password which are blank

don't know what I am doing wrong for it not to work

rooky

[Jack_McSlay]

put an

error_reporting(E_ALL);

in the beginning of the script and check the error messages, I have a feeling PHP_AUTH_USER and PHP_AUTH_PW doesn't exist on $_SERVER.

[DESIGNGRAPHY]

You're using lots of variable which is hard for me to help you as I'm not a PHP guru.

Better if you could have something like this:

$query = mysql_query("INSERT INTO username (username, password) VALUES ('$username','$password'')") or die(mysql_error());

I don't use $PHP_AUTH_USER for insert username and password. I use like normal as above. I heard HTTP authentication will work if you're on apache module..

http://www.php.net/manual/en/features.http-auth.php
http://www.yeswebmaster.com/article.php?id=45

Hope that'll help you!

[rooky]

Did the isset test and error tests and server is not set. php_AUTH_PW and does not show up on php info() I found out that PLESK server software has been updated

this I think is the problem

I willl talk to my Host

thanks

rooky