PHP/mysql equivalent of PEAR"s tableInfo()??

I have been using PEAR's tableInfo() to remind myself about the
columns in the table.. but now I want to see as much data as possible
about the table and its contents *without* using PEAR. (I.e. just
using built in stuff for mysqli.)

I have been looking through the manuals, even tried this:

$info = mysqli_query($db_billing,"SHOW FULL COLUMNS IN billing_clients
IN billing");
echo '

'. print_r($info) .'

1

Re: PHP/mysql equivalent of PEAR"s tableInfo()??

On Sat, Jul 11, 2009 at 19:57, Govinda wrote:
> I have been using PEAR's tableInfo() to remind myself about the columns i=
n
> the table.. =A0but now I want to see as much data as possible about the t=
able
> and its contents *without* using PEAR. =A0 (I.e. just using built in stuf=
f for
> mysqli.)

This is not mysqli_#() directly, but just mocked up here in this
email. Not guaranteed to work, but should give you the right idea at
least. ;-P

include('inc/config.php'); // Your configuration
include('inc/db.php'); // Your database connection info

$sql =3D "SHOW TABLES";

$result =3D mysql_query($sql);

foreach(mysql_fetch_assoc($result) as $k =3D> $v) {
$ssql =3D "DESCRIBE ".mysql_real_escape_string($v);
$rresult =3D mysql_query($ssql);
echo "".$k.":
\n";
echo "

\n";

        print_r(mysql_fetch_assoc($rresult));

        echo "

Re: PHP/mysql equivalent of PEAR"s tableInfo()??

> On Sat, Jul 11, 2009 at 19:57, Govinda
> wrote:
>> I have been using PEAR's tableInfo() to remind myself about the
>> columns in
>> the table.. but now I want to see as much data as possible about
>> the table
>> and its contents *without* using PEAR. (I.e. just using built in
>> stuff for
>> mysqli.)
>
> This is not mysqli_#() directly, but just mocked up here in this
> email. Not guaranteed to work, but should give you the right idea at
> least. ;-P
>
> > include('inc/config.php'); // Your configuration
> include('inc/db.php'); // Your database connection info
>
> $sql = "SHOW TABLES";
>
> $result = mysql_query($sql);
>
> foreach(mysql_fetch_assoc($result) as $k => $v) {
> $ssql = "DESCRIBE ".mysql_real_escape_string($v);
> $rresult = mysql_query($ssql);
> echo "".$k.":
\n";
> echo "

\n";

>        print_r(mysql_fetch_assoc($rresult));

>        echo "

\n";

	print_r(mysql_fetch_assoc($rresult));

	echo "

Re: PHP/mysql equivalent of PEAR"s tableInfo()??

Top-posting.

This would be an excellent question for Prune (CC'd) to field,
based on the error message.

Prune?


On Sun, Jul 12, 2009 at 17:49, Govinda wrote:
>> On Sat, Jul 11, 2009 at 19:57, Govinda
>> wrote:
>>>
>>> I have been using PEAR's tableInfo() to remind myself about the columns
>>> in
>>> the table.. =A0but now I want to see as much data as possible about the
>>> table
>>> and its contents *without* using PEAR. =A0 (I.e. just using built in st=
uff
>>> for
>>> mysqli.)
>>
>> =A0 This is not mysqli_#() directly, but just mocked up here in this
>> email. =A0Not guaranteed to work, but should give you the right idea at
>> least. =A0;-P
>>
>> >> include('inc/config.php'); // Your configuration
>> include('inc/db.php'); // Your database connection info
>>
>> $sql =3D "SHOW TABLES";
>>
>> $result =3D mysql_query($sql);
>>
>> foreach(mysql_fetch_assoc($result) as $k =3D> $v) {
>> =A0 =A0 =A0 $ssql =3D "DESCRIBE ".mysql_real_escape_string($v);
>> =A0 =A0 =A0 $rresult =3D mysql_query($ssql);
>> =A0 =A0 =A0 echo "".$k.":
\n";
>> =A0 =A0 =A0 echo "

\n";

>> =A0 =A0 =A0 print_r(mysql_fetch_assoc($rresult));

>> =A0 =A0 =A0 echo "

\n";

> =A0 =A0 =A0 =A0print_r(mysql_fetch_assoc($rresult));

> =A0 =A0 =A0 =A0echo "

Re: PHP/mysql equivalent of PEAR"s tableInfo()??

--0015174c4616dff483046e8f4858
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

On Mon, Jul 13, 2009 at 3:19 AM, Govinda wrote:

> On Sat, Jul 11, 2009 at 19:57, Govinda
>> wrote:
>>
>>> I have been using PEAR's tableInfo() to remind myself about the columns
>>> in
>>> the table.. but now I want to see as much data as possible about the
>>> table
>>> and its contents *without* using PEAR. (I.e. just using built in stuff
>>> for
>>> mysqli.)
>>>
>>
>> This is not mysqli_#() directly, but just mocked up here in this
>> email. Not guaranteed to work, but should give you the right idea at
>> least. ;-P
>>
>> >> include('inc/config.php'); // Your configuration
>> include('inc/db.php'); // Your database connection info
>>
>> $sql = "SHOW TABLES";
>>
>> $result = mysql_query($sql);
>>
>> foreach(mysql_fetch_assoc($result) as $k => $v) {
>> $ssql = "DESCRIBE ".mysql_real_escape_string($v);
>> $rresult = mysql_query($ssql);
>> echo "".$k.":
\n";
>> echo "

\n";

>>       print_r(mysql_fetch_assoc($rresult));

>>       echo "

\n";

>        print_r(mysql_fetch_assoc($rresult));

>        echo "

Re: PHP/mysql equivalent of PEAR"s tableInfo()??

> I have this code:
>
> $db_billing=mysqli_connect(localhost,metheuser,mypass,billin g);
> if (mysqli_connect_error()) { die("Can't connect: " .
> mysqli_connect_error()); }
>
> mysqli
>
>
> //$dbname = 'billing';
> $sql = "SHOW TABLES";
>
> $result = mysql_query($sql); // line 53
>
> Now mysql, What are you doing?

Yes. 3 lashing. Thanks. I am not likely to neglect again
remembering that mysql and mysqli are different and have different
syntax.

unfortunately I am still in over my head enough to have to ask..

Here is what I have now:

$db_billing=mysql_connect(localhost,metheuser,mypass,billing );
if (!$db_billing) { die('Could not connect: ' . mysql_error()); }

$sql = "SHOW TABLES";

$result = mysql_query($sql);

foreach(mysql_fetch_assoc($result) as $k => $v) { //line 62
$ssql = "DESCRIBE ".mysql_real_escape_string($v);
$rresult = mysql_query($ssql);
echo "".$k.":
\n";
echo "

\n";

	print_r(mysql_fetch_assoc($rresult));

	echo "

Re: PHP/mysql equivalent of PEAR"s tableInfo()??

On Jul 13, 2009, at 10:03 AM, Govinda wrote:

>> I have this code:
>>
>> $db_billing=mysqli_connect(localhost,metheuser,mypass,billin g);
>> if (mysqli_connect_error()) { die("Can't connect: " .
>> mysqli_connect_error()); }
>>
>> mysqli
>>
>>
>> //$dbname = 'billing';
>> $sql = "SHOW TABLES";
>>
>> $result = mysql_query($sql); // line 53
>>
>> Now mysql, What are you doing?
>
> Yes. 3 lashing. Thanks. I am not likely to neglect again
> remembering that mysql and mysqli are different and have different
> syntax.
>
> unfortunately I am still in over my head enough to have to ask..
>
> Here is what I have now:
>
> $db_billing=mysql_connect(localhost,metheuser,mypass,billing );
> if (!$db_billing) { die('Could not connect: ' . mysql_error()); }
>
> $sql = "SHOW TABLES";
>
> $result = mysql_query($sql);
>
> foreach(mysql_fetch_assoc($result) as $k => $v) { //line 62
> $ssql = "DESCRIBE ".mysql_real_escape_string($v);
> $rresult = mysql_query($ssql);
> echo "".$k.":
\n";
> echo "

\n";

> 	print_r(mysql_fetch_assoc($rresult));

> 	echo "

\n";

         print_r(mysql_fetch_assoc($rresult));

         echo "

Re: PHP/mysql equivalent of PEAR"s tableInfo()??

--Apple-Mail-13-972431744
Content-Type: text/plain;
charset=US-ASCII;
format=flowed;
delsp=yes
Content-Transfer-Encoding: 7bit

>
> Better late then never! :)
>
> I played around with your code tonight and got this working on a
> test server:
>
>
> >
> $db_billing = mysql_connect($DBHOST, $DBUSER, $DBPASS) or die("Could
> not connect: " .mysql_error());
>
> $db_selected = mysql_select_db($DB, $db_billing);
>
> if(!$db_selected) {
> die("Can't use database: " . mysql_error());
> }
>
>
> if (!$db_billing) { die('Could not connect: ' . mysql_error()); }
>
> $sql = "SHOW TABLES";
>
> $result = mysql_query($sql) or die("query failed:
> " .mysql_error());
> $resulttest = mysql_fetch_assoc($result);
>
>
> foreach($resulttest as $k => $v) { //line 62
> $ssql = "DESCRIBE ".mysql_real_escape_string($v);
> $rresult = mysql_query($ssql);
> echo "".$k.":
\n";
> echo "

\n";

>        print_r(mysql_fetch_assoc($rresult));

>        echo "

\n";

while ($row = mysql_fetch_assoc($rresult)) {

	print_r($row); //line 278

}

echo "