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
