I can test for one parameter but anything more then that and I get an Error.
I forgot I run this batch in a shell
#!/bin/sh
-------------------------------------------------------------------------
Write a batch program that accepts a keyword as a parameter and finds all the files... (3 Replies)
I have a script that needs to check if the given parameters are a combination of 0123456789 and not a word or another irelevant character.please help (6 Replies)
I have a script which take 3 input parameters
1st - a date (i.e. current date)
2nd - type (i.e. A)
3rd - limit (i.e. 40)
normally the date parameter would be current date, so I thought I could do this
calculate.sh $(date +%Y-%m-%d) A 40
however, it seems like it can't be done,... (3 Replies)
Hello all, Can anyone tell me the command line I can use to look at the following Kernel parameters:
nfile
maxfile
maxfile_lim
I'm using the Reflection manager connection to my Unix box so I can't use SAM. (3 Replies)
i'm supposed to come up with a script that
-accepts a directory as an optional command line parameter
-display an error message and terminates if more than one parameter is provided
-use the current directory if no parameter is provided
-displays an error message and terminates if the provided... (4 Replies)
Hello,
On Aix 5.2, we changed the parameters tcp_keepinit, tcp_keepintvl and tcp_keepidle with the no command.
tunrestore -R is present in inittab
in the directory /etc/tunables we can clearly see the inclusion of parameters during reboot, including the file lastboot.log
... (0 Replies)
Can someone help me of doing something like this
send.sh
#!/bin/bash
for last; do true; done
echo $* | gammu sendsms TEXT $last
every thing is good except that when i launch the script like this
./send.sh This is the message i want to send +63922XXXXXXX
it turned out the message of... (2 Replies)
Hi,
on AIX 6.1
I have a shell script that calls another shell which have some parameters. Say like the following :
##This is main script############
myparameters.sh
command1
command2
.....
....
And here myparameteres.sh :
export ORACLE_SID=MYDB
export... (6 Replies)
Hi,
I have 2 scripts one master.sh and child.sh. The master runs on a separate server and pushes the child script to the desginated server and runs it.The child script configures the designated server for our day to day use and it has lot of interactive questions which help the... (4 Replies)
Discussion started by: a12ka4
4 Replies
LEARN ABOUT PHP
mysqli_stmt_execute
MYSQLI_STMT_EXECUTE(3) 1 MYSQLI_STMT_EXECUTE(3)mysqli_stmt::execute - Executes a prepared Query
Object oriented style
SYNOPSIS
bool mysqli_stmt::execute (void )
DESCRIPTION
Procedural style
bool mysqli_stmt_execute (mysqli_stmt $stmt)
Executes a query that has been previously prepared using the mysqli_prepare(3) function. When executed any parameter markers which exist
will automatically be replaced with the appropriate data.
If the statement is UPDATE, DELETE, or INSERT, the total number of affected rows can be determined by using the
mysqli_stmt_affected_rows(3) function. Likewise, if the query yields a result set the mysqli_stmt_fetch(3) function is used.
Note
When using mysqli_stmt_execute(3), the mysqli_stmt_fetch(3) function must be used to fetch the data prior to performing any addi-
tional queries.
PARAMETERS
o $
stmt -Procedural style only: A statement identifier returned by mysqli_stmt_init(3).
RETURN VALUES
Returns TRUE on success or FALSE on failure.
EXAMPLES
Example #1
Object oriented style
<?php
$mysqli = new mysqli("localhost", "my_user", "my_password", "world");
/* check connection */
if (mysqli_connect_errno()) {
printf("Connect failed: %s
", mysqli_connect_error());
exit();
}
$mysqli->query("CREATE TABLE myCity LIKE City");
/* Prepare an insert statement */
$query = "INSERT INTO myCity (Name, CountryCode, District) VALUES (?,?,?)";
$stmt = $mysqli->prepare($query);
$stmt->bind_param("sss", $val1, $val2, $val3);
$val1 = 'Stuttgart';
$val2 = 'DEU';
$val3 = 'Baden-Wuerttemberg';
/* Execute the statement */
$stmt->execute();
$val1 = 'Bordeaux';
$val2 = 'FRA';
$val3 = 'Aquitaine';
/* Execute the statement */
$stmt->execute();
/* close statement */
$stmt->close();
/* retrieve all rows from myCity */
$query = "SELECT Name, CountryCode, District FROM myCity";
if ($result = $mysqli->query($query)) {
while ($row = $result->fetch_row()) {
printf("%s (%s,%s)
", $row[0], $row[1], $row[2]);
}
/* free result set */
$result->close();
}
/* remove table */
$mysqli->query("DROP TABLE myCity");
/* close connection */
$mysqli->close();
?>
Example #2
Procedural style
<?php
$link = mysqli_connect("localhost", "my_user", "my_password", "world");
/* check connection */
if (mysqli_connect_errno()) {
printf("Connect failed: %s
", mysqli_connect_error());
exit();
}
mysqli_query($link, "CREATE TABLE myCity LIKE City");
/* Prepare an insert statement */
$query = "INSERT INTO myCity (Name, CountryCode, District) VALUES (?,?,?)";
$stmt = mysqli_prepare($link, $query);
mysqli_stmt_bind_param($stmt, "sss", $val1, $val2, $val3);
$val1 = 'Stuttgart';
$val2 = 'DEU';
$val3 = 'Baden-Wuerttemberg';
/* Execute the statement */
mysqli_stmt_execute($stmt);
$val1 = 'Bordeaux';
$val2 = 'FRA';
$val3 = 'Aquitaine';
/* Execute the statement */
mysqli_stmt_execute($stmt);
/* close statement */
mysqli_stmt_close($stmt);
/* retrieve all rows from myCity */
$query = "SELECT Name, CountryCode, District FROM myCity";
if ($result = mysqli_query($link, $query)) {
while ($row = mysqli_fetch_row($result)) {
printf("%s (%s,%s)
", $row[0], $row[1], $row[2]);
}
/* free result set */
mysqli_free_result($result);
}
/* remove table */
mysqli_query($link, "DROP TABLE myCity");
/* close connection */
mysqli_close($link);
?>
The above examples will output:
Stuttgart (DEU,Baden-Wuerttemberg)
Bordeaux (FRA,Aquitaine)
SEE ALSO mysqli_prepare(3), mysqli_stmt_bind_param(3), mysqli_stmt_get_result(3).
PHP Documentation Group MYSQLI_STMT_EXECUTE(3)