3 More Discussions You Might Find Interesting
1. What is on Your Mind?
On Saturday May 4th the forums will briefly break when I switch our Apache PHP 5.6 module to PHP 7.0.
Previously, I had two sites set up for testing the migration, but for many reasons, the second site has additional issues unrelated to PHP 7.0 so it is hard to debug on a different site and... (3 Replies)
Discussion started by: Neo
3 Replies
2. Red Hat
Dear All,
My redhat version is:
# cat /etc/redhat-release
Red Hat Enterprise Linux AS release 4 (Nahant Update 4)
#
# uname -a
Linux cotapplication3.cot.com 2.6.9-42.ELsmp #1 SMP Wed Jul 12 23:32:02 EDT 2006 x86_64 x86_64 x86_64 GNU/Linux
#
I want to update my php from:
# php... (1 Reply)
Discussion started by: monojcool
1 Replies
3. UNIX for Advanced & Expert Users
hi,
while separated they produce the usual mail alert and i can see the output...
if i write into the php script:
<?php
system('php -f /var/www/vhosts/domain.com/httpdocs/folder/script1.php');
system('php -f /var/www/vhosts/domain.com/httpdocs/folder/script2.php');
system('php -f... (0 Replies)
Discussion started by: 7stars
0 Replies
LEARN ABOUT PHP
pdo.query
PDO.QUERY(3) 1 PDO.QUERY(3)
PDO
::query - Executes an SQL statement, returning a result set as a PDOStatement object
SYNOPSIS
public PDOStatement PDO::query (string $statement)
DESCRIPTION
PDOStatement PDO::query (string $statement, int $PDO::FETCH_COLUMN, int $colno) PDOStatement PDO::query (string $statement, int
$PDO::FETCH_CLASS, string $classname, array $ctorargs) PDOStatement PDO::query (string $statement, int $PDO::FETCH_INTO, object
$object)
PDO.query(3) executes an SQL statement in a single function call, returning the result set (if any) returned by the statement as a
PDOStatement object.
For a query that you need to issue multiple times, you will realize better performance if you prepare a PDOStatement object using PDO.pre-
pare(3) and issue the statement with multiple calls to PDOStatement.execute(3).
If you do not fetch all of the data in a result set before issuing your next call to PDO.query(3), your call may fail. Call PDOState-
ment.closeCursor(3) to release the database resources associated with the PDOStatement object before issuing your next call to
PDO.query(3).
Note
Although this function is only documented as having a single parameter, you may pass additional arguments to this function. They
will be treated as though you called PDOStatement.setFetchMode(3) on the resultant statement object.
PARAMETERS
o $statement
- The SQL statement to prepare and execute. Data inside the query should be properly escaped.
RETURN VALUES
PDO.query(3) returns a PDOStatement object, or FALSE on failure.
EXAMPLES
Example #1
Demonstrate PDO::query
A nice feature of PDO.query(3) is that it enables you to iterate over the rowset returned by a successfully executed SELECT state-
ment.
<?php
function getFruit($conn) {
$sql = 'SELECT name, color, calories FROM fruit ORDER BY name';
foreach ($conn->query($sql) as $row) {
print $row['name'] . " ";
print $row['color'] . " ";
print $row['calories'] . "
";
}
}
?>
The above example will output:
apple red 150
banana yellow 250
kiwi brown 75
lemon yellow 25
orange orange 300
pear green 150
watermelon pink 90
SEE ALSO
PDO.exec(3), PDO.prepare(3), PDOStatement.execute(3).
PHP Documentation Group PDO.QUERY(3)