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:
>>
>> <html>
>> <body>
>>
>> <?
>> $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 "<table><tr>";
>> echo "<th>Companyname</th>";
>> echo "<th>Contactname</th></tr>";
>> while (odbc_fetch_row($result))
>> {
>> $compname=odbc_result($result,"CompanyName");
>> $conname=odbc_result($result,"ContactName");
>> echo "<tr><td>$compname</td>";
>> echo "<td>$conname</td></tr>";
>> }
>> odbc_close($conn);
>> echo "</table>";
>> ?>
>>
>> </body>
>> </html>
>>
>> My error:
>>
>> Fatal error: Call to undefined function: odbc_fetch_row() in
>> /home/chandan/public_html/deb.php on line 19
>> Companyname Contactname
>>
>> Also .. I am trying this live on cPanel compiler coz I could not install
>> the
>> PHP thing on my localhost. I have apache-tomcat-5.5.17 which works
>> perfectly
>> with jsp files but I do not understand what does it take to run a php
>> using
>> apache.
>>
>> chris smith-9 wrote:
>>
>>>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
>>>
>>>
>>>
>>
>>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
>
--
View this message in context: http://www.nabble.com/simple-issue-tf2683559.html#a7487209
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
