| paulmarson |
 |
NetHosted Customer
Joined: 26 Jan 2005
Posts: 439
Location: Midlands
|
 Posted: Tue Feb 15, 2005 7:19 pm Post subject: Database |
| |
Hello !
I'm totally new to SQL and PHP so help !
If i make a datebase with mysql, how to i access it through a website for information (i.e. a search on a particular field)
*looks for a book on sql/php*
 |
|
| Back to top |
|
| NetHosted - Andrew |
|
NetHosted Staff
Joined: 22 Mar 2004
Posts: 5684
|
| Posted: Tue Feb 15, 2005 7:23 pm Post subject: |
| |
Woah that'll be a rather large amount of code - I'm sure there is a tutorial out there for this - google it!
Andrew
_________________
| Andrew Bassett
| Managing Director, NetHosted Ltd.
| Resellers, take a look at overselling  !
| Members, tell us what you think of NetHosted! |
|
| Back to top |
|
| paulmarson |
|
NetHosted Customer
Joined: 26 Jan 2005
Posts: 439
Location: Midlands
|
| Posted: Tue Feb 15, 2005 7:26 pm Post subject: |
| |
*bang goes my idea* |
|
| Back to top |
|
| NetHosted - Andrew |
|
NetHosted Staff
Joined: 22 Mar 2004
Posts: 5684
|
| Posted: Tue Feb 15, 2005 7:27 pm Post subject: |
| |
Well in Java you have to import libraries, then open the connection to the database etc etc it's not a one line code implentation!
Andrew
_________________
| Andrew Bassett
| Managing Director, NetHosted Ltd.
| Resellers, take a look at overselling !
| Members, tell us what you think of NetHosted! |
|
| Back to top |
|
| paulmarson |
|
NetHosted Customer
Joined: 26 Jan 2005
Posts: 439
Location: Midlands
|
| Posted: Tue Feb 15, 2005 7:35 pm Post subject: |
| |
so there is no easy way to do a query on a datalase on a webpage ?
 |
|
| Back to top |
|
| NetHosted - Andrew |
|
NetHosted Staff
Joined: 22 Mar 2004
Posts: 5684
|
| Posted: Tue Feb 15, 2005 8:07 pm Post subject: |
| |
As I said - I don't know, all I know is from my knowledge of hacking phpBB and Java it's never as easy as one line of code.
Andrew
_________________
| Andrew Bassett
| Managing Director, NetHosted Ltd.
| Resellers, take a look at overselling !
| Members, tell us what you think of NetHosted! |
|
| Back to top |
|
| NetHosted - Mark |
|
NetHosted Staff
Joined: 21 Dec 2004
Posts: 217
|
| Posted: Wed Feb 16, 2005 6:39 am Post subject: |
| |
well I'll impart the basic SQL query you want  you can use php.net to find the rest out THe whole freakin language guide is upthere 
SELECT <field name to search on or * to search all> FROM <table name to search in> WHERE fieldname LIKE "value to search for can contain '%' to match anything'"';
_________________
| Mark
| Customer Service & Sales, NetHosted Ltd
| Resellers, take a look at overselling !
| Members, tell us what you think of NetHosted! |
|
| Back to top |
|
User Permissions |
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You can download files in this forum
|
| |
Client Support
