[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."