You are here: Re: How to add and retrieve data from an SQL database on the hosting site « All PHP « IT news, forums, messages
Re: How to add and retrieve data from an SQL database on the hosting site

Posted by Mike Russell on 04/01/07 06:03

<vivekmahanta@gmail.com> wrote in message
news:1175366307.159007.195530@q75g2000hsh.googlegroups.com...
> Hey guys,
>
> I have a few questions about php.
> 1) How can I add data items to an SQL database on my hosting site
> using php ??

Easy - first determine which SQL implementation is supported by your server,
then use the appropriate set of function calls. More than likely, your host
uses MySQL, So start by playing around with PhpMyAdmin. There are any
number of examples and tutorials out there, here's one:
http://www.freewebmasterhelp.com/tutorials/phpmysql

> 2) How can I retrieve data items from my SQL database using php ??

See above - basically you executate a SQL query, and access the fields in a
recordset object.

> 3) How can I hide the code to do these functions so that users are not
> able to see the details about my hosting site SQL database ??

Protect your site from shell level access and you should be golden. Php
will not show up at the client end.

> Any help is greatly appreciated.

You're welcome.
--
Mike Russell
www.curvemeister.com/forum/

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация