Answers for "php get query"

PHP
5

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>
Posted by: Guest on May-13-2020
1

php get query string

<?php
	echo $_GET["query_name"]; // url queries are stored in $_GET 
?>
Posted by: Guest on November-17-2020
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'];
}
Posted by: Guest on October-06-2020
0

php + get sql query

echo $select->__toString();
Posted by: Guest on June-10-2020
0

php query

xPaw\SourceQuery\Exception\InvalidPacketException: Failed to read any data from socket in C:\xampp\htdocs\minecraft\vendor\xpaw\php-source-query-class\SourceQuery\BaseSocket.php:50
Stack trace:
#0 C:\xampp\htdocs\minecraft\vendor\xpaw\php-source-query-class\SourceQuery\Socket.php(76): xPaw\SourceQuery\BaseSocket->ReadInternal(Object(xPaw\SourceQuery\Buffer), 1400, Array)
#1 C:\xampp\htdocs\minecraft\vendor\xpaw\php-source-query-class\SourceQuery\SourceQuery.php(212): xPaw\SourceQuery\Socket->Read()
#2 C:\xampp\htdocs\minecraft\View.php(27): xPaw\SourceQuery\SourceQuery->GetInfo()
#3 {main}
Posted by: Guest on August-19-2021

Browse Popular Code Answers by Language