Re: Call PHP script from MySQL

Mário Gamito wrote: > Hi Nathan, > > >>> Is it possible to call from within MySQL an external PHP script ? >>> I've read "MySQL Stored Procedure Programming" from O'Reilly but >>> found nothing :( >> I'd really like to see an example of why you need this functionality, >> if that'd be okay. Not to judge, just to learn :) > > I'm inserting values in a Linux/MySQL table from an ASP.NET/C# page. > I need to insert the password field with the correct hash (vpopmail). > > So, after the first insert leaving the password field blank, I need to > invoke a PHP script that calculates the hash and then insert it. Assuming there is no way to calculate the hash in ASP.net/C# then you could almost certainly create a pure C mysql UDF that can calculate it in a function and leave PHP and double insert stuff out and allow any MySQL client to claculate the hash.... See my earlier post for UDF details. Col