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 ??
2) How can I retrieve data items from my SQL database using php ??
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 ??

Any help is greatly appreciated.

Thank you,

Vivek

<vivekmahanta [at] gmail.com> wrote in message
news:1175366307.159007.195530 [at] 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 ??
| 2) How can I retrieve data items from my SQL database using php ??
| 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 ??
|
| Any help is greatly appreciated.

RTFM...if you're too lazy to do that, google.

<vivekmahanta [at] gmail.com> wrote in message
news:1175366307.159007.195530 [at] 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/

On Apr 1, 2:03 am, "Mike Russell" <RE-MOVEm... [at] Curvemeister.comRE-
MOVE> wrote:
> <vivekmaha... [at] gmail.com> wrote in message
>
> news:1175366307.159007.195530 [at] 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 Russellwww.curvemeister.com/forum/

Hey,

I think this is a long overdue thank you for the tips you gave me.
Thank you.

Vivek