[i0xIllusi0n]

I know this script may seem useless to some of you, but hey, it helps meout and I thought I'd post it. It's easier because you only need to use a function for getting column data from the database. Plus, if you ever need to edit something there's only 1 place to edit it.

PHP Code:

$result = getinfo("table", "columntocheck", "dataforcolumntocheck", "getrow"); 


For example, getting a users ID:

PHP Code:

$result = getinfo("users", "name", $name, "id"); 


In config.php:

PHP Code:

<?php
$dbconnect = new mysqli("host", "username", "password", "database");
include 'functions.php';
?>

In functions.php;

PHP Code:

<?php
function getinfo($from, $where, $input, $getrow)
{
    if ($result = $GLOBALS['dbconnect']->query("SELECT * FROM $from WHERE $where='$input'"))
    {
        while ($row = $result->fetch_assoc())
        {
            $endresult = $row["$getrow"];
        }
        if ($endresult != "")
        {
            return $endresult;
        }
        else
        {
            return "$where does not exist!";
        }
        $endresult->free();
        $result->free();
    }

}
?>

[Kinanizer]

Thanks for the share, but how would I use it?

[i0xIllusi0n]

Thanks for the share, but how would I use it?

Set it up correctly, with your SQL details in config.php.
Then, on a page, include config.php which includes functions.php so you'll have the function.

PHP Code:

$id = getinfo("users", "name", $name, "id"); 


"users" = the table name
"name" = select a column that matches the next variable with this. so since $name is "admin", this says match column where the name is admin
$name = "admin"
"id" = getting the row, "id"

[BreShiE]

It'd help if you gave out a full explanation of what this actually does. But nice post.

[i0xIllusi0n]

It'd help if you gave out a full explanation of what this actually does. But nice post.

"Small SQL Data Retrieval Script"

"It's easier because you only need to use a function for getting column data from the database."