#36324 [Opn->Fbk]: php does not return data consistently

From: Date: Mon, 23 Jul 2007 12:07:24 +0000
Subject: #36324 [Opn->Fbk]: php does not return data consistently
References: 1  Groups: php.bugs 
Request: Send a blank email to php-bugs+get-115346@lists.php.net to get a copy of this message 
 ID:               36324
 Updated by:       jani@php.net
 Reported By:      lec at uchicago dot edu
-Status:           Open
+Status:           Feedback
 Bug Type:         ODBC related
 Operating System: Mac OS X
 PHP Version:      5CVS-2006-02-08
 New Comment:

Please try using this CVS snapshot:

  http://snaps.php.net/php5.2-latest.tar.gz
 
For Windows (zip):
 
  http://snaps.php.net/win32/php5.2-win32-latest.zip

For Windows (installer):

  http://snaps.php.net/win32/php5.2-win32-installer-latest.msi

And try the PDO ODBC driver instead.


Previous Comments:
------------------------------------------------------------------------

[2006-02-08 02:15:22] lec at uchicago dot edu

One quick note:

I have come to belive this is some kind of buffer problem. I see that
some data comes through when i do netstat -atn | grep 2399 (odbc port).
It is infreequent, and in very small chunks. I think the text fields in
fm db are quite large, perhaps blobs. 

Lec

------------------------------------------------------------------------

[2006-02-08 00:47:26] iliaa@php.net

Please try using this CVS snapshot:

  http://snaps.php.net/php5.1-latest.tar.gz
 
For Windows:
 
  http://snaps.php.net/win32/php5.1-win32-latest.zip



------------------------------------------------------------------------

[2006-02-07 21:02:36] lec at uchicago dot edu

Description:
------------
Here is the problem, I was able to narrow the problem down to PHP ODBC,
but I am still not sure why. Specifically ODBC_exec not returning data
properly, but only in the case  where there is text field or combination
of text and number, etc as bellow. It works with number, date, time,
timestamp alone, not text alone. The data will eventaully be returned
but only last 32 records from any # of records, and it takes for ever. I
mean sometimes with doing simple select on few thousand records is
taking 5-10 mins. 


run: 
/opt/php5.1.2/bin/php test.php

You will need:
Mac OS X
PHP 5.1.2
Apache 2.2.0 (well command line is a problem as well, so no need for
apache)
iODBC 3.52.4

Oh yea on db side of things Mac OS X filemaker server w/odbc drivers. I
am willing to provide dev server access and/or test it.  

Reproduce code:
---------------
<?php

putenv("DYLD_LIBRARY_PATH=/opt/libiodbc-3.52.4/lib");
putenv("ODBCINSTINI=/Library/ODBC/odbcinst.ini");
putenv("ODBCINI=/Library/ODBC/odbc.ini");

//$qry = "SELECT test FROM Person";  // test filed has text

// I limited this so it is readable
$qry = "SELECT PersonID, test FROM Person where PersonID>1 AND
PersonID<100";
print $qry;

$conn = odbc_connect("Person", "username", "password");

$queryresult=odbc_exec($conn,$qry);
odbc_result_all($queryresult,1);
odbc_close($conn);

?>

Expected result:
----------------
SELECT PersonID, test FROM Person where PersonID>1 AND
PersonID<100SQLNumResultCols
SQLNumResultCols
<table 1 ><tr><th>PersonID</th><th>test</th></tr>
<tr><td>1</td><td>hello</td></tr>
//... I did not want to copy all the data in here, but basically it
just gets id's and text. 
<tr><td>67</td><td>hello</td></tr>
<tr><td>68</td><td>hello</td></tr>
<tr><td>69</td><td>hello</td></tr>
<tr><td>70</td><td>hello</td></tr>
<tr><td>71</td><td>hello</td></tr>
<tr><td>72</td><td>hello</td></tr>
<tr><td>73</td><td>hello</td></tr>
<tr><td>74</td><td>hello</td></tr>
<tr><td>75</td><td>hello</td></tr>
<tr><td>76</td><td>hello</td></tr>
<tr><td>77</td><td>hello</td></tr>
<tr><td>78</td><td>hello</td></tr>
<tr><td>79</td><td>hello</td></tr>
<tr><td>80</td><td>hello</td></tr>
<tr><td>81</td><td>hello</td></tr>
<tr><td>82</td><td>hello</td></tr>
<tr><td>83</td><td>hello</td></tr>
<tr><td>84</td><td>hello</td></tr>
<tr><td>85</td><td>hello</td></tr>
<tr><td>86</td><td>hello</td></tr>
<tr><td>87</td><td>hello</td></tr>
<tr><td>88</td><td>hello</td></tr>
<tr><td>89</td><td>hello</td></tr>
<tr><td>90</td><td>hello</td></tr>
<tr><td>91</td><td>hello</td></tr>
<tr><td>92</td><td>hello</td></tr>
<tr><td>93</td><td>hello</td></tr>
<tr><td>94</td><td>hello</td></tr>
<tr><td>95</td><td>hello</td></tr>
<tr><td>96</td><td>hello</td></tr>
<tr><td>97</td><td>hello</td></tr>
<tr><td>98</td><td>hello</td></tr>
<tr><td>99</td><td>hello</td></tr>
</table>

