simple issue

Hi,

I am new to PHP, just trying a peace of code to access mySQL database to
fetch and show result on web page. But getting errors. Can you help me with
this code please. Or if you have a very basic code where in I can do some
insertion in the database.


--
View this message in context: http://www.nabble.com/simple-issue-tf2683559.html#a7485306
Sent from the Php - Database mailing list archive at Nabble.com.

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

Re: simple issue

Chris Carter wrote:
> Hi,
>
> I am new to PHP, just trying a peace of code to access mySQL database to
> fetch and show result on web page. But getting errors. Can you help me with
> this code please. Or if you have a very basic code where in I can do some
> insertion in the database.

There are hundreds of mysql + php tutorials on the 'net - do a search in
your preferred search engine.

If you *still* can't work it out post a sample of the code you're trying
to use and the errors you get.

--
Postgresql & php tutorials
http://www.designmagick.com/

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

Re: simple issue

You'll have to supply more information

a) code sample
b) error message



Chris Carter wrote:
> Hi,
>
> I am new to PHP, just trying a peace of code to access mySQL database to
> fetch and show result on web page. But getting errors. Can you help me with
> this code please. Or if you have a very basic code where in I can do some
> insertion in the database.
>
>
>

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

Re: simple issue

my code:




$username="chris";
$password="carter";
$database="chris_phpb1";

mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query="SELECT * FROM phpbb_banlist";
$result=mysql_query($query);

if (!$result)
{exit("Error in SQL");}
echo "

RE: simple issue

Just chk your phpinfo() is odbc supprt is ebable in that. ??
If not need to enable odbc settings in that.=0D

-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-
@nkur d@ve || http://ullu.wordpress.com=0D
=0D

-----Original Message-----
From: Chris Carter [mailto:chandan9sharma@yahoo.com]=0D
Sent: Wednesday, November 22, 2006 10:57 AM
To: php-db@lists.php.net
Subject: Re: [PHP-DB] simple issue


my code:




$username=3D"chris";
$password=3D"carter";
$database=3D"chris_phpb1";

mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query=3D"SELECT * FROM phpbb_banlist";
$result=3Dmysql_query($query);

if (!$result)
{exit("Error in SQL");}
echo "

Re: simple issue

--------------050806090301010208090206
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

I'm pretty new to this stuff myself but try this:

while ($row = $result->fetch_array())
{
$compname=$row["CompanyName"];
$conname=$row["ContactName"];
echo "$compname";
echo "$conname";
}




Chris Carter wrote:
> my code:
>
>
>
>
> > $username="chris";
> $password="carter";
> $database="chris_phpb1";
>
> mysql_connect(localhost,$username,$password);
> @mysql_select_db($database) or die( "Unable to select database");
> $query="SELECT * FROM phpbb_banlist";
> $result=mysql_query($query);
>
> if (!$result)
> {exit("Error in SQL");}
> echo "

Re: simple issue

Chris Carter wrote:
> my code:
>
>
>
>
> > $username="chris";
> $password="carter";
> $database="chris_phpb1";
>
> mysql_connect(localhost,$username,$password);
> @mysql_select_db($database) or die( "Unable to select database");
> $query="SELECT * FROM phpbb_banlist";
> $result=mysql_query($query);
>
> if (!$result)
> {exit("Error in SQL");}
> echo "

Re: simple issue

Thanks Jeff,

As I mentioned, this is just a sample code with username password db name
all changed. Thanks for your advice coz I never knew the php db archive is
searchable.


Jeffrey-2 wrote:
>
> You should be aware the the PHP-DB archives are openly available on the
> web and searchable. Assuming you have listed your actual username,
> password, etc, you should immediately go to your web site and change
> your password. If possible change also your username and database name.
> Do it now.
>
> It would not be an overly demanding task for a hacker to find your web
> site and once she does, she has free access to your database.
>
> And in future, when sharing code on PHP-DB, which is a must if you want
> the expert help people here can provide, always leave out or change the
> MySQL log in info.
>
> Good luck,
>
> Jeffrey
>
>
> Chris Carter wrote:
>> my code:
>>
>>
>>
>>
>> >> $username="chris";
>> $password="carter";
>> $database="chris_phpb1";
>>
>> mysql_connect(localhost,$username,$password);
>> @mysql_select_db($database) or die( "Unable to select database");
>> $query="SELECT * FROM phpbb_banlist";
>> $result=mysql_query($query);
>>
>> if (!$result)
>> {exit("Error in SQL");}
>> echo "