php get query code example

Example 1: php get

#Get Method and Post Data

Send data through get and Post

$_GET Example
============
<?php
if(isset($_GET['name'])){
echo htmlentities($_GET['name']);
//or
//$name = htmlentities($_GET['name']);
//echo $name
print_r($_GET);
}
?>
<!DOCTYPE html>
<html>
<head>
    <title>Get post website</title>
    </head>
<body>
    <form method="GET action=get_post.php">
        <div>
            <label>Name</label><br>
            <input type="text" name ="name">
        </div>
        <div>
            <label>Email</label><br>
            <input type="text" name ="email">
        </div>
        <input type="submit" value ="Submit">
    </form>
</body>
</html>
================
$_POST Example
================
<?php
if(isset($_GET['name'])){
//echo htmlentities($_GET['name']);
//or
//$name = htmlentities($_GET['name']);
//echo $name
//print_r($_GET);
}

if(isset($_POST['name'])){
    $name = htmlentities($_POST['name']);
    echo $name;
    print_r($_POST);
}
?>
<!DOCTYPE html>
<html>
<head>
    <title>Get post website</title>
    </head>
<body>
    <form method="POST" action="get_post.php">
        <div>
            <label>Name</label><br>
            <input type="text" name ="name">
        </div>
        <div>
            <label>Email</label><br>
            <input type="text" name ="email">
        </div>
        <input type="submit" value ="Submit">
    </form>
</body>
</html>
================
$_REQUEST Example  //another uncommon way to do it. This is not 
  //normally done this way
================
<?php
if(isset($_REQUEST['name'])){
    $name = htmlentities($_REQUEST['name']);
    echo $name;
    print_r($_REQUEST);
}

?>
<!DOCTYPE html>
<html>
<head>
    <title>Get post website</title>
    </head>
<body>
    <form method="POST" action="get_post.php">
        <div>
            <label>Name</label><br>
            <input type="text" name ="name">
        </div>
        <div>
            <label>Email</label><br>
            <input type="text" name ="email">
        </div>
        <input type="submit" value ="Submit">
    </form>
</body>
</html>
================
$_SERVER['QUERY_STRING']  Example
================
<?php
echo $_SERVER['QUERY_STRING'];


?>
<!DOCTYPE html>
<html>
<head>
    <title>Get post website</title>
    </head>
<body>
    <form method="POST" action="get_post.php">
        <div>
            <label>Name</label><br>
            <input type="text" name ="name">
        </div>
        <div>
            <label>Email</label><br>
            <input type="text" name ="email">
        </div>
        <input type="submit" value ="Submit">
    </form>
</body>
</html>

Example 2: php get query string

<?php
	echo $_GET["query_name"]; // url queries are stored in $_GET 
?>

Example 3: query php

<?php 
// MySqli connection
$mysqli = new mysqli("localhost", "my_username", "my_password", "my_database");

// Errors
if($mysqli->connect_error) {
  echo "<b>Failed to connect to MySQL: </b>" . $mysqli->connect_error;
}

// Query
$selectQuery = $mysqli->prepare("SELECT * FROM my_table");
$selectQuery->execute();
$selectQueryResult = $selectQuery->get_result();

// Loop 
while($selectQueryRow = $selectQueryResult->fetch_array()) {
  echo $selectQueryRow['my_column'];
}

// Example
$selectUsername = $mysqli->prepare("SELECT * FROM users");
$selectUsername->execute();
$selectUsernameResult = $selectUsername->get_result();
while($selectUsernameRow = $selectUsernameResult->fetch_array()) {
  echo $selectUsernameRow['username'];
}

Tags:

Php Example

Recent Posts