06-19-2007
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
i have a script, which is continuously looping. i want to view the script name when i use ps command... it is only showing -sh ...
UID PID PPID C STIME TTY TIME COMMAND
informix 8533 20923 0 18:19:28 pts/ta 0:00 -sh
but i dont have my scriptname displayed .... how can i do that my script is... (0 Replies)
Discussion started by: guhas
0 Replies
2. Shell Programming and Scripting
Ok I admit it I am stumped and I would appreciate any and all help
Here is what I am trying to do.
Korn Shell script
I am setting a variable to another shell script that I want to invoke in my main script like so:
GETDIR=/vol100/cfg/.getdir
The .getdir shell script take a parameter,... (4 Replies)
Discussion started by: Batch
4 Replies
3. Shell Programming and Scripting
hi i want solution regarding usage of array. i m having code which is written using if-
elif and can i use or access using arrays.
here i wana use array values along with if -elif condition. i dnt wana use command line argument
parameter1=(scram no_scram)
if ; then
... (0 Replies)
Discussion started by: manish1
0 Replies
4. Windows & DOS: Issues & Discussions
Hi, Please accept my apologies if I have not explained anything clearly enough but i am a little old on new lingo!!!
I am running XP from home and last night the following happened.
After being logged on for pretty much the full day, I had what seemed like a pop up come up. Although most pop... (3 Replies)
Discussion started by: nike1601
3 Replies
5. UNIX for Advanced & Expert Users
--------------------------------------------------------------------------------
hy guys,
i got few interview questions i need someone to answer urgently:
1)If you cant get to the root, you try to fsck it, but gets errors to read file systems. What steps do you take to recover the host... (1 Reply)
Discussion started by: charneet
1 Replies
6. Shell Programming and Scripting
Hi,
Below is my issue which I desperately need and I want a shell script which can do this job.
I need this script as I m planning to put this for a system health check. Please assist me.
1. There are 10 log files in a particular location.
2. open each log file. Goto to the end of the... (1 Reply)
Discussion started by: kashriram
1 Replies
7. UNIX for Dummies Questions & Answers
Hello Friends,
I am a Graduate in Computers. I completed BCA degree this year. I want to make my career in UNIX. But, unfortunately I don't know anybody who can guide me. I am totally confuse because I don't know where to start and what are the future prospect in UNIX.
Please give your... (4 Replies)
Discussion started by: Luckyless
4 Replies
8. Shell Programming and Scripting
Hi,
I have a directory, where i get 4 files for each day... The files will be generated at any time. I am trying for a shell script for copying the file from this directory whenever new file is generated.
Say for example : If the directory X has following files A1,A2,A3,A4,B1,B2,B3,B4...... (2 Replies)
Discussion started by: krishh.kk
2 Replies
9. Programming
KING KONG ELECTRICITY AUTHORITY
BILL CALCULATOR
You are required to develop a script that will enable KING KONG ELECTRICITY AUTHORITY to
calculate customer bills based on their meter readings.
The customers are categorized into the following categories:
Residential customers
Commercial... (1 Reply)
Discussion started by: watisevil
1 Replies
10. Shell Programming and Scripting
Hi
I want to create a script which deleted files in the following folders older than 30 days. There are a particular version of files inside it to be deleted
Folders :
/files0/interfaces/ResponsysSavedList/BackInStock/EmailContent/backup... (3 Replies)
Discussion started by: Scudza
3 Replies
LEARN ABOUT PHP
sqlite_exec
SQLITE_EXEC(3) SQLITE_EXEC(3)
sqlite_exec - Executes a result-less query against a given database
SYNOPSIS
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)