[PHP-DB] Re: Access another server aspx page

2007-04-25 Thread Emil Ivanov

You can do this on HTTP level.

Open the source (html) of login.aspx and look at the submission form. 
Then use a tool such as telnet to send the GET/POST request for testing.

Then implement this in php - probably using the cURL extention.

You'll need to read a bit about the HTTP protocol...

Hope this helps...

Regards,
Emil Ivanov

Lasitha Alawatta wrote:

 Hi All,

 

 


I need to access .aspx page using .php page. It’s like this.

 

01) I have a login.aspx  home.aspx pages in different server (IIS6, 
already hosted at different location: www.abc.com/login.aspx 
http://www.abc.com/login.aspx  ).


02) I have the username  password for login to the above 
application (home.aspx)


03)I need to go to home.aspx page, bypassing login.aspx page. (using 
php page: http://localhost/bypass.php )


 

·  Is there is a possibility to control www.abc.com/login.aspx 
http://www.abc.com/login.aspx page events.


Ex: login.aspx page have 2 text boxes  login button.

I mean is it possible to handle login.aspx’s login button’s click event?

 


·  Is it possible to do my requirement using php *curl* function?

·  Or do you all have any suggestions?

 


Thanking you,

Best regards,

Lasitha


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



[PHP-DB] PDO prepared statements sometimes returns empty resultset

2007-04-23 Thread Emil Ivanov

Hi,

I'm trying to get some data form a MySQL db using PDO and prepared 
statement, but I noticed that sometimes it fetches an empty result set, 
but sometimes does what it's supposed to do - returns the whole result set.


The environment is WinXP SP2 Home, Apache 2.2.4, PHP 5.2.1 and MySQL 5.0.27.

Here is some code:

$db = new PDO(
  'mysql:host=localhost;dbname=name_of_db',
  'user_name',
  'password',
  array (
 PDO::ATTR_PERSISTENT = true
  )
);
$db-query('SET CHARACTER SET utf8');
$stmt = $db-prepare(CALL sp_get_all_currencies(:lang_id));
$stmt-bindValue(':lang_id', $currenctLanguageId, PDO::PARAM_INT);
$stmt-execute();
$currencies = $stmt-fetchAll();

So here, $currencies sometimes is an empty array, and after a refresh of 
the browser it populates.


I also noticed that it works ok with $db-query(), but query doesn't 
have that fancy param binding (I think).


Is there some caching or something... Is this a bug in PHP or I'm not 
getting the picture right?


Regards,
Emil Ivanov

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php