Webcodez – The database of web programming tutorials

MySql Basics – Insert Data

To insert data into the database, mysql queries are used. There are multiple types of mysql queries. The one to put data into the database is the INSERT query. This one inserts a new row into the database which requires the fields of a row for that table to be given a value to. A basic [...]

Continue reading...

MySql Basics – Connect

MySql can be used to interact with databases: insert and retrieve data. It can come very handy when you need to save a collection of the same ‘kind’ ( such as products or forum messages, user accounts, etc. ) and which need to be able to be edited easily. To interact with the database you [...]

Continue reading...

GET variables

A second method to send user filled in data (input) from forms or just to send data through the url to another page, is the GET method. The GET method works through the url of the page, and defines the GET variables inside the url. Example: Url: webcodez.net/showthread.php GET variables: none Url: webcodez.net/showthread.php?p=23 Get variables: $_GET['p'] = 23 You see you [...]

Continue reading...

POST Variables

When you create forms, you can either use the POST or GET method. In this chapter I’ll be explaining the POST method, in which the data is put into POST variables. POST variables are just like normal arrays which contain a certain amount of (sub-)variables. Once a form is submitted, for each form field one [...]

Continue reading...