Using PHP, how can I spawn a process and execute non-PHP code
off the console?
--Matthew
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL
You have the wrong list.
http://www.mysql.com/documentation/lists.html
-Original Message-
From: Jonathan Hilgeman [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, November 20, 2001 2:56 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] MySQL Restarting A LOT
Okay, this is beginning to bug. I
of it's current function when done doing those things?
This is a pretty disasterous inability, not recognizing code blocks.
--Matthew
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list
You can system()/exec()/passthru() and run rundll32 on the library,
can't you?
-Original Message-
From: James Moore [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 09, 2001 12:34 PM
To: Alain Samoun; GRI
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED];
[EMAIL PROTECTED]; [EMAIL PROTECTED]
You are overwriting the first row.
$result = mysql_query(SELECT clubac.id AS clubacid, clubac.club_id,
clubac.ac_year, clubac.ac_type, club.id
FROM clubac, club WHERE club.id = '$club_id' AND clubac.club_id =
club.id);
if(mysql_num_rows())
while ($row = mysql_fetch_array($result)
is there any to write columns first but still call fields with headers?
as writing in a table would not allow keeping tr tags open
ie.
echocol[1];
echocol[2];
array_flip do the job?
but how?
Sean
Matthew Loff [EMAIL PROTECTED] wrote in message
005c01c163e0$5716ca20$0ce60281@bang"
?php
/*
Hi,
I'm new to PHP and am having trouble understanding how to use PHP
sessions. My book tells in near the beginning how to start them and register
session variables, but I can't figure out how to destroy a session or later
read those session variables. I'm also trying to do this
If you use the at symbol to supress the error message from being
printed, the if() statement will still recognize an error has
occurred... So, try this:
if (@mail($email,$subject_confirm_account, $message_confirm_account,
$from_confirm_account)) {
Dates in MSSQL are stored as:
mon dd hh:miAM (or PM)
and ODBC converts them to:
-mm-dd hh:mi:ss.mmm(24h)
so:
select * from Internetlog where convert(varchar, LogTime, 121) like
'%2001-10-02%'
-Original Message-
From: Matthew DeChant [mailto:[EMAIL PROTECTED]]
Sent: Monday
Without spaces, the URL won't line break...
I recommend one of two things...
1) Use a for() or while() loop with substr(), to print out, say, 50
characters per line, then break to the next line, until reaching the end
of the string...
2) Use an ellipsis (...) to cut out the middle of the URL
Hello,
I am having trouble getting data from a DATETIME field in MSSQL 7.0.
The data in a general select query look like this:
2001-09-25 14:23:17.000
I can do this in MSSQL:
select * from INTERNETLOG where Datetime like %2001%
but not this:
select * from INTERNETLOG where Datetime like
ASP list members will tell you ASP is better/easier for this, PHP list
members will tell you PHP is better/easier for this.
You're asking a pretty loaded question...
I, personally, believe that PHP is much better/easier, but I learned PHP
coming from a C/C++ background.. If you have done
: Matthew Loff [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 01, 2001 10:11 PM
To: 'Radith'; '[EMAIL PROTECTED]'
Subject: RE: [PHP-DB] Newbie But Urgent
ASP list members will tell you ASP is better/easier for this, PHP list
members will tell you PHP is better/easier for this.
You're asking
PostgreSQL does row-level locking... But I'm more familiar with MySQL,
as I presume you are...
If you want to rely on MySQL's table locking, but are worried about a
user aborting the script, see:
http://www.php.net/manual/en/ref.misc.php
A combination of ignore_user_abort() and
There should -not- be a semicolon at the end of the SQL query when using
mysql_query() through PHP...
http://www.php.net/manual/en/function.mysql-query.php
The problem lies elsewhere.
-Original Message-
From: Vera Algoet [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 17, 2001
You'll have to take care of the recursive directory walking function...
Here's code I found to get the ID3 tag from an MP3 file:
http://px.sklar.com/code.html?code_id=429
--Matt
-Original Message-
From: pjc [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 17, 2001 12:13 AM
To:
This has been covered countless times on the list... :)
http://www.php.net/manual/en/function.mysql-insert-id.php
-Original Message-
From: Grant Boggs [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 22, 2001 7:24 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Getting key of row just
strftime(format, strtotime($database_time_string));
format is defined in the page for strftime(). strtotime() converts
the MySQL date into a UNIX timestamp.
-Original Message-
From: Caleb Walker [mailto:[EMAIL PROTECTED]]
Sent: Saturday, August 18, 2001 4:06 PM
To: [EMAIL PROTECTED]
Certainly not in the PHP manual, and LIKE isn't really covered in the
MySQL manual either...
Here's a good page with an intro to SQL queries:
http://developer.ecorp.net/sqltut.htm
--Matt
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 25,
Good call, Paul...
I checked through the manual briefly to see if LIKE was in there, I
guess I missed that page.
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 25, 2001 5:08 PM
To: Matthew Loff; [EMAIL PROTECTED]; 'PHP DataBase-List'
Subject
Whats wrong with this?? Its not working...
Search.php
?php include(search_bool.inc); ?
?php
$connection = mysql_connect($host,$dbusername,$dbpassword) or die
(Cannot connect to server.);
$db = mysql_select_db($dbname, $connection) or die (Could not select
database.);
$sqlstring = SELECT
In Oracle, the syntax for a theta-style join (the one you're describing)
is:
SELECT ...
FROM ...
WHERE item1 (+) = item2
However, MySQL doesn't support this syntax. The only way to do left
(outer) joins in mysql is the way you described:
SELECT ...
FROM ...
LEFT JOIN ... ON ... = ...
The body of the response is the data that the
http://www.site.com/MovieResponder.php script would produce.
The fread() call that I meantioned before would read -all- of this data
into a variable.
-Original Message-
From: Ken Sommers [mailto:[EMAIL PROTECTED]]
Sent: Monday, July
1977
Movie Three 1977
Easy as that! It's a very simple concept.
-Original Message-
From: Ken Sommers [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 16, 2001 4:04 PM
To: Matthew Loff; 'PHP DB Mailing List'
Subject: Re: [PHP-DB] the body of the response
thanks for response,
I am curious
the output of http://snaps.php.net/.
Good luck!
--Matt
-Original Message-
From: Ken Sommers [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 16, 2001 4:50 PM
To: Matthew Loff; 'PHP DB Mailing List'
Subject: Re: [PHP-DB] the body of the response
MR.Loff,
I see the concept.. but i still don;t
with PHP-- I'm sure others on the list could make some great
recommendations.
--Matt
-Original Message-
From: Ken Sommers [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 16, 2001 5:17 PM
To: Matthew Loff; 'PHP DB Mailing List'
Subject: Re: [PHP-DB] the body of the response
I looked up Output
are you saying that i can grab the output of your echo() statements in
YOUR PHP script by Fopen()ing your URL in MY script and then Fread()ing
that resulting file pointer?
--Yes! That's -exactly- what I've been trying to explain. :)
That's the -best- way I can think of retrieving the info
The mysql_connect() function accepts a host name, which can be the
internet address of another machine! However-- the MySQL database on
that machine has to be set up to allow outside connections for whatever
particular username/password you are using!
Please see these pages to answer your
Message-
From: Ken Sommers [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 16, 2001 6:56 PM
To: Matthew Loff; 'PHP DB Mailing List'
Subject: Re: [PHP-DB] remote database exchange
Suppose I Need to get Vendor prices from a very large remote (Oracle)
price list . They probably don't have PHP installed
I am not familiar with Oracle, but by looking through the PHP docs, it
appears that you can't connect remotely to an Oracle server...
Am I wrong about this, or is it a limitation of the Oracle library, or
is Oracle not built to allow remote connections?
-Original Message-
From: CC
Even if a PHP host doesn't have all the DBMS extensions you need, you
could compile them and load them yourself with dl()
http://www.php.net/manual/en/function.dl.php
I thought you might want to keep that in mind, in case one particular
host has a great price but not all the features you
in:
if(!extension_loaded(mysql)) dl(mysql.so);
That's assuming that the mysql ext. is named mysql.so in a compiled
state, of course.
-Original Message-
From: Ken Sommers [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 16, 2001 9:26 PM
To: Matthew Loff; 'PHP DB Mailing List'
Subject: Re: [PHP-DB] php/mysql
modules is another story-- I'm not quite sure
how to. Can anyone else help?
-Original Message-
From: Ken Sommers [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 16, 2001 10:18 PM
To: Ken Sommers; Matthew Loff; 'PHP DB Mailing List'
Subject: Re: [PHP-DB] php/mysql/unix-Linux hosting with major
[mailto:[EMAIL PROTECTED]]
Sent: Monday, July 16, 2001 11:45 PM
To: Matthew Loff; 'PHP DB Mailing List'
Subject: Re: [PHP-DB] php/mysql/unix-Linux hosting with major DBMS
support?
thanks Mat,
I found this FAQ:
When I try to connect to mysql from php I get this error: Call to
unsupported
. mysql.so) that you need... I'd check for .rpm
files...
-Original Message-
From: Ken Sommers [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 17, 2001 12:43 AM
To: Matthew Loff; 'PHP DB Mailing List'
Subject: Re: [PHP-DB] php/mysql/unix-Linux hosting with major DBMS
support?
I think and hope
It might help us to see exactly what the query is...
Could you insert an echo statement and let us know what SQL query it's
producing?
echo
INSERT INTO News
(NewsDate,NewsTitle,NewsText)
VALUES
('$NowDate','$NewsTitle','$NewsText')
;
-Original Message-
From: AKA Hook
PROTECTED]]
Sent: Sunday, July 15, 2001 3:56 PM
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] PLEASE HELP! Problem with ODBC string insert
Here is the echo output.
UPDATE News SET NewsTitle = 'Text',
NewsText = 'can\'t use quotes!' WHERE NewsID = 16
Matthew Loff [EMAIL PROTECTED] wrote in message
Ken--
If you have access to that server with the SQL database... Then instead
of creating an additional PHP script on the SQL server... Could you
simply add a username/password that was allowed to access that
particular database (read-only, of course) remotely?
If that isn't an option,
and
double but nothing has worked.
There HAS to be an answer out there! Do certain SQL statements just not
work in PHP / Access? Is this a bug in Access or PHP?
If I can't get this to work then I won't be able to use PHP for this
site! Someone please shed some light on this!
Matthew Loff [EMAIL
]]
Sent: Monday, July 16, 2001 1:40 AM
To: Matthew Loff; 'PHP DB Mailing List'
Subject: Re: [PHP-DB] relay response transactions between PHP scripts on
different servers
Here's the part that confuses me:
How does MovieResponder.php on your site get the results back to my site
and back to the browser
Brad--
I see what you're trying to do. Here's how this issue with a site I
did, perhaps this will help:
Eliminate the database of images all together. Create an image that
says No Picture Available, and save it as /images/no_photo.jpg.
When (if) a user uploads a file, have it rename the file
I'm assuiming this means you're pulling the name from the DB and putting
it as the value of a text input, as in:
INPUT TYPE=TEXT NAME=name VALUE=$name
The quotes should fix that problem.
-Original Message-
From: Christopher Hebert [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July
What about...
SELECT WLPbib.bibID,
WLPbib.title,
WLPbib.publisher,
WLPbib.publicationDate,
WLPaddress.city,
WLPaddress.state,
WLPprofile.firstName,
WLPprofile.lastName,
WLPprofile.organization,
WLPcountry.languageName
FROM
To: Matthew Loff
Cc: 'Dobromir Velev'; [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Left Join is producing duplicate results - MySQL
relational tables
Hi Matthew,
Matthew Loff wrote:
What about...
SELECT WLPbib.bibID,
WLPbib.title,
WLPbib.publisher
I think he just means a hypertext anchor, that contains a string
identifying the record.
A HREF=fun.php?id=$id
-Original Message-
From: Ken Sommers [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 12, 2001 11:27 PM
To: Rankin, Randy; [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Escaping
Everyone suggesting Easy! Just install Mysql! makes me laugh... :)
Jeff-- I suggest you check:
1) http://www.hotscripts.com/
2) http://www.zend.com/
3) http://www.sourceforge.com/
4) http://www.mysql.com/ (Just kidding!)
Any shopping cart that uses ODBC should work just fine-- and moreso,
You aren't calling mysql_query() to execute the query.
//$find is text box input
$wordsarray = explode( ,$find);
$sql = SELECT bandname FROM bands WHERE (bandname
LIKE ;
$i = 0;
while ($i count($wordsarray))
{
$word = current($wordsarray);
next($wordsarray);
$sql=$sql.$word);
The code you're referencing is my modification of his original post. :)
-Original Message-
From: Ben Bleything [mailto:[EMAIL PROTECTED]]
Sent: Sunday, July 08, 2001 8:04 PM
To: 'Matthew Loff'; 'Mark Gordon'; [EMAIL PROTECTED]
Subject: RE: [PHP-DB] Dynamic SQL + result resource error
To: 'Matthew Loff'; 'Mark Gordon'; [EMAIL PROTECTED]
Subject: RE: [PHP-DB] Dynamic SQL + result resource error
Guess I'm just a big dumbass then, aren't I =P
Oops.
I suppose that would cause it to fail then, wouldn't it?
= Ben
-Original Message-
From: Matthew Loff [mailto:[EMAIL
I really need help here. What I am trying to do is the following.
-
$today = date(m.d.y);
$time = date(g:i a);
if($row[3] == $today){
if(($row[4] $time) and ($time $row[6])){
print(Now Showing);
} else {
print(Today at $row[4]);
}
}
when you say an error - do you mean any error?
or specific errors? ie., you're not getting it stuck in an infinite loop?
(cpu time flips up to that when you stick in a loop)
or is it all errors?
PHPFAN [EMAIL PROTECTED] wrote in message
9eetk0$92d$[EMAIL PROTECTED]">news:9eetk0$92d$[EMAIL
try looking at the fseek function, i think that does what you want:
http://uk.php.net/manual/en/function.fseek.php
John Starkey [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
Hello all.
I'm trying to set up a quick find and replace script. It's finding, and
it (although
the execute flag is turned off, AND the filename is difficult to get.. ) and
would like to reduce the possiblity..
any suggestions?
--
matthew knight - online developer
[EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED
Does anyone know how I can move tables from one database to another using
phpmyadmin?
Please help, thanks!
_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
--
PHP Database Mailing List
I am setting up an episode guide for one of my favourite shows and with this
I need to include three screenshots:
episodeID_a.jpg
episodeID_b.jpg
episodeID_c.jpg
In some cases though the files will not exist and therefore I need too check
if they exist and if they don't then it will display a
Why isn't this working?
?php
$img[] = "$episodeID_a.jpg";
$img[] = "$episodeID_b.jpg";
$img[] = "$episodeID_c.jpg";
for ($x=0; $xcount($img); $x++) {
if(!file_exists($img[$x])) {
print("td align=centerimg src=\"blank.gif\" width=160 height=120
border=\"1\"/td");
} else {
Is there anyway of reducing bad gateway errors on my mysql messageboard,
members are starting to get really irritated by it?
_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
--
PHP Database
How do I get my select form to select a value for $num_view and refesh the
page?
SELECT * FROM table_name ORDER BY n_id DESC LIMIT $num_view
I now need a dropdown box that has set values for 5,10,15 and 20 so that the
user can select a number of news articles to view and it will refresh the
From: Ben Cairns [EMAIL PROTECTED]
To: php-db [EMAIL PROTECTED]
Subject: RE: [PHP-DB] Drop down box
Date: Thu, 1 Mar 2001 14:06:21 +
Hope this helps
-- Ben Cairns - Head Of Technical Operations
intasept.COM
Tel: 01332 365333
Fax: 01332 346010
E-Mail: [EMAIL PROTECTED]
Web:
I have a homepage which has a news headline system. Bascially via form the
admin of the site can submit news which appears on the front page, the only
problem is the news just keeps coming and I have a front page with too many
headlines on.
How can I make it so that say 7 articles appear on
I am lookign for a piece of code that will detect the resolution of the user
and return a page dependant on that i.e - The table will be adjusted to suit
that.
Is there a script where I can detect what the resolution is, and also
redirect to a page depending on what resolution they are using?
Why not just create a table that will resize to any resolution?
Because I am using different sized images for the different resolutions as
well as other page thingys.
And I need the script for other things too.
So can anyone help?
Sorry for putting three topics in one but they all go together so I thought
I would.
I am setting up a user login/members area!
* Firstly how do I generate a random password?
* Then how do I email it to the user?
* And now I need to know how to set a cookie with their username and
password
Thanks!
Is there anyone who can actually give me little bits of code that I need
cause I am in a rush with this
_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
--
PHP Database Mailing
I have set up a database so that users can submit news to my website. The
only problem is they input their news article into the database through a
form but it comes out as a continuous string of text.
(a) shows what it looks like now, and (b) shows how its supposed to look.
How can they
Where exactly do I need to insert this?
_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For
201 - 266 of 266 matches
Mail list logo