You want to default to YES, although I would personally do it the other way and force the user to enter a 'Y or y'.
However how about using the _wildcard_ '*'...
(On CygWin at the moment and don't have ksh available so using sh instead...)
Results on CygWin...
Hello,
I am writing a script in ksh(for HP Unix)where a user must answer to a question . So I want to know kow to test if the user do not answer , so if he enter "REturn".
I don't know how to test "space characters" or "empty characters
Thanks for your help (2 Replies)
Wondering what this line meant, especially the 2>&1 and ${RUN_DIR} parts:
${RUN_DIR}/<filename> 2>&1
Where <filename> is the location and name of a file. (1 Reply)
i want to add about 60 printers using a ksh script.
i am having trouble though, i am reading the input from the hosts file and using the lpadmin command to add like so:
lpadmin -p -v /dev/null -m netstandard -o dest=
i want printername and ipaddy to come from the hosts file, i am having... (1 Reply)
Hi Folks,
I would just like to know how recursion works in ksh or inside a shell in general. I created the following script, but it works(runs recursively) only for 64 times:
----------------
#! /usr/bin/ksh
displaymessage()
{
echo "displaying count: $cnt "
echo "wait for 1 second..."... (1 Reply)
Hi,
I am looking at a script, and it contains lines like:
if ]
...
This is getting me confused. Why do we need $ before (echo $* | egrep -c 'DG')? Why can't we simply have:
if ]
... i.e. no $ here before the ()...
Thanks.
J (3 Replies)
Hello,
I wanted to setup user friendly ksh command prompt, by typing first character of files or directories and then tab bring up whole word. No need to type whole file/directory/command names.
Example:
cat a file like university
just typing un and then tab bring up whole university wod.... (3 Replies)
Hi All,
This is an embarrassingly simple question and couldn't think of "keywords" to search for the answer, but how do I change my UNIX/KSH prompt to show the machine name and my "current" but not "full" directory?
For example: if the machine name is "machine" and I'm currently in... (4 Replies)
Hi all,
The below command tries to copy ".tgz" instead of "hello_test.tgz" -- It seems as if the underscore gets in the way. I tried with different ways of using quotes, with no luck, unfortunately...it's probably very simple, but may I ask how this would be done:
How would the below be... (3 Replies)
Discussion started by: chatguy
3 Replies
LEARN ABOUT PHP
sqlite_exec
SQLITE_EXEC(3)SQLITE_EXEC(3)sqlite_exec - Executes a result-less query against a given databaseSYNOPSIS
bool sqlite_exec (resource $dbhandle, string $query, [string &$error_msg])
DESCRIPTION
bool sqlite_exec (string $query, resource $dbhandle)
Object oriented style (method): bool SQLiteDatabase::queryExec (string $query, [string &$error_msg])
Executes an SQL statement given by the $query against a given database handle (specified by the $dbhandle parameter).
Warning
SQLite will execute multiple queries separated by semicolons, so you can use it to execute a batch of SQL that you have loaded from
a file or have embedded in a script.
PARAMETERS
o $dbhandle
- The SQLite Database resource; returned from sqlite_open(3) when used procedurally. This parameter is not required when using the
object-oriented method.
o $query
- The query to be executed. Data inside the query should be properly escaped.
o $error_msg
- The specified variable will be filled if an error occurs. This is specially important because SQL syntax errors can't be fetched
using the sqlite_last_error(3) function.
Note
Two alternative syntaxes are supported for compatibility with other database extensions (such as MySQL). The preferred form is the
first, where the $dbhandle parameter is the first parameter to the function.
RETURN VALUES
This function will return a boolean result; TRUE for success or FALSE for failure. If you need to run a query that returns rows, see
sqlite_query(3).
The column names returned by SQLITE_ASSOC and SQLITE_BOTH will be case-folded according to the value of the sqlite.assoc_case configuration
option.
CHANGELOG
+--------+---------------------------------+
|Version | |
| | |
| | Description |
| | |
+--------+---------------------------------+
| 5.1.0 | |
| | |
| | Added the $error_msg parameter |
| | |
+--------+---------------------------------+
EXAMPLES
Example #1
Procedural example
<?php
$dbhandle = sqlite_open('mysqlitedb');
$query = sqlite_exec($dbhandle, "UPDATE users SET email='jDoe@example.com' WHERE username='jDoe'", $error);
if (!$query) {
exit("Error in query: '$error'");
} else {
echo 'Number of rows modified: ', sqlite_changes($dbhandle);
}
?>
Example #2
Object-oriented example
<?php
$dbhandle = new SQLiteDatabase('mysqlitedb');
$query = $dbhandle->queryExec("UPDATE users SET email='jDoe@example.com' WHERE username='jDoe'", $error);
if (!$query) {
exit("Error in query: '$error'");
} else {
echo 'Number of rows modified: ', $dbhandle->changes();
}
?>
SEE ALSO sqlite_query(3), sqlite_unbuffered_query(3), sqlite_array_query(3).
PHP Documentation Group SQLITE_EXEC(3)