07-05-2005
Quote:
Originally Posted by d11wtq
I strongly advise you use PHP. It's much easier to work with if you use SAPI on your web server.
I can help you with this if you need (I made a similar script myself...).
I would not mind taking a look at your script if you are willing to share. I will discuss it with the web server admin. Many Thanks for the offer.
7 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Am trying to learn a scripting language to automate mundane system admin tasks. Being a Novice, Just trying to understand, which language would be easier to learn and one for all types.
i.e Perl or Shell scripting. Which of these would be good for a system admin, Database admin ??
pls. post... (2 Replies)
Discussion started by: Crazy_murli
2 Replies
2. Shell Programming and Scripting
I do not know UNIX shell scripting so as an alternative which language would you think is better for daily System Administration tasks. Perl or PHP? I know a little about both. (5 Replies)
Discussion started by: blackopus
5 Replies
3. What is on Your Mind?
:confused:perl,python,ruby..which one is the best language...?
all are welcomed to comment but i would request to the SYSTEM ADMINISTRATORS who have yaers of programming,scripting experience to comment...site admins plz i am looking forward to see your comments also ...:):) (3 Replies)
Discussion started by: shekhar_4_u
3 Replies
4. Ubuntu
Is there any way to create an SMTP mail server will all granular permissions to it so that I can read emails which that server receives through any scripting language and also reply from the same server automatically? (3 Replies)
Discussion started by: sandeepcm
3 Replies
5. Shell Programming and Scripting
hi
i am student and i learn computer sciences
i need to write a script that can will be execute automatically when a user logs on a computer, and will be automatically disconnect after a duration that i will determine
can somebody help me
thank (1 Reply)
Discussion started by: Thucydide
1 Replies
6. Shell Programming and Scripting
Hello,
I want to know which shell scripting language (like AWk, Perl or any other) is the best for parsing and editing
1) space or Comma Separated Datsets
2) XML type Datasets. (1 Reply)
Discussion started by: ajayram
1 Replies
7. UNIX for Dummies Questions & Answers
Hi everyone ,
Can anyone tell me which is the Best scripting language for Aix/unix and why.
Thanks
N K Chand (1 Reply)
Discussion started by: nkchand
1 Replies
LEARN ABOUT PHP
sqlite_popen
SQLITE_POPEN(3) SQLITE_POPEN(3)
sqlite_popen - Opens a persistent handle to an SQLite database and create the database if it does not exist
SYNOPSIS
resource sqlite_popen (string $filename, [int $mode = 0666], [string &$error_message])
DESCRIPTION
This function behaves identically to sqlite_open(3) except that is uses the persistent resource mechanism of PHP. For information about
the meaning of the parameters, read the sqlite_open(3) manual page.
sqlite_popen(3) will first check to see if a persistent handle has already been opened for the given $filename. If it finds one, it returns
that handle to your script, otherwise it opens a fresh handle to the database.
The benefit of this approach is that you don't incur the performance cost of re-reading the database and index schema on each page hit
served by persistent web server SAPI's (any SAPI except for regular CGI or CLI).
Note
If you use persistent handles and have the database updated by a background process (perhaps via a crontab), and that process re-
creates the database by overwriting it (either by unlinking and rebuilding, or moving the updated version to replace the current
version), you may experience undefined behaviour when a persistent handle on the old version of the database is recycled.
To avoid this situation, have your background processes open the same database file and perform their updates in a transaction.
PARAMETERS
o $filename
- The filename of the SQLite database. If the file does not exist, SQLite will attempt to create it. PHP must have write permis-
sions to the file if data is inserted, the database schema is modified or to create the database if it does not exist.
o $mode
- The mode of the file. Intended to be used to open the database in read-only mode. Presently, this parameter is ignored by the
sqlite library. The default value for mode is the octal value 0666 and this is the recommended value.
o $error_message
- Passed by reference and is set to hold a descriptive error message explaining why the database could not be opened if there was
an error.
RETURN VALUES
Returns a resource (database handle) on success, FALSE on error.
SEE ALSO
sqlite_open(3), sqlite_close(3), sqlite_factory(3).
PHP Documentation Group SQLITE_POPEN(3)