Actual result:
--------------
Notice the number and text do not work either, number alone does work.



SELECT PersonID, test FROM Person where PersonID>1 AND
PersonID<100SQLNumResultCols
SQLNumResultCols
<table 1 ><tr><th>PersonID</th><th>test</th></tr>
<tr><td>0</td><td></td></tr>
<tr><td>0</td><td></td></tr>
<tr><td>0</td><td></td></tr>
<tr><td>0</td><td></td></tr>
<tr><td>0</td><td></td></tr>
<tr><td>0</td><td></td></tr>
<tr><td>0</td><td></td></tr>
<tr><td>0</td><td></td></tr>
<tr><td>0</td><td></td></tr>
<tr><td>0</td><td></td></tr>
<tr><td>0</td><td></td></tr>
<tr><td>0</td><td></td></tr>
<tr><td>0</td><td></td></tr>
<tr><td>0</td><td></td></tr>
<tr><td>0</td><td></td></tr>
<tr><td>0</td><td></td></tr>
<tr><td>0</td><td></td></tr>
<tr><td>0</td><td></td></tr>
<tr><td>0</td><td></td></tr>
<tr><td>0</td><td></td></tr>
<tr><td>0</td><td></td></tr>
<tr><td>0</td><td></td></tr>
<tr><td>0</td><td></td></tr>
<tr><td>0</td><td></td></tr>
<tr><td>0</td><td></td></tr>
<tr><td>0</td><td></td></tr>
<tr><td>0</td><td></td></tr>
<tr><td>0</td><td></td></tr>
<tr><td>0</td><td></td></tr>
<tr><td>0</td><td></td></tr>
<tr><td>0</td><td></td></tr>
<tr><td>0</td><td></td></tr>
<tr><td>0</td><td></td></tr>
<tr><td>0</td><td></td></tr>
<tr><td>0</td><td></td></tr>
<tr><td>0</td><td></td></tr>
<tr><td>0</td><td></td></tr>
<tr><td>0</td><td></td></tr>
<tr><td>0</td><td></td></tr>
<tr><td>0</td><td></td></tr>
<tr><td>0</td><td></td></tr>
<tr><td>0</td><td></td></tr>
<tr><td>0</td><td></td></tr>
<tr><td>0</td><td></td></tr>
<tr><td>0</td><td></td></tr>
<tr><td>0</td><td></td></tr>
<tr><td>0</td><td></td></tr>
<tr><td>0</td><td></td></tr>
<tr><td>0</td><td></td></tr>
<tr><td>0</td><td></td></tr>
<tr><td>0</td><td></td></tr>
<tr><td>0</td><td></td></tr>
<tr><td>0</td><td></td></tr>
<tr><td>0</td><td></td></tr>
<tr><td>0</td><td></td></tr>
<tr><td>0</td><td></td></tr>
<tr><td>0</td><td></td></tr>
<tr><td>0</td><td></td></tr>
<tr><td>0</td><td></td></tr>
<tr><td>0</td><td></td></tr>
<tr><td>0</td><td></td></tr>
<tr><td>0</td><td></td></tr>
<tr><td>0</td><td></td></tr>
<tr><td>0</td><td></td></tr>
<tr><td>0</td><td></td></tr>
<tr><td>67</td><td>hello</td></tr>
<tr><td>68</td><td>hello</td></tr>
<tr><td>69</td><td>hello</td></tr>
<tr><td>70</td><td>hello</td></tr>
<tr><td>71</td><td>hello</td></tr>
<tr><td>72</td><td>hello</td></tr>
<tr><td>73</td><td>hello</td></tr>
<tr><td>74</td><td>hello</td></tr>
<tr><td>75</td><td>hello</td></tr>
<tr><td>76</td><td>hello</td></tr>
<tr><td>77</td><td>hello</td></tr>
<tr><td>78</td><td>hello</td></tr>
<tr><td>79</td><td>hello</td></tr>
<tr><td>80</td><td>hello</td></tr>
<tr><td>81</td><td>hello</td></tr>
<tr><td>82</td><td>hello</td></tr>
<tr><td>83</td><td>hello</td></tr>
<tr><td>84</td><td>hello</td></tr>
<tr><td>85</td><td>hello</td></tr>
<tr><td>86</td><td>hello</td></tr>
<tr><td>87</td><td>hello</td></tr>
<tr><td>88</td><td>hello</td></tr>
<tr><td>89</td><td>hello</td></tr>
<tr><td>90</td><td>hello</td></tr>
<tr><td>91</td><td>hello</td></tr>
<tr><td>92</td><td>hello</td></tr>
<tr><td>93</td><td>hello</td></tr>
<tr><td>94</td><td>hello</td></tr>
<tr><td>95</td><td>hello</td></tr>
<tr><td>96</td><td>hello</td></tr>
<tr><td>97</td><td>hello</td></tr>
<tr><td>98</td><td>hello</td></tr>
<tr><td>99</td><td>hello</td></tr>
</table>


------------------------------------------------------------------------


-- 
Edit this bug report at http://bugs.php.net/?id=36324&edit=1

Thread (5 messages)

« previous php.bugs (#115346) next »