Re: [PHP-DB] simple issue
by Chris Carter other posts by this author
Nov 22 2006 12:55AM messages near this date
Re: [PHP-DB] simple issue
|
Re: [PHP-DB] 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:
> >
> > <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
Thread:
Chris Carter
John Comerford
Ankur Dave
Chris
Chris Carter
Jeffrey
Chris Carter
Chris
John Comerford
Chris
|
