Jump to content
xisto Community
rogerpars

Newbie Sql Dummie with sql and php

Recommended Posts

Im new this forum, im student and need to implement a web page that recall infor from a tableand present in the page.For example a real state web page , select combo price, type house, rooms and look in a simple table and retrieve price, stret etcwhat will I have to review to make it donethanks for all

Share this post


Link to post
Share on other sites

First thing would be to define the Database and the Tables in the Database.Is that done yet?

Share this post


Link to post
Share on other sites

Welcome rogerpars to the forum and the start of the fun of the internet, I am sorry I cannot help you out with your error as I am no good at Sql and Database's I can only install forums basically :s. Anyway I can help you to get along with the members on the forum and not get warned or banned! I have provided you with the all important links which you must read! All I can say now is enjoy the forum in its but moments!

The Important links:

-Ash :P

Share this post


Link to post
Share on other sites

These are some of the steps you need to do (assuming using SQL for a database and PHP for the back-end):

 

(1) Design a database to hold your data.

(2) Learn basic SQL, enough to perform basic CRUD (Create, Read, Update, Delete) operations. An overview is at http://www.w3schools.com/sql/default.asp .

(3) Learn basic PHP, to make the SQL connection and present data to the user in an usable format. An overview is at http://us3.php.net/tut.php and http://www.w3schools.com/php/default.asp .

(4) Know enough HTML to submit forms. An overview is at http://www.w3schools.com/html/html_forms.asp . Learn how to integrate the form with PHP.

(5) Post the set of pages to a site that has a PHP processor (the majority of sites should be able to handle this, or maybe you have an internal one for your class)

(6) Make updates as needed.

 

Regards,

 

z.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...

Important Information

Terms of Use | Privacy Policy | Guidelines | We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.