7 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
And how does one executes a command there?
Mine is:
lxterminal -e ./script.sh (23 Replies)
Discussion started by: sea
23 Replies
2. What is on Your Mind?
The TED talk (Technology Entertainment Design) non-profit initiative started many years ago as a platform for sharing knowledge to a wide audience. Since 2006 the talks are available online under a Creative Commons license. There are now 1000+ TED talks from a wide range of subjects and I wanted to... (3 Replies)
Discussion started by: figaro
3 Replies
3. Web Development
OK, please vote on your favorite web browser and comment why!
Only currently supported browers please!
Thanks.
PS: I am a big FireFox fan. FireFox add-ons rock! (61 Replies)
Discussion started by: Neo
61 Replies
4. UNIX and Linux Applications
Can everyone please list there favorite firefox tweaks? These are my favorite tweaks.
Config.trim_on_minimize
true Allow Windows to swap out memory when the program is minimized.
false Prevent Windows from swapping out memory when the program is minimized. (Default)
Enter... (0 Replies)
Discussion started by: cokedude
0 Replies
5. Shell Programming and Scripting
Going through the CPAN configuration on a Solaris systems and I keep getting stuck at:
Select your continent (or several nearby continents) ?
It offers no choices to select from. I have tried using the default PERL installing with Solaris, and installing PERL packages from Blastwave. I... (0 Replies)
Discussion started by: bisbell
0 Replies
6. What is on Your Mind?
First, a hello to all of you out there. Quick introduction since I'm new here before I ask my question. I'm a Computer Science major who has an unnatural love of operating systems. :) In fact, I'm looking on building a new computer that will have enough RAM to let me have some fun with several VMs... (7 Replies)
Discussion started by: ViperChief
7 Replies
7. What is on Your Mind?
Out of the 100s of screensavers in xscreensaver, what is your favorite?
I think mine is definitely juggle. I can sit and watch that juggler forever. I haven't looked into the code, but it must be amazingly complex to deal with all that's going on. From the random throwing pattern, to the arm... (0 Replies)
Discussion started by: tjlst15
0 Replies
LEARN ABOUT PHP
mysqli_stmt.get_result
MYSQLI_STMT.GET_RESULT(3) 1 MYSQLI_STMT.GET_RESULT(3)
mysqli_stmt::get_result - Gets a result set from a prepared statement
Object oriented style
SYNOPSIS
mysqli_result mysqli_stmt::get_result (void )
DESCRIPTION
Procedural style
mysqli_result mysqli_stmt_get_result (mysqli_stmt $stmt)
Call to return a result set from a prepared statement query.
PARAMETERS
o $
stmt -Procedural style only: A statement identifier returned by mysqli_stmt_init(3).
RETURN VALUES
Returns a resultset or FALSE on failure.
MYSQL NATIVE DRIVER ONLY
Available only with mysqlnd.
EXAMPLES
Example #1
Object oriented style
<?php
$mysqli = new mysqli("127.0.0.1", "user", "password", "world");
if($mysqli->connect_error)
{
die("$mysqli->connect_errno: $mysqli->connect_error");
}
$query = "SELECT Name, Population, Continent FROM Country WHERE Continent=? ORDER BY Name LIMIT 1";
$stmt = $mysqli->stmt_init();
if(!$stmt->prepare($query))
{
print "Failed to prepare statement
";
}
else
{
$stmt->bind_param("s", $continent);
$continent_array = array('Europe','Africa','Asia','North America');
foreach($continent_array as $continent)
{
$stmt->execute();
$result = $stmt->get_result();
while ($row = $result->fetch_array(MYSQLI_NUM))
{
foreach ($row as $r)
{
print "$r ";
}
print "
";
}
}
}
$stmt->close();
$mysqli->close();
?>
Example #2
Procedural style
<?php
$link = mysqli_connect("127.0.0.1", "user", "password", "world");
if (!$link)
{
$error = mysqli_connect_error();
$errno = mysqli_connect_errno();
print "$errno: $error
";
exit();
}
$query = "SELECT Name, Population, Continent FROM Country WHERE Continent=? ORDER BY Name LIMIT 1";
$stmt = mysqli_stmt_init($link);
if(!mysqli_stmt_prepare($stmt, $query))
{
print "Failed to prepare statement
";
}
else
{
mysqli_stmt_bind_param($stmt, "s", $continent);
$continent_array = array('Europe','Africa','Asia','North America');
foreach($continent_array as $continent)
{
mysqli_stmt_execute($stmt);
$result = mysqli_stmt_get_result($stmt);
while ($row = mysqli_fetch_array($result, MYSQLI_NUM))
{
foreach ($row as $r)
{
print "$r ";
}
print "
";
}
}
}
mysqli_stmt_close($stmt);
mysqli_close($link);
?>
The above examples will output:
Albania 3401200 Europe
Algeria 31471000 Africa
Afghanistan 22720000 Asia
Anguilla 8000 North America
SEE ALSO
mysqli_prepare(3), mysqli_stmt_result_metadata(3), mysqli_stmt_fetch(3), mysqli_fetch_array(3), mysqli_stmt_store_result(3).
PHP Documentation Group MYSQLI_STMT.GET_RESULT(3)