How to make PHP variables?

[Badger]

You clicked this and thought it was the most stupidest question you actually ever saw... No, it's more complex than simple PHP. Here's what I mean. When you use SQL and PHP together, there is a function called mysqli_fetch_object() in which returns the SQL query result rows as objects in which you can then get the columns by their names. Example:

while ($object = mysqli_fetch_object($result)) {
echo $object->id;
echo $object->username;
echo $object->aUselessColumn;
}

So what I want to know how to do is how to make my own version of that. How do they access the columns like that when they don't have them set until the query?

Basically I need to know the code between in which mysqli_fetch_object() function runs. Thanks!

 

[Burdened]

You clicked this and thought it was the most stupidest question you actually ever saw... No, it's more complex than simple PHP. Here's what I mean. When you use SQL and PHP together, there is a function called mysqli_fetch_object() in which returns the SQL query result rows as objects in which you can then get the columns by their names. Example:

while ($object = mysqli_fetch_object($result)) {
echo $object->id;
echo $object->username;
echo $object->aUselessColumn;
}

So what I want to know how to do is how to make my own version of that. How do they access the columns like that when they don't have them set until the query?

Basically I need to know the code between in which mysqli_fetch_object() function runs. Thanks!

prepared statements will help

  $conn = @mysqli_connect('localhost', 'root', 'pass', 'dbname');
   if ($conn === false) {
     return false;
   }

$sql = "SELECT * from table";
$result = $conn->query($sql);

if($result === false) {
echo 'error, something wrong with SQL or conn lul';
} else {
foreach ($row = $result->fetch_assoc()) {
echo '$row["columnname1"]';
echo '$row["columnname2"]';
echo '$row["etc"]';
}
}

try this example,

 

[Badger]

prepared statements will help

  $conn = @mysqli_connect('localhost', 'root', 'pass', 'dbname');
   if ($conn === false) {
     return false;
   }

$sql = "SELECT * from table";
$result = $conn->query($sql);

if($result === false) {
echo 'error, something wrong with SQL or conn lul';
} else {
foreach ($row = $result->fetch_assoc()) {
echo '$row["columnname1"]';
echo '$row["columnname2"]';
echo '$row["etc"]';
}
}

try this example,

You didn't understand the question...

 

[Brazy]

prepared statements will help

  $conn = @mysqli_connect('localhost', 'root', 'pass', 'dbname');
   if ($conn === false) {
     return false;
   }

$sql = "SELECT * from table";
$result = $conn->query($sql);

if($result === false) {
echo 'error, something wrong with SQL or conn lul';
} else {
foreach ($row = $result->fetch_assoc()) {
echo '$row["columnname1"]';
echo '$row["columnname2"]';
echo '$row["etc"]';
}
}

try this example,

also badger not using some kewl command prompt like font and sizing to help me read it better could help too

 

[Badger]

also badger not using some kewl command prompt like font and sizing to help me read it better could help too

Already figured it out. I wanted to use the stdClass.