To get the GET method data in PHP is pretty simple to do, all you need to do is the following.
First of all lets say the page we are on is index.php?type=1&page=10&word=hello
echo $_GET['type']; // outputs: 1
echo $_GET['page']; // outputs: 10
echo $_GET['word']; // outputs: hello
?>
In a form submitted using the GET method, the data is appended to the URL as query parameters. You can access this data using the $_GET superglobal array in PHP, or by parsing the URL in other programming languages.
When data is POSTed to a PHP script, you may access them from the $_POST super global variable.
< ?php // This is an example of comment in PHP /* This is another example of comment in PHP and we can write comments in multiple lines using this method */ ? >
The GET method in PHP allows you to grab information from the URL to use in your script.For example, say you are on the URL index.php?id=1 you could then in the PHP script grab the id using the GET method to use in your script.
If you know FPDF or simlar library which helps to make a PDF file, using PHP,you will be able to write to a PDF file out of data read from mysql tables.
if you know SQL language, you can run any command by using PHP's mysql_query() function.
No, you are better using the correct type ie: $_POST or $_GET
To delete data from your MySQL database you need to use the mysql_query() function. Please see the example below: <?php mysql_query("DELETE FROM table_name WHERE field_name = 44"); ?>
the best method to collect primary data is to make a Baseline Data or using the method of Rapid Rural Appraisal.
Create an HTML form with METHOD="post" and ACTION="login2.php". In login2.php check if the entered username and password are correct. You can get the username with $_POST['name_of_username_input']. The same goes for the password.
using the post command.$_POST['checkboxname'];
Ultimately PHP is a programming language and MySQL is a database language. Using PHP with MySQL is a nice combination with built-in support and the simplicity of it all. However, there aren't a lot of disadvantages of using PHP with a database, it just allows for better data organization and whatnot. There are definitely advantages and disadvantages to using a database other than MySQL (such as MongoDB or PostgreSQL).