MYSQLI_REAL_QUERY(3) 1 MYSQLI_REAL_QUERY(3)mysqli::real_query - Execute an SQL query
Object oriented style
SYNOPSIS
bool mysqli::real_query (string $query)
DESCRIPTION
Procedural style
bool mysqli_real_query (mysqli $link, string $query)
Executes a single query against the database whose result can then be retrieved or stored using the mysqli_store_result(3) or
mysqli_use_result(3) functions.
In order to determine if a given query should return a result set or not, see mysqli_field_count(3).
PARAMETERS
o $
link -Procedural style only: A link identifier returned by mysqli_connect(3) or mysqli_init(3)
o $query
- The query, as a string. Data inside the query should be properly escaped.
RETURN VALUES
Returns TRUE on success or FALSE on failure.
SEE ALSO mysqli_query(3), mysqli_store_result(3), mysqli_use_result(3).
PHP Documentation Group MYSQLI_REAL_QUERY(3)
Check Out this Related Man Page
MYSQLI_FIELD_COUNT(3) 1 MYSQLI_FIELD_COUNT(3)mysqli::$field_count - Returns the number of columns for the most recent query
Object oriented style
SYNOPSIS
int$mysqli->field_count ()
DESCRIPTION
Procedural style
int mysqli_field_count (mysqli $link)
Returns the number of columns for the most recent query on the connection represented by the $link parameter. This function can be useful
when using the mysqli_store_result(3) function to determine if the query should have produced a non-empty result set or not without knowing
the nature of the query.
PARAMETERS
o $
link -Procedural style only: A link identifier returned by mysqli_connect(3) or mysqli_init(3)RETURN VALUES
An integer representing the number of fields in a result set.
EXAMPLES
Example #1
$mysqli->field_count example
Object oriented style
<?php
$mysqli = new mysqli("localhost", "my_user", "my_password", "test");
$mysqli->query( "DROP TABLE IF EXISTS friends");
$mysqli->query( "CREATE TABLE friends (id int, name varchar(20))");
$mysqli->query( "INSERT INTO friends VALUES (1,'Hartmut'), (2, 'Ulf')");
$mysqli->real_query("SELECT * FROM friends");
if ($mysqli->field_count) {
/* this was a select/show or describe query */
$result = $mysqli->store_result();
/* process resultset */
$row = $result->fetch_row();
/* free resultset */
$result->close();
}
/* close connection */
$mysqli->close();
?>
Procedural style
<?php
$link = mysqli_connect("localhost", "my_user", "my_password", "test");
mysqli_query($link, "DROP TABLE IF EXISTS friends");
mysqli_query($link, "CREATE TABLE friends (id int, name varchar(20))");
mysqli_query($link, "INSERT INTO friends VALUES (1,'Hartmut'), (2, 'Ulf')");
mysqli_real_query($link, "SELECT * FROM friends");
if (mysqli_field_count($link)) {
/* this was a select/show or describe query */
$result = mysqli_store_result($link);
/* process resultset */
$row = mysqli_fetch_row($result);
/* free resultset */
mysqli_free_result($result);
}
/* close connection */
mysqli_close($link);
?>
PHP Documentation Group MYSQLI_FIELD_COUNT(3)
Dear friends,
I have one more query,
incase a file contains multiple tags of same name, then how to get the required string between the tags, in which the string begins with "O/M"
i.e., file1.txt contains following text(please note that all the following tags are in single line)... (6 Replies)
I've searched the net and tried various solutions that don't work for me.
I'm trying to return values from a SQL query and I keep getting a "^M" appended to one field.
Getting data from table
SELECT * FROM TABLE...
Spooling to $HOME/out.log
...
WF_DATA=`tail -7 $HOME/out.log |... (5 Replies)
Hello Guys,
I'm new to Shell scripting, and i need someone to help me with this issue:
I'm trying to do a dynamic update query on Sysbase database table using shell script.
Lets say, the Update query is "update Table set id=X" , where X is dynamic value for the loop index.
If the loop is... (10 Replies)
hi there
I'm getting a string from a sqlplus query, and I need to compare it with another string
Problem here, is that the string i get from query brings a 'carriage return' with it, and comparing throws always false value.
i need to delete all carriage retun charactres in string.
how... (6 Replies)
Hi
I have to run a query in a remote postgresql server but I'm having troubles with quotes, what I need to do is:
Login to remote server
su as cpanel user
execute the query
The following code works well if USERH is a numerical value, the problem is went USERH is a string (example... (8 Replies)
Hi
Please can someone help me with a query. Will the following query bring back 'Jolly Brewers'. My understanding is that it will bring back either 'Jolly' or 'Brewers' but not 'Jolly Brewers'....because of the pipe
egrep '(Jolly)|(Brewers)' Public_Houses
Please can someone confirm?
... (6 Replies)
Hi
I want ot save SQL query result in one txt file. for that i have written one code line
sqlplus -s $dbstring @/usr/local/bin/sched/nightly_Cronjob/exec_123.sql >> /usr/local/bin/sched/nightly_Cronjob/result.txt
but it is not working .
database : Oracle
so please advice me how can i... (7 Replies)
Hi,
I am trying to create a text file from data retrieved from a query.The data retrieved is having this character '^L' at regular intervals of the data.
How can i eliminate this, Please find below the sample data.
I tried sed -e "s/\^L//g" to convert it, but with no luck
^LCODE*SERIAL... (11 Replies)
hey , i am using this code to store value of a sql query and and then use
it in other query but after some time , but it is not working. please help
#!/bin/bash
val_1=$( sqlplus -s rte/rted2@rel76d2 << EOF
setting heading off
select max(stat_id) from cvt_stats;
exit
EOF
)
nohup... (5 Replies)
Hi,
I have a query regarding execution of a sql query having long listing of parameters ..I need to execute this query inside a shell script.
The scenario is like....
Suppose I have a file abc.txt that has the card numbers..it could be in thousands..
then I need to fire a query like
... (12 Replies)
Hi Frndz,
I have req in which i need to run the query stored in some file and then store the resultset of the query in some other file.
PFB the code i have written:
#----Start job log---
SQLLOG='/opt/app/vertica2/cdr_dev/logs/conn_orac_db.log'
ORA_USER='abc'
ORA_PASSWD='xyz'
... (7 Replies)
I have a script in which i connect to database to run a query and get the result of the query to a temp file. This works fine , now what i want is there is flat file which contains the value to be used in the query. I want to read this file line by line and then run the query for each value in that... (7 Replies)
I have tried executing one particular query through perl.But I am unable to get the result. When I tried to execute the sysdate query its working when I executed my perl code.
The below query doesn't work.
QUERY 1:my $sql ="select name from tab where rownum <6";
Received ora error... (23 Replies)
Dear community,
please help with a query on Oracle. I'm using SQLPlus (but with SQLDeveloper is the same) to accamplish a sinple query like:
select count(*) from ARCHIT_D_TB where (TYP_ID=22 OR TYP_ID=23) and SUB_TM like '%SEP%' and CONS=1234This is a very simple query that works perfect until... (5 Replies)
Hello Friends,
I am using check_mysql_query plugin in nagios to query database and get output. query is working fine but output which i am getting contain query. I want to remove query from output and give custom message which will be simple and understandable.
Can you help me here with any... (5 Replies)