.
Usually php5 -c php.ini will run PHP in interactive mode, and sits and
waits for input. When run from cron, there is no input, so it dies, unable
to pipe the output (there is none) or just run the next command.
So -- lose the pipe, lose the semicolon, just run the command above in cron
(and on the command l
rows. If not, the problem is NOT with the API's.
I'll save you some time, it's not the where 1 part of the query:
mysql select count(*) from numbers where 3 and num like '1212%';
+--+
| count(*) |
+--+
| 42 |
+--+
Beckman
Beckman Internet Guy
beck...@angryox.com http://www.angryox.com/
---
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http
;
}
Which would output, if $req_user_level was 1 (one):
The user is a Regular User.
Then you know you have a valid user level. Careful though -- sometimes 0
will be returned on a failure, depending on your SQL.
Beckman
library are you using?
---
Peter Beckman Internet Guy
beck...@angryox.com http://www.angryox.com
.
---
Peter Beckman Internet Guy
beck...@angryox.com http://www.angryox.com/
---
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe
out recently :)
or use select min(id) min, max(id) max from mytable
then access as $array['min'] and $array['max']
---
Peter Beckman Internet Guy
[EMAIL PROTECTED
.
---
Peter Beckman Internet Guy
[EMAIL PROTECTED] http://www.purplecow.com/
---
--
PHP Database Mailing List (http
: since MySQL is behaving normally otherwise, I'm
using a host of '%' and my IP isn't changing, does anybody know what the
problem is with PHP???
TIA,
James
flush privileges
---
Peter Beckman
that doesn't exist, but the expected result is a
warning/error, not for PHP to populate an array.
Beckman
---
Peter Beckman Internet Guy
[EMAIL PROTECTED
to populate an array.
we should cross check again.
I don't know what you mean.
---
Peter Beckman Internet Guy
[EMAIL PROTECTED] http
/group. If not, you must change this.
Beckman
On Fri, 12 Jan 2007, [EMAIL PROTECTED] wrote:
Dear All,
I need some help please...
I'm developing an web application using PHP/MySQL, and its has been
running on my company.
I'm planning to migrate the system on a new server.
I have installed
, and 3459 is the largest for fkid 2. green comes before
yellow. My desired result set would be:
fkid foobar
2 3459 green
1 345yellow
How would I write that in SQL? fkid and foo are ints, bar is a varchar.
Beckman
, and 345 should
be yellow but reports red?
Any other solutions that maintain row integrity?
Beckman
Miguel Guirao wrote:
select max(bar) from mytable where unique fkid order by bar asc
as far as I remember!!
-Original Message-
From: Peter Beckman [mailto:[EMAIL PROTECTED]
Sent: Lunes, 13
query and outside of.
Your solution is valid, but not what I'm looking for.
---
Peter Beckman Internet Guy
[EMAIL PROTECTED] http://www.purplecow.com
down the amount and complexity of code. Even
if you disagree with my goal as good computing practices, I simply want to
know if what I ask is possible, and if so, how. :-)
Beckman
---
Peter Beckman
!;
}
---
Peter Beckman Internet Guy
[EMAIL PROTECTED] http://www.purplecow.com/
---
--
PHP Database Mailing List (http://www.php.net
pear install Config
Now you can load a config file like that with a single command, load it
into an array, modify values, then write it back.
http://pear.php.net/package/Config
It is fantastic.
Beckman
On Tue, 14 Mar 2006, Rob W. wrote:
That works, but it just throws it in to a big loop
On Fri, 6 Jan 2006, Neil Smith [MVP, Digital media] wrote:
Peter Beckman wrote:
So I'm thinking about how to save credit card numbers in the DB, for
re-charging cards for subscriptions, new orders, etc.
Yes yes, lawsuits, scary, etc.
I'm glad you're so blase about this and the threat
On Fri, 6 Jan 2006, Dan Baker wrote:
Peter Beckman [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
So I'm thinking about how to save credit card numbers in the DB, for
re-charging cards for subscriptions, new orders, etc.
I'm also thinking about how to save passwords in the DB
some
abstract process in code, or something -- security through obscurity.
Beckman
---
Peter Beckman Internet Guy
[EMAIL PROTECTED] http
On Thu, 5 Jan 2006, John Meyer wrote:
Peter Beckman wrote:
So I'm thinking about how to save credit card numbers in the DB, for
re-charging cards for subscriptions, new orders, etc.
Why, is the first question I would ask you.
So I'm thinking about how to save credit card numbers in the DB
unreversable, and if someone got a hold
of your data AND your code, they could reverse-engineer... It seems
security is only as good as your weakest link -- obscure code, private
key, etc...
Beckman
---
Peter Beckman
was executed.
Was this depreciated, or does it still exist? I can't remember what to
call it, and I can't seem to find the right page in the manual. Any help?
Beckman
---
Peter Beckman
wasn't entirely helpful, they are there for you to enjoy.
Beckman
On Tue, 5 Apr 2005, Peter Beckman wrote:
Back in 2000 I remember there being a file that could be created in the
include path that, if existed, would be called and executed before any
other PHP script was executed. There was also
The biggest problem with oci8 is having these four variables set:
$ORACLE_SID=SOMESID
$ORACLE_HOME=/home/beckman/oracle
$ORACLE_BASE=/home/beckman/oracle
$TNS_ADMIN=/home/beckman/oracle/network/admin
If those aren't set, then things won't work.
Please confirm that those environment variables
://www.php.net/unsub.php
---
Peter Beckman Internet Guy
[EMAIL PROTECTED] http://www.purplecow.com
?
Beckman
---
Peter Beckman Internet Guy
[EMAIL PROTECTED] http://www.purplecow.com
I LOVE FPDF. I don't know where I found it, but I can insert images, it
wraps text -- it's pretty fantastic. Get it.
Beckman
On Mon, 5 Apr 2004, Nathan Mealey wrote:
Has anyone had any experience extracting text from a fulltext
field/column in a MySQL DB and, using the PDFLib library
Change, in the /etc/hosts file, this:
localhost 209.10.33.12# new db server
Hopefully this will work. Haven't tested, just a suggestion. Probably
breaks a few other things, but at least mysql will work.
Beckman
On Thu, 18 Mar 2004, Operator wrote:
Hi everyone,
I need to put my
' AND password=md5('$password'));
---
Peter Beckman Internet Guy
[EMAIL PROTECTED] http://www.purplecow.com
with printing? I would assume that the ideal page size
is not the ideal printed page size. oi vay!
In IE 6, this works:
br style='page-break-after:always;'
Even if your text follows, IE will print a page break. Haven't researched
how to do it in Mozilla or Netscape.
Beckman
['page']+1.'Next/a;
I think. It might need some tweaking, but you get the idea (I hope).
No need to store variables here.
Beckman
-Original Message-
From: Robert Twitty [mailto:[EMAIL PROTECTED]
Sent: Friday, February 13, 2004 12:34 PM
To: Karen Resplendo
Cc: [EMAIL PROTECTED
for that.
---
Peter Beckman Internet Guy
[EMAIL PROTECTED] http://www.purplecow.com/
---
--
PHP Database Mailing List (http
)
---
Peter Beckman Internet Guy
[EMAIL PROTECTED] http://www.purplecow.com/
---
--
PHP Database Mailing List (http://www.php.net
is selecting the correct (most
recent) row in log in which to match the score.
Basically I want a report of AppID, TeamMemberID, log.points, score.score
that shows where points != score;
Thanks,
Beckman
---
Peter Beckman
On Thu, 6 Nov 2003, CPT John W. Holmes wrote:
From: Peter Beckman [EMAIL PROTECTED]
I have this data:
Table Log: appid userid points datetype
Table Score: appid userid score
I want to verify that the last entry in table log of type x is equal to
the sum
in which the sum of the
items matching in the score table does not equal the points in the
selected log entry.
Peter
---
Peter Beckman Internet Guy
[EMAIL PROTECTED
['funds'] contains something like $3,249,555.32, and the end
result is an int of 3249555. I drop the cents... you want to keep 'em,
change int to float.
Beckman
---
Peter Beckman
On Wed, 5 Nov 2003, Aleks @ USA.net wrote:
Great answer... One question though, how would you convert it back to
X,xxx.00 format??
number_format($variable,2);
---
Peter Beckman
Here's my test script:
?php
session_start();
echo session_id();
echo :.isset($HTTP_SESSION_VARS['user']);
print_r($HTTP_SESSION_VARS);
echo hr/Now: .$HTTP_SESSION_VARS['user'];
if (empty($HTTP_SESSION_VARS['user'])) {
$HTTP_SESSION_VARS['user'] = beckman
---
Peter Beckman Internet Guy
[EMAIL PROTECTED] http://www.purplecow.com/
---
--
PHP Database Mailing List (http
=mysql_fetch_assoc($result)
// here goes output
}
---
Peter Beckman Internet Guy
[EMAIL PROTECTED] http://www.purplecow.com
());
$diff = ((float)$l + (float)$r) - (float)$start;
echo hr/fetch_array(): $diff seconds [$num rows]($r.$l : $start)hr/;
Beckman
---
Peter Beckman Internet Guy
[EMAIL PROTECTED
will
fail, as the string will end at the first set of quotes (just after know
).
Beckman
---
Peter Beckman Internet Guy
[EMAIL PROTECTED] http
, no extra variables, no nothing.
Register_Globals is bad -- if you can avoid using it, do so.
Performance-wise, it is better to use single quotes and concat the
variables outside of the quoted line. Better performance, less problems
with variables not being expanded correctly.
Beckman
sentence
when the register_globals was on.
Waste (albeit very minor) of variable space. Concat them.
Beckman
---
Peter Beckman Internet Guy
[EMAIL PROTECTED
.
---
Peter Beckman Internet Guy
[EMAIL PROTECTED] http://www.purplecow.com/
---
--
PHP Database Mailing List (http
!
---
Peter Beckman Internet Guy
[EMAIL PROTECTED] http://www.purplecow.com/
---
--
PHP Database
an array (PHP is now array index 1)
Now just pop them off the array (PHP - Database - end of array)
Beckman
---
Peter Beckman Internet Guy
[EMAIL PROTECTED
$_POST['edit'] isn't set. Maybe you have a
problem in your SQL. Maybe the DB you are connecting to doesn't exist. I
would check your connection as well.
Beckman
---
Peter Beckman
);
$leftover = $leftover%1440;
$seconds = $leftover;
printf(Future Time is %d day%s, %d minute%s, and %d second%s away from
now., $days, $days==1?:s,
$minutes, $minutes==1?:s,
$seconds, $seconds==1?:s);
Beckman
On Mon, 22 Sep 2003, Peter Beckman wrote:
On Mon, 22 Sep 2003, Frank McIsaac wrote:
Hi all. I was wanting to make a page that takes a set date and
counts down to zero displaying days, minutes, and seconds. Basically, I
want it to count down from the current date and time until
mysql_field_flags
et al? Or do I have to rewrite the code entirely to use SHOW FIELDS FROM
DB.TABLE and rewrite my own _field_ functions?
Beckman
---
Peter Beckman Internet Guy
[EMAIL
10 2003 12:08 pm, Peter Beckman wrote:
So PHP is saying mysql_list_tables is depreciated. I replaced it with
mysql_query(SHOW TABLES FROM DB) and everything is fine.
Then mysql_list_fields didn't work right. So I submitted a bug
(http://bugs.php.net/bug.php?id=25460) about
On Wed, 10 Sep 2003, Peter Beckman wrote:
Then mysql_list_fields didn't work right. So I submitted a bug
(http://bugs.php.net/bug.php?id=25460) about it, and they said IT TOO was
depreciated, which is fine. But I haven't figured out how to replace
mysql_list_fields with a nice simple SQL
select * from plate where pid=65;
+-+-+--+-
| pid | plate | year |
+-+-+--+-
| 65 | DVF0343 | 2000 |
+-+-+--+-
2000? What? Why? Confused. PHP or Mysql fault?
Beckman
to read up on it.
Seems a bit obscure; I've been using mysql for 4+ years and have never came
across this.
Thanks,
Beckman
- Original Message -
From: Peter Beckman [EMAIL PROTECTED]
Seems that either I don't understand mysql, or something.
My table, with the non-important things
to
learn what is going on and why when given an empty quoted string MySQL
translates that to 2000 versus the default value (if not null, ; if
null, NULL).
Beckman
---
Peter Beckman
a warning, but
I haven't figured out how to view the warnings (or detect them) in PHP,
much less in MySQL.
Thanks to all who responded -- I wanted to make sure it was a MySQL thing
rather than a PHP thing before I posted on the MySQL lists.
Beckman
database.
Peter
On Fri, 15 Aug 2003, Thomas Deliduka wrote:
Here's the stats:
Two servers:
Server 1, Mysql 4.0.12, PHP 4.3.2, apache 1.3.27
Server 2, Mysql 4.0.14, PHP 4.3.2, apache 1.3.27
---
Peter Beckman
---
Peter Beckman Internet Guy
[EMAIL PROTECTED] http://www.purplecow.com
, and it'd be nice to be able to do it dynamically. If I change a
function name, then I have to change (currently) the string that contains
the function name within that function.
Peter
---
Peter Beckman
.
***
---
Peter Beckman Internet Guy
[EMAIL PROTECTED] http://www.purplecow.com
---
Peter Beckman Internet Guy
[EMAIL PROTECTED] http://www.purplecow.com/
---
--
PHP Database Mailing List (http
'
to be different when printing or viewing it on the screen?
Kind regards,
mark
---
Peter Beckman Internet Guy
[EMAIL PROTECTED] http://www.purplecow.com
.
Mike
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
---
Peter Beckman Internet Guy
[EMAIL PROTECTED
/)
To unsubscribe, visit: http://www.php.net/unsub.php
---
Peter Beckman Internet Guy
[EMAIL PROTECTED] http://www.purplecow.com
is instead returned in raw binary format with a length of 16.
Beckman
On Tue, 24 Jun 2003 [EMAIL PROTECTED] wrote:
Just use brute force...
Example:
md5('password') will ALWAYS produce the same output!
So, if I intercept a pmd5 encrypted password that looks like: SKHGDOIUYFB
then I could just
://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
---
Peter Beckman Internet Guy
[EMAIL PROTECTED] http://www.purplecow.com
(http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
---
Peter Beckman Internet Guy
[EMAIL PROTECTED] http://www.purplecow.com
: http://www.php.net/unsub.php
---
Peter Beckman Internet Guy
[EMAIL PROTECTED] http://www.purplecow.com
My mistake -- I'm wrong here. Through a few emails I learned that it is a
32 character hex value that is returned, not a 32 char alphanumeric. That
reduces my estimate of 63*10^48 to 340*10^36, still more than crypt though.
My bad, sorry to all who believed me without question!
Beckman
On Tue
???
---
Peter Beckman Internet Guy
[EMAIL PROTECTED] http://www.purplecow.com
---
Peter Beckman Internet Guy
[EMAIL PROTECTED] http://www.purplecow.com/
---
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit
so I know for each application, a person is assigned a role. There can be
multiple reviewers, so there is no unique key on these columns.
Any other suggestions?
---
Peter Beckman
/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
---
Peter Beckman
www.becomingdigital.com
---
Peter Beckman Internet Guy
[EMAIL PROTECTED] http://www.purplecow.com
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
---
Peter Beckman Internet Guy
[EMAIL PROTECTED
.
Peter
---
Peter Beckman Internet Guy
[EMAIL PROTECTED] http://www.purplecow.com
/unsub.php
---
Peter Beckman Internet Guy
[EMAIL PROTECTED] http://www.purplecow.com
---
Peter Beckman Internet Guy
[EMAIL PROTECTED] http://www.purplecow.com/
---
--
PHP Database Mailing List (http
entries in
the database. Any ideas out there as to what would cause this kind of
problem?
Nick
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
---
Peter Beckman
Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
---
Peter Beckman Internet Guy
[EMAIL PROTECTED] http
could do this?
Thanks for everything, you are all life savers. Oh and after thinking
about it I realized how dumb storing Credit Card details in a DB were :-)
Chris
---
Peter Beckman
like with 4.3+ you can use the internal functions of PHP to do what
you are asking.
You could alternatively install curl and get the resulting HTTP code.
http://www.php.net/manual/en/ref.curl.php
Peter
---
Peter Beckman
: 6.0.443 / Virus Database: 248 - Release Date: 10/01/2003
---
Peter Beckman Internet Guy
[EMAIL PROTECTED] http://www.purplecow.com
and
conditions expressed in the governing KPMG client engagement
letter.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
---
Peter Beckman
).
I'm not slagging Peter's recommendation. I was thinking this solution
through as well, but was a bit stuck when it came to users just closing
their browsers without logging out.
-Original Message-
From: Peter Beckman [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 03, 2003 2
]
-Original Message-
From: Peter Beckman [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 03, 2003 4:49 PM
To: Hutchins, Richard
Cc: Bernain, Fernando G.; '[EMAIL PROTECTED]'
Subject: RE: [PHP-DB] Users on line
I agree; it'd be nice if there was some sort of code that'd be executed
when someone
that
hops ip addresses (like AOL). Would the session id remain constant,
over the ip hops??
Thanks
Peter Beckman wrote:
Create a new table named online:
id
time (int unix timestamp)
uid (int probably, user ID of user in question, relating to a user info table?)
sessid (char 32 I think
(http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
---
Peter Beckman Internet Guy
[EMAIL PROTECTED] http://www.purplecow.com
Beckman Internet Guy
[EMAIL PROTECTED] http://www.purplecow.com/
---
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http
---
Peter Beckman Internet Guy
[EMAIL PROTECTED] http://www.purplecow.com
);
printf(select name=\coursecode\\n);
while ($myrow = mysql_fetch_array($result)) {
$l=$myrow['coursecode'];
?option value=?=$l;??=($_POST['coursecode']==$l)?'
selected=selected':;??=$myrow['left(title,40)'];?/option?
}
printf(/select\n);
?
on 11/12/02 5:26 pm, Peter Beckman at [EMAIL
---
Peter Beckman Internet Guy
[EMAIL PROTECTED] http://www.purplecow.com/
---
--
PHP Database Mailing List (http
2057
Ph: +61 2 9413 2944 Fax: +61 2 9413 9901
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
---
Peter Beckman
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
---
Peter Beckman Internet Guy
[EMAIL PROTECTED
\;
}
print /;
}
How would I write this to support multiple brackets? Basically it is the
preg_match line that does the magic.
Peter
---
Peter Beckman
---
Peter Beckman Internet Guy
[EMAIL PROTECTED] http://www.purplecow.com
1 - 100 of 176 matches
Mail list logo