Databases
in [PHP]
|
Problem when using SQL_CUR_USE_ODBC on connect (This isn't a solution, per se...just a suggestion.) I don't know how they compare; I've never personally used the ODBC functions... But, you may give the MSSQL functions a try: http://php.net/mssql - Jon L. On Mon, Mar 31, 2008 at 3:27 PM, cfs <charlie(a)strausesoftware.com> wrote: I'm using PHP with ... 2 Apr 2008 11:44
UPPER(AES_DECRYPT(...)) bug? Hi all. Here's my disclaimer: this question is solely MySQL-related - I just happen to be programming in PHP. I have found some functionality which *appears* to be a bug, but I didn't want to report it before asking some intelligent people. I have this simple query: SELECT UPPER('just a lower case str... 4 Apr 2008 12:57
Problem when using SQL_CUR_USE_ODBC on connect I'm using PHP with Apache. PHP code connects to MS SQL server using ODBC. I'm doing a query against a table that is very simple: one column of the real data type, one of the text data type. The text field is set to "testing 1,2,3". The real column is set to 10.0199995. When I use the default connect option... 31 Mar 2008 16:51
Better way to access MS SQL Server from PHP Currently using ODBC to connect to MS SQL server 2005. Profiling shows that to fetch many rows requires a cursor based fetch of each record - a round trip to SQL server for each. I would like to use some driver/interface from PHP to SQL server that would get all rows in one round trip, or at least a smaller nu... 31 Mar 2008 16:51
RES: [PHP-DB] resources and resource types [top posting warning] You still did not RTFM as Stut told you 4 days ago. I'm pasting here the entire conversation with the subject "Resource id #5": -----Mensagem original----- De: Stut [mailto:stuttle(a)gmail.com] Enviada em: quinta-feira, 27 de março de 2008 15:14 Para: Richard Dunne Cc: php-db(a)lists.php.n... 31 Mar 2008 15:12
resources and resource types When I did a search on "resource(5)" within the PHP online documentation, I found the resource page resource.php. While although it lists all the resources used with mysql, it does not mention how resources are related to resource numbers as above. A query such as a row count on a table results in an integer value. Wh... 31 Mar 2008 16:51
Resource id #5 Can someone explain how I can translate Resource id #5 which is what I am getting from the code below? $result = mysql_query("Select answer from answers") or die(mysql_error()); $resultArray = explode(',',$result); for ($i=0;$i<sizeof($resultArray);$i++) { echo $resultArray[$i]; } ... 27 Mar 2008 14:17
Fwd: Re: [PHP-DB] mysql_num_rows, resource id # This much is working: <?PHP ini_set('error_reporting',E_All); DEFINE ("host","localhost"); DEFINE ("user","root"); DEFINE ("password","password"); DEFINE ("database","questions"); $connection=mysql_connect(host,user,password) or die ('Could not connect' . mysql_error() ); $dbConnect=mysql_select_db('quest... 27 Mar 2008 10:58
mysql_num_rows, resource id # In my code below, I am trying to verify that the query is selecting data from both rows of my answers table. I have run the query on my MySQL CLI and getting answers from both rows, but running this script I get $rows = 0. I can't figure out why its not returning 2 for the number of rows. It is not giving me any err... 27 Mar 2008 10:24
Fwd: Re: [PHP-DB] numeric string to single digit array I did var_dump on the result resource and I got resource(5) of type (mysql result). ... 26 Mar 2008 20:05 |