sending username and password for prompt window

[qadeer_ahmad]

Friends,

i want to open a file from a server i can open this file directly giving link in browser it prompt me username and password i give it and it open .. but i want to open it through a script like this

if(!$handle = @fopen("http://www.test.com/admin/orders.cgi/orders.dat","rb")){
die("Could not open orders.dat");
}

it not open here and give my error message

Could not open orders.dat

is there any way i can send username and password for prompt window ... and then open this file and read data .... to store in database... since file is just a text file....

since in prompt window i see some information like
site: test.com
Realm Admin Intranet

and inputbox for username and password...

Any Idea here.....

[planetsim]

Maybe doing a search im sure theres a response for it, not entirely sure myself as ive never tried but wouldnt sending headers over before accessing the file work.

[qadeer_ahmad]

Still looking for help?

[gufmn]

I imageine it would depend on how the site authenticates users. If it's just an htaccess file you should be able to do something like http://username:[e-mail].....

Not sure what you could do if it's a custom authentication.

[Clicked checkboxes to get rid of the smiley - Weedpacket]

[tsinka]

Hi,

looking at the description I think that the site uses standard HTTP authentication. You can use curl if the extension is enabled. Read more about this here.

Thomas

[qadeer_ahmad]

Thanks for help ..
i try this like

if(!$handle = @fopen("http://abc123@https://test.com/admin/orders.cgi/orders.dat","rb")){
die("Could not open file orders.dat");
}

here abc is username and 123 is passworkd but the result same
could not open the file

[tsinka]

Here's an example using curl. But ssl support needs to be enabled:

<?PHP
$ch = curl_init();
curl_setopt($ch,CURLOPT_URL,"https://test.com/admin/orders.cgi/orders.dat");
curl_setopt($ch,CURLOPT_USERPWD,"user:password");
curl_setopt($ch,CURLOPT_RETURNTRANSFER,1);
// only use the following line if the server doesn't
// have a valid CA Cert
curl_setopt($ch,CURLOPT_SSL_VERIFYPEER,FALSE);
curl_setopt($ch,CURLOPT_HEADER,0);
$content = curl_exec($ch);
curl_close($ch);
echo "<pre>$content</pre>";
?>

Thomas

[stolzyboy]

Originally posted by qadeer_ahmad
Thanks for help ..
i try this like

if(!$handle = @fopen("http://abc123@https://test.com/admin/orders.cgi/orders.dat","rb")){
die("Could not open file orders.dat");
}

here abc is username and 123 is passworkd but the result same
could not open the file

if that's truly your code... you forgot the : between the abc and 123, it should be abc:123, not abc123 all one string

[qadeer_ahmad]

Thanks tsinka and all friends problem is solved through this

<?PHP
$ch = curl_init();
curl_setopt($ch,CURLOPT_URL,"https://test.com/admin/orders.cgi/orders.dat");
curl_setopt($ch,CURLOPT_USERPWD,"user:password");
curl_setopt($ch,CURLOPT_RETURNTRANSFER,1);
// only use the following line if the server doesn't
// have a valid CA Cert
curl_setopt($ch,CURLOPT_SSL_VERIFYPEER,FALSE);
curl_setopt($ch,CURLOPT_HEADER,0);
$content = curl_exec($ch);
curl_close($ch);
echo "<pre>$content</pre>";
?>

i got a file CSV ... here i need more help since i got a CSV file now i want to send data to database what i do here ....???

some more here as $content contain this CSV data so when we print $content it print on Browser window like CSV date ......

[tsinka]

Ok,

how does the table look like and how does the CSV file look like ?

Thomas

P.S.: I wonder if the smiley in your last post knows how the user/password string looks like now 😉

[qadeer_ahmad]

browsing file is look like a CSV file first row contain heading like this

"CardAddress","CardCity","CardState","CardZip"

and other line one by one contain the values like

xyz","abc",xyz","abc"

so if first line have 4 heading other lines also contain 4 value only ... i think this is 100% a CSV file....

But this data store in a variable $content... when i apply

print count($content). "count";

then it give result "1".

[tsinka]

There are three ways:

1. save the data in a file and use the load data infile function of MySQL
2. savethe data in a file and use the csv functions to read the data line by line and store the data in the db
3. Use explode to put the data in an array and store the contents of the array in the db.

Thomas

[qadeer_ahmad]

Thanks tsinka,

A lot of thanks ... i use 2 option and it solved the problem completely thanks a lot........