hp.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
---
Peter Beckman
he query:
mysql> select count(*) from numbers where 3 and num like '1212%';
+--+
| count(*) |
+--+
| 42 |
+--+
Beckman
---
eful though -- sometimes 0
will be returned on a failure, depending on your SQL.
Beckman
---
Peter Beckman Internet Guy
beck...@angryox.com http://www.angryox.com/
-
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
ll the web server & MySQL, but it still not
running...
Please advice...
Thanks & Regards,
Anita
-------
Peter Beckman Internet Guy
[EMAIL PROTECTED]
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-
ts, bar is a varchar.
Beckman
-------
Peter Beckman Internet Guy
[EMAIL PROTECTED] http://www.purplecow.com/
---
--
P
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/
-
t/)
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 Internet Guy
[EMAIL PROTECTED]
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]
pc)(KEY=extproc)))
> (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=aleph0)))
>
> (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=zed2.mdah.state.ms.us)(PORT=1521)))
> Services Summary...
> Service "aleph0" has 1 instance(s).
> Instance "aleph0", status
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
List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
---
Peter Beckman Internet Guy
[EMAIL PROTECTED] http://www.purplecow.co
; Regards
> Piotr Babula
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
---
Peter Beckman
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/
---
th printing? I would assume that the ideal page
> > size is not the ideal printed page size. oi vay!
> >
> > TIA
> >
> >
> > -----
> > Do you Yahoo!?
> > Yahoo! Finance: Get your refund fast by filing online
>
27;t researched
how to do it in Mozilla or Netscape.
Beckman
-------
Peter Beckman Internet Guy
[EMAIL PROTECTED] http://www.purplecow.com/
--
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
---
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
session.gc_probability
0.010.01
session.name
PHPSESSID PHPSESSID
session.referer_check
no valueno value
session.save_handler
files files
session.save_path
/tmp/tmp
session.serialize_handler
php php
session.use_cookies
On On
--
.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
=1?"":"s",
$seconds, $seconds==1?"":"s");
Beckman
---
Peter Beckman Internet Guy
[EMAIL PROTECTED] http://www.purplecow.com/
--
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
the MySQL lists.
Beckman
-------
Peter Beckman Internet Guy
[EMAIL PROTECTED] http://www.purplecow.com/
---
--
PHP D
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
Confused. PHP or Mysql fault?
Beckman
-------
Peter Beckman Internet Guy
[EMAIL PROTECTED] http://www.purplecow.com/
with $dbh2 to select from tables on the
second 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
--
;
>
> ===
> 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:
n Tue, 24 Jun 2003, Peter Beckman wrote:
> md5 is also a one-way encryption. crypt also provides 300*10^21 possible
> values, whereas md5 provides a possible 63*10^48, or
> 63000 * 10^21 possible values. A little bit better
> security I'd say. Crypt is
>
> > > 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
> &
gt; Telstra or Vodafone mobile.
> > > --
> > >
> > > Marco Tabini
> > > President
> > >
> > > Marco Tabini & Associates, Inc.
> > > 28 Bombay Avenue
> > > Toronto, ON M3H
t; But what I have heard and read it's very tight
> and probably the best method to handle passwords for
> now, until something new is released. Which will
> happen when md5 is broken, like everything else after
> a little bit of time
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
>
>
>
> Level 4
> 54 Neridah StreetPO Box 1290
> CHATSWOOD NSW 2067 CHATSWOOD NSW 2057
>
>
> Ph: +61 2 9413 2944 Fax: +61 2 9413 9901
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsu
1 - 100 of 189 matches
Mail list logo