p5.
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 comm
is a filtering statement, or a result limiting
statement
2) see if " SELECT . . . WHERE 2" or " SELECT . . . WHERE 3 " yields
respecively 2 or 3 result 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 t
_user_level was not a valid level.
echo "The returned req_user_level was not valid.\n";
}
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. Car
if (in_array($req_user_level, array(0,1,2,3,4,5,6,7,8,9,"Guest",...))) {
// do stuff
}
---
Peter Beckman Internet Guy
beck...@angryox.com http://www.angryox.com/
--
help.
---
Peter Beckman Internet Guy
beck...@angryox.com http://www.angryox.com/
---
--
PHP Database Mailing List (http://www.php.net/)
To unsubs
{
This will always result in TRUE, as the assignment will always succeed.
Change it to:
if (($result = $client2->use_result())) {
(added parenthesis)
What DB library are you using?
---
Peter Beckman
Just something I figured out recently :)
or use select min(id) min, max(id) max from mytable
then access as $array['min'] and $array['max']
---
Peter Beckman
.
---
Peter Beckman Internet Guy
[EMAIL PROTECTED] http://www.purplecow.com/
---
--
PHP Database Mailing List (http
]/[page]/[on]/[server]/index.php on line 66
This leaves the question: 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
a
reference to a variable that doesn't exist, but the expected result is a
warning/error, not for PHP to populate an array.
we should cross check again.
I don't know what you mean.
---
Peter Beckm
t a
reference to a variable that doesn't exist, but the expected result is a
warning/error, not for PHP to populate an array.
Beckman
-------
Peter Beckman
/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
Notice how 3459 is supposed to be green but reports brown, 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-
for fkid 1, 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 in
query and outside of.
Your solution is valid, but not what I'm looking for.
---
Peter Beckman Internet Guy
[EMAIL PROTECTED] http://www.purpleco
ent; I
am addicted to trying to cut 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
------
nt < 0) {
echo "You don't have that many!";
}
---
Peter Beckman Internet Guy
[EMAIL PROTECTED] http://www.purplecow.com/
-
"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
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 t
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 an
t leaves things 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
------
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
#x27;m thinking some
abstract process in code, or something -- security through obscurity.
Beckman
-------
Peter Beckman Internet Guy
[EMAIL PROTECTED]
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 a
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
---
Pet
http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
---
Peter Beckman Internet Guy
[EMAIL PROTECTED]
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
Hi Jeff,
>
> do a print_r($_SERVER) to see which other variables are available. Maybe one
> of them will contain what you're looking for.
>
> Regards, Torsten
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: htt
.jar
How do I get connected from a remote PHP+Apache box to Oracle9i on linux?
Beckman
---
Peter Beckman Inter
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 th
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,
>
>
ROM users WHERE
> username='$username' AND password=md5('$password')");
---
Peter Beckman Internet Guy
[EMAIL PROTECTED
_timestamp() and date<(unix_timestamp()-(365*86400)) ...
Documentation:
http://mysql.com/date_sub (should redirect to
http://www.mysql.com/doc/en/Date_and_time_functions.html)
-------
Peter Beckman
caching. Look to the manual for that.
---
Peter Beckman Internet Guy
[EMAIL PROTECTED] http://www.purplecow.com/
---
ltsperpage'].",
".($conf['maxresultsperpage']*$_REQUEST['page'])-10);
// loop through array returned from mysql
echo "Next";
I think. It might need some tweaking, but you get the idea (I hope).
No need to store variables here.
Beckman
>
, 10
page #1, limit 0,10 etc
> Also, how to deal with printing? I would assume that the ideal page size
> is not the ideal printed page size. oi vay!
In IE 6, this works:
Even if your text follows, IE will print a page break. Haven
rt that says:
When comparing the last Promotion log entry on table log, these are the
applicationid and teammemberid combinations in which the sum of the
items matching in the score table does not equal the points in the
selected log entry.
Peter
---
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 verif
problem 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
---
Pet
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 B
_replace("/[\$,]/","",$x['funds']);
where $x['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".
B
Here's my test script:
Now: ".$HTTP_SESSION_VARS['user'];
if (empty($HTTP_SESSION_VARS['user'])) {
$HTTP_SESSION_VARS['user'] = "beckman";
} else {
$HTTP_SESSION_VARS['user'] = "";
.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
-------
Peter Beckman Internet Guy
[EMAIL PROTECTED] http://www.purplecow.com/
num_rows($r);
while( $row = mysql_fetch_array($r) ) {
// echo "";
}
list($l, $r) = explode(" ",microtime());
$diff = ((float)$l + (float)$r) - (float)$start;
echo "fetch_array(): $diff seconds [$num rows]($r.$l : $start)";
Beckman
_numrows($result);
> $start=($page-1)*$items_per_page;
> mysql_data_seek($result, $start);
> for ($i=0; $i<$items_per_page; $i++) {
> $row=mysql_fetch_assoc($result)
> // here goes output
> }
---
uot;me"! => $_POST['elementName'] == You don't know "me"!
If you don't addslashes when magic_quotes are turned off, your select will
fail, as the string will end at the first set of quotes (just after "know
").
Beckman
$_POST[elementName], like $elementName
> = $_POST[elementName], then continute use your original SQL sentence
> when the register_globals was on.
Waste (albeit very minor) of variable space. Concat them.
Beckman
--
use single quotes and concat the
variables outside of the quoted line. Better performance, less problems
with variables not being expanded correctly.
Beckman
--
ested, I may have written it wrong.
---
Peter Beckman Internet Guy
[EMAIL PROTECTED] http://www.purplecow.com/
---
-
ic string type. I
> used "Float", "Decmial", "Double" and "CHAR" the result was the same. Please
> help!
---
Peter Beckma
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 t
$minutes = (int)($leftover/1440);
$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=
view
the query itself. Maybe $_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
------
u'll have
1 PHP 0
Know you know you are at the top.
push $name onto an array (PHP is now array index 1)
Now just pop them off the array (PHP -> Database -> end of array)
Beckman
---
Peter Beckman
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_fie
ull
Key
Default
Extra
instead of what I was expecting.
> On Wed September 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.
> >
> &
at without replacing 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
rror? It does give 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
err file in my
/var/db/mysql directory but no avail on the warning. Obviously I
shouldn't be using year="", and I've since stopped. However, I do want to
learn what is going on and why when given an empty quoted string MySQL
translates that to 2000 versus
, but I'm a bit
embarrassed that I missed that in the manual, so I want 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
s matched: 1 Changed: 1 Warnings: 1
mysql> select * from plate where pid=65;
+-+-+--+-
| pid | plate | year |
+-+-+--+-
| 65 | DVF0343 | 2000 |
+-+-+--+-
2000? What? Why?
-----
Peter Beckman Internet Guy
[EMAIL PROTECTED] http://www.purplecow.com/
---
--
PHP Database
;
>
> ===
> EASY and FREE access to your email anywhere: http://Mailreader.com/
> ===
>
>
>
> --
> PHP Database Mailing List (http://www.php.
, 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 Be
>
>
> *
> The information contained in this e-mail message is intended only for
> the personal and confidential use of the recipient(s) named above.
> If the reader of this message is no
cipient,
> you must not copy, send on or retain this message. Please delete it
> and notify the sender by reply email, thank you.
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http:
anage that? and can you also add some options for the 'format'
> to be different when printing or viewing it on the screen?
>
>
> Kind regards,
>
> mark
>
>
---
Peter Beckman
rds that part of the WHERE clause is not working. Does anybody
> see any problem in the sql that I'm not seeing?? This is driving me nuts.
>
> Mike
>
>
>
>
>
>
>
> --
> PHP Database Mailing List (http://www.php
on ON Canada
> v3.1 GCS/E/AT d- s+: a- C+++ L++>+++$ P+ E- W+++$ N++ K? w++ M PS+
> PE++ Y+ PGP+ t-- 5++ !X R+ tv b DI+++ D-(++) G+ e(++) h-- r- y+
>
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit:
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
O
>
> > > So with md5 I can
> > > retrieve the passwords back to the user if they lose
> > > them via email.
> >
> > No, you can't. You'll need to generate a new password, md5
> > it, store it
> &
ounting all the
> possibilities when it comes to making this more secure).
>
> Mt.
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
e, 2003-06-24 at 08:35, JeRRy wrote:
> > > > > > > Hi,
> > > > > > >
> > > > > > > If I use md5 to handle passwords to my
> > > > database is
> > > > > > > there a way to reverse the action if
> &
hen the md5
digest 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 passwo
hands
on it.
I know this is PHP/MySQL list, but I'd write it in PHP/MySQL so it is sort
of related. I'd like to hear your thoughts on the pros and cons of such a
database.
Beckman
On Tue, 24 Jun 2003, [iso-8859-1] JeRRy wrote:
> Marco,
>
> Thanks, that's what I originally
ailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
---
Peter Beckman Internet Guy
[EMAIL PROTECTED] http://www.purplecow.com/
---
CTED] 3:34 Uhr:
>
> > Hi all,
> > I had create a session and stored some value into session.
> > > session();
> > session_register("id 123","name leooi");
> > ?>
> > How can i retrieved the value???
-
ories
> and they are static, I thought ENUM would work best. Your opinions?
>
> Edward Dudlik
> Becoming Digital
> www.becomingdigital.com
---
Peter Beckman
5
>
> --
> PHP Database Mailing List (http://www.php.net/)
> 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
hoppingcart = array( 'buy'=>'$buy', 'quantity'=>'$quantity' );
>
>
>
>
> session_register('shoppingcart');
>
>
>
> }
>
>
>
>
>
&
f to do what I'm looking
for.
I also have an "assignments" table, where I have:
AppID
TeamMemberID
roleid
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 othe
last row.
>
> Anyway, just looking to see if you folks have some ideas. I would prefer to roll my
> own rather than use one of the available "hotornot-style" PHP scripts to do this.
>
>
>
> Matthew J. Horn
>
> --
> PHP Database Mailing List (ht
erver.
Peter
---
Peter Beckman Internet Guy
[EMAIL PROTECTED] http://www.purpleco
uot; or "1"
>
> but I just need it to be 0 or 1. how do i strip the " off.
>
> thanks,
> Jeremy
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
--
ase Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
---
Peter Beckman Internet Guy
[EMAIL PROTECTED] http://www.purplecow.
> Nick
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
---
Peter Beckman Internet Guy
[EMAIL PROTECTED] http://www.
_
> Chat online in real time with MSN Messenger http://messenger.msn.co.uk
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
-
plus the year, though I can hardcode the year
> without a problem.
>
> Any ideas how I 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
php
Looks 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
---
Pet
dvance as always
>
> Dave Carrera
>
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.443 / Virus Database: 248 - Release Date: 10/01/2003
>
>
--
p user 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
ocess Outsourcing
>
> KPMG Argentina
> Tel: 54 11 4316 5754
> Fax: 54 11 4316 5734
> [EMAIL PROTECTED]
>
>
>
>
> -Original Message-
> From: Peter Beckman [mailto:[EMAIL PROTECTED]]
> Sent: Friday, January 03, 2003 4:49 PM
> To: Hutchins, Richard
> Cc:
t properly logged out (assuming the "delete
> from online..." query is only fired when they click on a "log out" button).
>
> 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 j
KPMG client engagement
> letter.
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
---
Peter Beckman Internet Guy
[EMAIL PROTECTED] htt
number_to_display) break;
if ($i<=$offset) continue;
print "stuff here";
}
Terrible code, I know, but you should be able to get the idea. Why
wouldn't you use limit? That seems silly.
I know Holmes would agree. :-)
Peter
------
> >
> >thanks for any help.
> >
> >tmb
> >
> >
> >
> >
> >--
> >PHP Database Mailing List (http://www.php.net/)
> >To unsubscribe, visit: http://www.php.net/unsub.php
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
s:
$myquery .= " AND password = '".crypt($password,"xpz8ty")."'";
---
Peter Beckman
uot;\n");
> while ($myrow = mysql_fetch_array($result)) {
>
> $l=$myrow['coursecode'];
> ?> selected="selected"':"";?>> }
> printf("\n");
> ?>
>
>
> on 11/12/02 5:26 pm, Peter Beckman at [EMAIL PROTECTED] wrote:
>
>
$transport')";
> $sql2 = "insert into acl (adminId,transportId,securityId) values
> ('$userid',last_insert_id(),'1'";
>
> mysql_query($sql1);
> mysql_query($sql2);
>
>
>
>
>
> --
> PHP Database Maili
le)
>
> Snailmail >> Unit 8, 14 King Square,
>Bristol BS2 8JJ
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
---
Peter B
1 - 100 of 190 matches
Mail list logo