[PHP] Extract an element from XML
Hi all,
I have the following segment of XML:
165432
Now I want to get the value of the BookingReference where the
ReferenceSource = "api". In other words I want to get the value 165432.
I have the following code:
$ItemConfirmationReference2 = $xpath->query('BookingReference
ReferenceSource' , $Element);
$ItemConfirmationReference =
trim($ItemConfirmationReference2->item(0)->textContent);
The $Element variable passes the node that contains the BookingReference
node.
The tricky part for me is the ="api" part.
Thanks in advance.
A
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Asterisk anyone?
Nathan Nobbe wrote: > On Wed, Jul 29, 2009 at 1:18 PM, Skip Evans > wrote: > >> Hey, >> >> I've been asked to write a simple couple of public pages that would >> let an Asterisk customer modify their account configuration, but the >> client has no idea how Asterisk stores its data, apparently not in >> MySQL. >> >> Anyone know of any resources for accessing Asterisk from PHP? >> >> If anyone has done this can you tell me if I'm on the right track >> here? >> >> http://www.voip-info.org/wiki/view/Asterisk+AGI+php#PHPTipsandExamples > > > this should get you off to a good start, > > http://www.voip-info.org/wiki/view/Asterisk+CDR+csv+mysql+import Yes, the CDR is often recorded in a database, but it's write-only as far as Asterisk is concerned. It can be used for billing and such afterwards, but then we're no longer in Asterisk territory. /Per -- Per Jessen, Zürich (17.8°C) -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Ridiculous ..won't print or echo ...(RESOLVED)
Just testing message
Miller, Terion napsal(a):
> Yep I forgot about escaping the $
>
>
>
> On 7/29/09 10:51 AM, "Ford, Mike" wrote:
>
>> -Original Message-
>> From: Miller, Terion [mailto:tmil...@springfi.gannett.com]
>> Sent: 29 July 2009 16:36
>>
>> Ok in my output to Quark I need to have $P printed to the page like
>> this:
>>
>> <@$p>2118 S. Campbell Ave
>>
>> So in my php which is going to be grabbing this info and formatting
>> it for
>> the Quarkisn't echoing that "$p" all I get is the <@>
>>
>> I have tried several things:
>>
>> $p = $p
>>
>> $p = print("$p")
>
> "$p" is trying to interpolate the value of the variable $p -- if you had full
> error reporting turned on, you would see a nonexistent variable error. Once
> more, there are several things you can do, of which the two most obvious are:
>
> * Use single quotes: echo '$p';
>
> * Use a backslash: echo "\$p";
>
>
> Cheers!
>
> Mike
> --
> Mike Ford,
> Electronic Information Developer, Libraries and Learning Innovation,
> Leeds Metropolitan University, C507, Civic Quarter Campus,
> Woodhouse Lane, LEEDS, LS1 3HE, United Kingdom
> Email: m.f...@leedsmet.ac.uk
> Tel: +44 113 812 4730
>
>
>
>
>
> To view the terms under which this email is distributed, please go to
> http://disclaimer.leedsmet.ac.uk/email.htm
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Ridiculous ..won't print or echo ...(RESOLVED)
I'm sorry for this post. It's only testing. Thanks for understand. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Better Formatting Options?
Hi, > I have many products per page and this code pulls the list price and > formats it. It works fine, but I'd like to know if I can shorten it. Personally, I would advise against trying to cram as much as possible into the least amount of space as possible, and instead going for verbosity/readability. It will help when you come back to re-read it in X months. -- Richard Heyes HTML5 graphing: RGraph - www.rgraph.net (updated 25th July) Lots of PHP and Javascript code - http://www.phpguru.org -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] fileinfo returning wrong mime type for Excel files
On Thu, 2009-07-30 at 21:26 -0400, b wrote: > On 07/30/2009 10:15 AM, Ashley Sheridan wrote: > > On Thu, 2009-07-30 at 07:12 -0700, Christoph Boget wrote: > >> > >> You could email it to me, which I presume is better if you replied > >> back just to me and not the list? > >> > > Just copying the list back on in this one now. I don't know of any > > places that you could upload a file to off the top of my head. Anyone > > have any links? > > > > Just google "upload file"; there are a bunch of sites that do this to > choose from. > > (I've never used any so I can't recommend one over the others) > > If it helps any with testing, on my laptop (brand new Fedora 11 install) a standard .xls file created with OOo3 is showing up as just 'test.xls: application/vnd.ms-office; charset=binary' and not a specific Excel sheet. Thanks, Ash http://www.ashleysheridan.co.uk -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Extract an element from XML
Angelo Zanetti wrote:
Hi all,
I have the following segment of XML:
165432
Now I want to get the value of the BookingReference where the
ReferenceSource = "api". In other words I want to get the value 165432.
I have the following code:
$ItemConfirmationReference2 = $xpath->query('BookingReference
ReferenceSource' , $Element);
$ItemConfirmationReference =
trim($ItemConfirmationReference2->item(0)->textContent);
The $Element variable passes the node that contains the BookingReference
node.
The tricky part for me is the ="api" part.
Thanks in advance.
A
Hi Angelo,
Probably it is something along the lines like:
$xpath->query('BookingReference/[...@referencesource="api"]/');
Fairly simple and XPath is way powerful!
Kind regards,
Aschwin Wesselius
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Extract an element from XML
Aschwin Wesselius wrote:
Angelo Zanetti wrote:
Hi all,
I have the following segment of XML:
165432
Now I want to get the value of the BookingReference where the
ReferenceSource = "api". In other words I want to get the value 165432.
I have the following code:
$ItemConfirmationReference2 = $xpath->query('BookingReference
ReferenceSource' , $Element);
$ItemConfirmationReference =
trim($ItemConfirmationReference2->item(0)->textContent);
The $Element variable passes the node that contains the BookingReference
node.
The tricky part for me is the ="api" part.
Thanks in advance.
A
Hi Angelo,
Probably it is something along the lines like:
$xpath->query('BookingReference/[...@referencesource="api"]/');
Fairly simple and XPath is way powerful!
Kind regards,
Aschwin Wesselius
Ah, sorry about that:
$xpath->query('bookingreferen...@referencesource="api"]/');
There was a '/' after BookingReference.
Kind regards,
Aschwin Wesselius
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] PHPBB Speed Issues
Hi Guys, I know this is maybe a bit specific for the general list, but thought I'd throw it out there anyway as I reckon a lot of you have had experience with PHPBB at some point or another. We've got an existing installation of the forum here, that's been active for a couple of years and is fairly busy. The site itself is on a dedicated server, but we're having some issues with the speed. Some pages are taking ≅7-8 seconds to display. I've optimised the images in the template, enabled the GZ compression, and it's only improved the speed by a mere fraction. I have noticed that the page itself doesn't display until after this delay, so I was guessing that I could maybe force the buffer to flush at key intervals to give the impression the pages are loading faster. Does anybody have any insights into this? Thanks, Ash http://www.ashleysheridan.co.uk
Re: [PHP] PHPBB Speed Issues
Ashley Sheridan wrote: > I've optimised the images in the template, enabled the GZ compression, > and it's only improved the speed by a mere fraction. I have noticed that > the page itself doesn't display until after this delay, so I was > guessing that I could maybe force the buffer to flush at key intervals > to give the impression the pages are loading faster. Does anybody have > any insights into this? To bring things more on topic, why not rather have a discussion about general scalability? 1. Cache as much as you can (everything) 2. Minimise HTTP requests 3. Use an opcode cache like APC 4. Use a RAM based cache system like memcacheD and give your db a breather 5. FINALLY, throw more hardware at it. -- -- Paul http://www.paulscott.za.net/ http://twitter.com/paulscott56 http://avoir.uwc.ac.za -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] PHPBB Speed Issues
2009/7/31 Paul Scott : -1. Measure everything. No point implementing a change that slows things down. Implement low-hanging-fruit first (eg a CDN) 0. Optimise your existing setup before adding more layers > 1. Cache as much as you can (everything) > 2. Minimise HTTP requests > 3. Use an opcode cache like APC > 4. Use a RAM based cache system like memcacheD and give your db a breather 4a. Cache complete objects, not DB result sets 5. Don't tie up Apache processes with requests for static files (lighttpd/CDN/both) > 6. FINALLY, throw more hardware at it. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Freeing Memory
On Thu, 30 Jul 2009 10:42:26 -0400, Dan Shirah wrote: > I don't know what version of SQL you are using, but I have found that using: > > mysql_free_result($result); > mssql_free_result($result); > ifx_free_result($result); > > Helped my queries run much faster and use less resources. I had something > similar to your script where I would read lines from a huge file and then > insert the contents into my database. Before adding the above the process > would take 20-30 minutes. After freeing the results after each insert my > script completed in about 5-8 minutes. How does that work considering that mysql_query() only returns true or false on INSERT? I'd expect the script to fail on $result not being a valid resource. /Nisse -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] preg_match too greedy
> -Original Message- > From: b [mailto:p...@logi.ca] > Sent: 30 July 2009 03:17 > > > > > >>> echo (preg_match($pattern, $test) != false) > > > > The " != false " here is redundant. > > Understood. But what you think is redundancy is, to me, clarity in > programming. I happen to think that boolean tests shouldn't ride on > whether or not an array returned from a function is empty or not (or > a > freaking boolean). If what I'm looking for is a "false" then that's > what > I'll test for. Well, then, by that logic you should be testing separately for ===FALSE and ===0, since the former means an error occurred, whilst the latter means the pattern was ok but didn't match. If the pattern finds a match, the return value is 1 (not TRUE). Cheers! Mike -- Mike Ford, Electronic Information Developer, Libraries and Learning Innovation, Leeds Metropolitan University, C507, Civic Quarter Campus, Woodhouse Lane, LEEDS, LS1 3HE, United Kingdom Email: m.f...@leedsmet.ac.uk Tel: +44 113 812 4730 To view the terms under which this email is distributed, please go to http://disclaimer.leedsmet.ac.uk/email.htm -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Freeing Memory
>
> How does that work considering that mysql_query() only
> returns true or false on INSERT? I'd expect the script
> to fail on $result not being a valid resource.
>
I don't know about mysql as I work with MSSQL Server and Informix, but for
me it works like this:
$insert = ifx_prepare("INSERT INTO my_table
VALUES ('0')", $connect_id);
ifx_do($insert) or die ("Query failed");
ifx_free_result($insert);
By using PREPARE and DO to execute the queries it allows ifx_free_result to
release those resources.
[PHP] 2 ifs embedded?
I need this to say : If row notes is not empty and is alpha echo notes
How do I get the is alpha part in here;
If (!empty($row['notes'])) {
echo(" $trimNotes ");
}
I tried.
If (IsAlpha($row['notes'])) {
echo(" $trimNotes ");
}
But it broke the whole script.
--Terion
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] PHPBB Speed Issues
On Fri, 2009-07-31 at 11:27 +0100, David Otton wrote: > 2009/7/31 Paul Scott : > > -1. Measure everything. No point implementing a change that slows > things down. Implement low-hanging-fruit first (eg a CDN) > 0. Optimise your existing setup before adding more layers > > 1. Cache as much as you can (everything) > > 2. Minimise HTTP requests > > 3. Use an opcode cache like APC > > 4. Use a RAM based cache system like memcacheD and give your db a breather > 4a. Cache complete objects, not DB result sets > 5. Don't tie up Apache processes with requests for static files > (lighttpd/CDN/both) > > 6. FINALLY, throw more hardware at it. > For those interested, I found the errant cause of the speed issue. Was a query using a left join on 4 of the largest tables. Changed one query to an inner join, and it's now smoking again! Thanks, Ash http://www.ashleysheridan.co.uk -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] 2 ifs embedded?
On Fri, 2009-07-31 at 06:53 -0700, Miller, Terion wrote:
> I need this to say : If row notes is not empty and is alpha echo notes
>
> How do I get the is alpha part in here;
>
> If (!empty($row['notes'])) {
>
>
> echo(" $trimNotes ");
>
> }
>
> I tried.
>
> If (IsAlpha($row['notes'])) {
>
>
> echo(" $trimNotes ");
>
> }
>
> But it broke the whole script.
>
> --Terion
>
>
I'm not really sure what you are trying to do here? Is it that you want
to have nested queries, or only do something if both conditions have
been met?
Thanks,
Ash
http://www.ashleysheridan.co.uk
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] 2 ifs embedded?
Miller, Terion wrote:
> I need this to say : If row notes is not empty and is alpha echo notes
>
> How do I get the is alpha part in here;
>
> If (!empty($row['notes'])) {
>
>
> echo(" $trimNotes ");
>
> }
>
> I tried.
>
> If (IsAlpha($row['notes'])) {
>
>
> echo(" $trimNotes ");
>
> }
>
> But it broke the whole script.
>
> --Terion
>
>
>
You can write it in one IF statement
If (!empty($row['notes']) && IsAlpha($row['notes'])) {
}
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] String to Date Conversion Problem
Hi, Guys:
I am trying to turn a prepared line into a date format, and the string looks
something like this: 23 JUL 09 - THURSDAY, and I am trying to change the
string to a mm/dd/ format that looks like 07/23/2009.
I tried to use strtotime() but it gave me nothing.
Here is the code:
list($date,$month,$year,$dash,$day) = split(" ",$line,5);
echo "" . strtotime($date . "\s" . $month . "\s" . $year).
"";
Could anyone on the list please give me a hint on what I might have done
wrong here?
Thanks for your help.
Alice
_
All-in-one security and maintenance for your PC. Get a free 90-day trial!
http://www.windowsonecare.com/purchase/trial.aspx?sc_cid=wl_wlmail
Re: [PHP] Freeing Memory
On Fri, 31 Jul 2009 07:54:13 -0400, Dan Shirah wrote:
>>
>> How does that work considering that mysql_query() only
>> returns true or false on INSERT? I'd expect the script
>> to fail on $result not being a valid resource.
>>
>
> I don't know about mysql as I work with MSSQL Server and Informix, but for
> me it works like this:
>
>$insert = ifx_prepare("INSERT INTO my_table
> VALUES ('0')", $connect_id);
>ifx_do($insert) or die ("Query failed");
>ifx_free_result($insert);
>
> By using PREPARE and DO to execute the queries it allows ifx_free_result to
> release those resources.
That explains it. (You'd have to use the MySQLi extension
to use prepared statements with MySQL, unless I'm confused).
Personally, I try to make it a point to free resources as
soon as possible.
/Nisse
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] 2 ifs embedded?
On 7/31/09 8:58 AM, "m0s" wrote: (!empty($row['notes']) && IsAlpha($row['notes'])) I tried that and this one: If (!empty($row['notes']) && ctype_alpha($row['notes'])) It didn't display the notes at all... And this one...doesn't display if the field has a 0 in it but I still need it to? If (!empty($row['critical']) && ctype_alnum($row['critical'])) -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] String to Date Conversion Problem
Hi Alice,
Based on the string format that you mentioned (DD MMM YY - DAY) you
should be able to transform to any other date using the following:
$parts = explode(' ', '23 JUL 09 - THURSDAY');
echo date('m/d/Y', strtotime("{$parts[1]} {$parts[0]} {$parts[2]}"));
Cheers
Stuart
On 31 Jul 2009, at 15:19, Alice Wei wrote:
Hi, Guys:
I am trying to turn a prepared line into a date format, and the
string looks something like this: 23 JUL 09 - THURSDAY, and I am
trying to change the string to a mm/dd/ format that looks like
07/23/2009.
I tried to use strtotime() but it gave me nothing.
Here is the code:
list($date,$month,$year,$dash,$day) = split(" ",$line,5);
echo "" . strtotime($date . "\s" . $month . "\s" .
$year). "";
Could anyone on the list please give me a hint on what I might have
done wrong here?
Thanks for your help.
Alice
_
All-in-one security and maintenance for your PC. Get a free 90-day
trial!
http://www.windowsonecare.com/purchase/trial.aspx?sc_cid=wl_wlmail
smime.p7s
Description: S/MIME cryptographic signature
Re: [PHP] 2 ifs embedded?
On Fri, Jul 31, 2009 at 10:28 AM, Miller, Terion wrote: > > > > On 7/31/09 8:58 AM, "m0s" wrote: > > (!empty($row['notes']) && IsAlpha($row['notes'])) > > I tried that and this one: > > If (!empty($row['notes']) && ctype_alpha($row['notes'])) > > It didn't display the notes at all... > > And this one...doesn't display if the field has a 0 in it but I still need it > to? > > If (!empty($row['critical']) && ctype_alnum($row['critical'])) > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > Hey Teri, Could the return from the db have a space or something in the value? Perhaps If (!empty($row['critical']) && ctype_alnum((int)$row['critical'])) might work -- Bastien Cat, the other other white meat -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] 2 ifs embedded?
On 7/31/09 9:53 AM, "Bastien Koert" wrote:
On Fri, Jul 31, 2009 at 10:28 AM, Miller,
Terion wrote:
>
>
>
> On 7/31/09 8:58 AM, "m0s" wrote:
>
> (!empty($row['notes']) && IsAlpha($row['notes']))
>
> I tried that and this one:
>
> If (!empty($row['notes']) && ctype_alpha($row['notes']))
>
> It didn't display the notes at all...
>
> And this one...doesn't display if the field has a 0 in it but I still need it
> to?
>
> If (!empty($row['critical']) && ctype_alnum($row['critical']))
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
Hey Teri,
Could the return from the db have a space or something in the value? Perhaps
If (!empty($row['critical']) && ctype_alnum((int)$row['critical']))
might work
--
Bastien
Cat, the other other white meat
It's got me stumped, tried it and it still will not echo if the field has a 0
in it:
If (!empty($row['critical']) && ctype_alnum((int)$row['critical'])){
echo(" Critical violations found: ". $row['critical'] .". ");
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] unsubscription not working
Trying to unsubscribe from the list, send the email and get this response: 'Acknowledgment: The address tinmach...@googlemail.com was not on the php-general mailing list when I received your request and is not a subscriber of this list.' Where I'm sure that is the address I'm subscribed with. -- Luke Slater :O) this text is protected by international copyright. it is illegal for anybody apart from the recipient to keep a copy of this text. dieser text wird von internationalem urheberrecht geschuetzt. allen ausser dem/der empfaenger/-in ist untersagt, eine kopie dieses textes zu behalten.
Re: [PHP] 2 ifs embedded?
On Fri, Jul 31, 2009 at 10:59 AM, Miller,
Terion wrote:
>
>
>
> On 7/31/09 9:53 AM, "Bastien Koert" wrote:
>
> On Fri, Jul 31, 2009 at 10:28 AM, Miller,
> Terion wrote:
>>
>>
>>
>> On 7/31/09 8:58 AM, "m0s" wrote:
>>
>> (!empty($row['notes']) && IsAlpha($row['notes']))
>>
>> I tried that and this one:
>>
>> If (!empty($row['notes']) && ctype_alpha($row['notes']))
>>
>> It didn't display the notes at all...
>>
>> And this one...doesn't display if the field has a 0 in it but I still need
>> it to?
>>
>> If (!empty($row['critical']) && ctype_alnum($row['critical']))
>>
>> --
>> PHP General Mailing List (http://www.php.net/)
>> To unsubscribe, visit: http://www.php.net/unsub.php
>>
>>
>
> Hey Teri,
> Could the return from the db have a space or something in the value? Perhaps
>
> If (!empty($row['critical']) && ctype_alnum((int)$row['critical']))
>
> might work
>
>
> --
>
> Bastien
>
> Cat, the other other white meat
>
>
> It's got me stumped, tried it and it still will not echo if the field has a 0
> in it:
>
> If (!empty($row['critical']) && ctype_alnum((int)$row['critical'])){
> echo(" Critical violations found: ". $row['critical'] .". ");
>
If you echo it out what is the value?
echo "[".$row['critical']."]";
what do you get?
--
Bastien
Cat, the other other white meat
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] 2 ifs embedded?
> On 7/31/09 9:53 AM, "Bastien Koert" wrote:
>
> On Fri, Jul 31, 2009 at 10:28 AM, Miller,
> Terion wrote:
> >
> >
> >
> > On 7/31/09 8:58 AM, "m0s" wrote:
> >
> > (!empty($row['notes']) && IsAlpha($row['notes']))
> >
> > I tried that and this one:
> >
> > If (!empty($row['notes']) && ctype_alpha($row['notes']))
> >
> > It didn't display the notes at all...
> >
> > And this one...doesn't display if the field has a 0 in it but I still
> need it to?
> >
> > If (!empty($row['critical']) && ctype_alnum($row['critical']))
> >
> > --
> > PHP General Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
> >
> >
>
> Hey Teri,
> Could the return from the db have a space or something in the value?
> Perhaps
>
> If (!empty($row['critical']) && ctype_alnum((int)$row['critical']))
>
> might work
>
>
> --
>
> Bastien
>
> Cat, the other other white meat
>
>
> It's got me stumped, tried it and it still will not echo if the field
> has a 0 in it:
>
> If (!empty($row['critical']) && ctype_alnum((int)$row['critical'])){
> echo(" Critical violations found: ". $row['critical'] .". ");
>
empty() regards 0 as an empty value... From the manual:
[quote]
The following things are considered to be empty:
* "" (an empty string)
* 0 (0 as an integer)
* "0" (0 as a string)
* NULL
* FALSE
* array() (an empty array)
* var $var; (a variable declared, but without a value in a class)
[/quote]
HTH
Dan
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] String to Date Conversion Problem
Looks like what I did by using mm/dd/ was extra, which was probably why it
didn't work.
Thanks, looks like this is up and running now.
Alice
> CC: php-general@lists.php.net
> From: stu...@stuconnolly.com
> To: aj...@alumni.iu.edu
> Subject: Re: [PHP] String to Date Conversion Problem
> Date: Fri, 31 Jul 2009 15:45:44 +0100
>
> Hi Alice,
>
> Based on the string format that you mentioned (DD MMM YY - DAY) you
> should be able to transform to any other date using the following:
>
> $parts = explode(' ', '23 JUL 09 - THURSDAY');
>
> echo date('m/d/Y', strtotime("{$parts[1]} {$parts[0]} {$parts[2]}"));
>
> Cheers
>
> Stuart
>
> On 31 Jul 2009, at 15:19, Alice Wei wrote:
>
> >
> > Hi, Guys:
> >
> > I am trying to turn a prepared line into a date format, and the
> > string looks something like this: 23 JUL 09 - THURSDAY, and I am
> > trying to change the string to a mm/dd/ format that looks like
> > 07/23/2009.
> >
> > I tried to use strtotime() but it gave me nothing.
> > Here is the code:
> >
> >list($date,$month,$year,$dash,$day) = split(" ",$line,5);
> >echo "" . strtotime($date . "\s" . $month . "\s" .
> > $year). "";
> >
> > Could anyone on the list please give me a hint on what I might have
> > done wrong here?
> >
> > Thanks for your help.
> >
> > Alice
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > _
> > All-in-one security and maintenance for your PC. Get a free 90-day
> > trial!
> > http://www.windowsonecare.com/purchase/trial.aspx?sc_cid=wl_wlmail
>
_
Express yourself with gadgets on Windows Live Spaces
http://discoverspaces.live.com?source=hmtag1&loc=us
Re: [PHP] 2 ifs embedded?
On 7/31/09 10:14 AM, "Bastien Koert" wrote:
On Fri, Jul 31, 2009 at 10:59 AM, Miller,
Terion wrote:
>
>
>
> On 7/31/09 9:53 AM, "Bastien Koert" wrote:
>
> On Fri, Jul 31, 2009 at 10:28 AM, Miller,
> Terion wrote:
>>
>>
>>
>> On 7/31/09 8:58 AM, "m0s" wrote:
>>
>> (!empty($row['notes']) && IsAlpha($row['notes']))
>>
>> I tried that and this one:
>>
>> If (!empty($row['notes']) && ctype_alpha($row['notes']))
>>
>> It didn't display the notes at all...
>>
>> And this one...doesn't display if the field has a 0 in it but I still need
>> it to?
>>
>> If (!empty($row['critical']) && ctype_alnum($row['critical']))
>>
>> --
>> PHP General Mailing List (http://www.php.net/)
>> To unsubscribe, visit: http://www.php.net/unsub.php
>>
>>
>
> Hey Teri,
> Could the return from the db have a space or something in the value? Perhaps
>
> If (!empty($row['critical']) && ctype_alnum((int)$row['critical']))
>
> might work
>
>
> --
>
> Bastien
>
> Cat, the other other white meat
>
>
> It's got me stumped, tried it and it still will not echo if the field has a 0
> in it:
>
> If (!empty($row['critical']) && ctype_alnum((int)$row['critical'])){
> echo(" Critical violations found: ". $row['critical'] .". ");
>
If you echo it out what is the value?
echo "[".$row['critical']."]";
what do you get?
--
Bastien
Cat, the other other white meat
If I echo it I get the int that is in the field from the db fine...so it's
something with my statement?
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: This isn't infinitely recursive is it?
I like it... Thanks!
On Thu, Jul 30, 2009 at 8:04 PM, Ben Dunlap wrote:
>> I don't THINK I need to worry about circular mappings... but I'm not
>> sure how to check for it if I did...
> Would the following work? It avoids recursion entirely and also checks for
> circular mappings. You can plug in your own code where the comments are to do
> whatever is appropriate when a circular mapping is detected.
>
> function GetMappedField($Field)
> {
> $OriginalField = $Field;
>
> while (isset($FieldMap[$Field])) {
> $Field = $FieldMap[$Field];
>
> if ($Field === $OriginalField) {
> /*
> * circular mapping has been detected;
> * report an error or explode or whatever
> */
> break;
> }
> }
>
> return $Field;
> }
>
>
> Ben
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] 2 ifs embedded?
Miller, Terion wrote:
>
>
> On 7/31/09 10:14 AM, "Bastien Koert" wrote:
>
> On Fri, Jul 31, 2009 at 10:59 AM, Miller,
> Terion wrote:
>>
>>
>> On 7/31/09 9:53 AM, "Bastien Koert" wrote:
>>
>> On Fri, Jul 31, 2009 at 10:28 AM, Miller,
>> Terion wrote:
>>>
>>>
>>> On 7/31/09 8:58 AM, "m0s" wrote:
>>>
>>> (!empty($row['notes']) && IsAlpha($row['notes']))
>>>
>>> I tried that and this one:
>>>
>>> If (!empty($row['notes']) && ctype_alpha($row['notes']))
>>>
>>> It didn't display the notes at all...
>>>
>>> And this one...doesn't display if the field has a 0 in it but I still need
>>> it to?
>>>
>>> If (!empty($row['critical']) && ctype_alnum($row['critical']))
>>>
>>> --
>>> PHP General Mailing List (http://www.php.net/)
>>> To unsubscribe, visit: http://www.php.net/unsub.php
>>>
>>>
>> Hey Teri,
>> Could the return from the db have a space or something in the value? Perhaps
>>
>> If (!empty($row['critical']) && ctype_alnum((int)$row['critical']))
>>
>> might work
>>
>>
>> --
>>
>> Bastien
>>
>> Cat, the other other white meat
>>
>>
>> It's got me stumped, tried it and it still will not echo if the field has a
>> 0 in it:
>>
>> If (!empty($row['critical']) && ctype_alnum((int)$row['critical'])){
>> echo(" Critical violations found: ". $row['critical'] .". ");
>>
>
> If you echo it out what is the value?
>
> echo "[".$row['critical']."]";
>
> what do you get?
>
> --
>
> Bastien
>
> Cat, the other other white meat
>
> If I echo it I get the int that is in the field from the db fine...so it's
> something with my statement?
>
That all depends on WHAT it is you are getting.
Can you tell us WHAT you are getting? Not simply that "I get the int
that is in the field from the db". We don't have any idea what that
value is. Only you know that...
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] 2 ifs embedded?
On 7/31/09 10:54 AM, "Jim Lucas" wrote:
Miller, Terion wrote:
>
>
> On 7/31/09 10:14 AM, "Bastien Koert" wrote:
>
> On Fri, Jul 31, 2009 at 10:59 AM, Miller,
> Terion wrote:
>>
>>
>> On 7/31/09 9:53 AM, "Bastien Koert" wrote:
>>
>> On Fri, Jul 31, 2009 at 10:28 AM, Miller,
>> Terion wrote:
>>>
>>>
>>> On 7/31/09 8:58 AM, "m0s" wrote:
>>>
>>> (!empty($row['notes']) && IsAlpha($row['notes']))
>>>
>>> I tried that and this one:
>>>
>>> If (!empty($row['notes']) && ctype_alpha($row['notes']))
>>>
>>> It didn't display the notes at all...
>>>
>>> And this one...doesn't display if the field has a 0 in it but I still need
>>> it to?
>>>
>>> If (!empty($row['critical']) && ctype_alnum($row['critical']))
>>>
>>> --
>>> PHP General Mailing List (http://www.php.net/)
>>> To unsubscribe, visit: http://www.php.net/unsub.php
>>>
>>>
>> Hey Teri,
>> Could the return from the db have a space or something in the value? Perhaps
>>
>> If (!empty($row['critical']) && ctype_alnum((int)$row['critical']))
>>
>> might work
>>
>>
>> --
>>
>> Bastien
>>
>> Cat, the other other white meat
>>
>>
>> It's got me stumped, tried it and it still will not echo if the field has a
>> 0 in it:
>>
>> If (!empty($row['critical']) && ctype_alnum((int)$row['critical'])){
>> echo(" Critical violations found: ". $row['critical'] .". ");
>>
>
> If you echo it out what is the value?
>
> echo "[".$row['critical']."]";
>
> what do you get?
>
> --
>
> Bastien
>
> Cat, the other other white meat
>
> If I echo it I get the int that is in the field from the db fine...so it's
> something with my statement?
>
That all depends on WHAT it is you are getting.
Can you tell us WHAT you are getting? Not simply that "I get the int
that is in the field from the db". We don't have any idea what that
value is. Only you know that...
Numbers are in that field ... So I'm getting 0, 1, 2 etc however many
violations there are
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] 2 ifs embedded?
On 7/31/09 11:03 AM, "Miller, Terion" wrote:
On 7/31/09 10:54 AM, "Jim Lucas" wrote:
Miller, Terion wrote:
>
>
> On 7/31/09 10:14 AM, "Bastien Koert" wrote:
>
> On Fri, Jul 31, 2009 at 10:59 AM, Miller,
> Terion wrote:
>>
>>
>> On 7/31/09 9:53 AM, "Bastien Koert" wrote:
>>
>> On Fri, Jul 31, 2009 at 10:28 AM, Miller,
>> Terion wrote:
>>>
>>>
>>> On 7/31/09 8:58 AM, "m0s" wrote:
>>>
>>> (!empty($row['notes']) && IsAlpha($row['notes']))
>>>
>>> I tried that and this one:
>>>
>>> If (!empty($row['notes']) && ctype_alpha($row['notes']))
>>>
>>> It didn't display the notes at all...
>>>
>>> And this one...doesn't display if the field has a 0 in it but I still need
>>> it to?
>>>
>>> If (!empty($row['critical']) && ctype_alnum($row['critical']))
>>>
>>> --
>>> PHP General Mailing List (http://www.php.net/)
>>> To unsubscribe, visit: http://www.php.net/unsub.php
>>>
>>>
>> Hey Teri,
>> Could the return from the db have a space or something in the value? Perhaps
>>
>> If (!empty($row['critical']) && ctype_alnum((int)$row['critical']))
>>
>> might work
>>
>>
>> --
>>
>> Bastien
>>
>> Cat, the other other white meat
>>
>>
>> It's got me stumped, tried it and it still will not echo if the field has a
>> 0 in it:
>>
>> If (!empty($row['critical']) && ctype_alnum((int)$row['critical'])){
>> echo(" Critical violations found: ". $row['critical'] .". ");
>>
>
> If you echo it out what is the value?
>
> echo "[".$row['critical']."]";
>
> what do you get?
>
> --
>
> Bastien
>
> Cat, the other other white meat
>
> If I echo it I get the int that is in the field from the db fine...so it's
> something with my statement?
>
That all depends on WHAT it is you are getting.
Can you tell us WHAT you are getting? Not simply that "I get the int
that is in the field from the db". We don't have any idea what that
value is. Only you know that...
Numbers are in that field ... So I'm getting 0, 1, 2 etc however many
violations there are, so why doesn't this work?
If (ctype_alnum((int)$row['critical'])){echo(" Critical violations
found: ". $row['critical'] .". ");
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] 2 ifs embedded? (RESOLVED)
On 7/31/09 10:54 AM, "Jim Lucas" wrote:
Miller, Terion wrote:
>
>
> On 7/31/09 10:14 AM, "Bastien Koert" wrote:
>
> On Fri, Jul 31, 2009 at 10:59 AM, Miller,
> Terion wrote:
>>
>>
>> On 7/31/09 9:53 AM, "Bastien Koert" wrote:
>>
>> On Fri, Jul 31, 2009 at 10:28 AM, Miller,
>> Terion wrote:
>>>
>>>
>>> On 7/31/09 8:58 AM, "m0s" wrote:
>>>
>>> (!empty($row['notes']) && IsAlpha($row['notes']))
>>>
>>> I tried that and this one:
>>>
>>> If (!empty($row['notes']) && ctype_alpha($row['notes']))
>>>
>>> It didn't display the notes at all...
>>>
>>> And this one...doesn't display if the field has a 0 in it but I still need
>>> it to?
>>>
>>> If (!empty($row['critical']) && ctype_alnum($row['critical']))
>>>
>>> --
>>> PHP General Mailing List (http://www.php.net/)
>>> To unsubscribe, visit: http://www.php.net/unsub.php
>>>
>>>
>> Hey Teri,
>> Could the return from the db have a space or something in the value? Perhaps
>>
>> If (!empty($row['critical']) && ctype_alnum((int)$row['critical']))
>>
>> might work
>>
>>
>> --
>>
>> Bastien
>>
>> Cat, the other other white meat
>>
>>
>> It's got me stumped, tried it and it still will not echo if the field has a
>> 0 in it:
>>
>> If (!empty($row['critical']) && ctype_alnum((int)$row['critical'])){
>> echo(" Critical violations found: ". $row['critical'] .". ");
>>
>
> If you echo it out what is the value?
>
> echo "[".$row['critical']."]";
>
> what do you get?
>
> --
>
> Bastien
>
> Cat, the other other white meat
>
> If I echo it I get the int that is in the field from the db fine...so it's
> something with my statement?
>
That all depends on WHAT it is you are getting.
Can you tell us WHAT you are getting? Not simply that "I get the int
that is in the field from the db". We don't have any idea what that
value is. Only you know that...
Got it..yay...
If (ctype_digit($row['critical'])){echo(" Critical violations found: ".
$row['critical'] .". ");
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] 2 ifs embedded?
Miller, Terion wrote:
>
>
> On 7/31/09 11:03 AM, "Miller, Terion" wrote:
>
>
>
>
> On 7/31/09 10:54 AM, "Jim Lucas" wrote:
>
> Miller, Terion wrote:
>>
>> On 7/31/09 10:14 AM, "Bastien Koert" wrote:
>>
>> On Fri, Jul 31, 2009 at 10:59 AM, Miller,
>> Terion wrote:
>>>
>>> On 7/31/09 9:53 AM, "Bastien Koert" wrote:
>>>
>>> On Fri, Jul 31, 2009 at 10:28 AM, Miller,
>>> Terion wrote:
On 7/31/09 8:58 AM, "m0s" wrote:
(!empty($row['notes']) && IsAlpha($row['notes']))
I tried that and this one:
If (!empty($row['notes']) && ctype_alpha($row['notes']))
It didn't display the notes at all...
And this one...doesn't display if the field has a 0 in it but I still need
it to?
If (!empty($row['critical']) && ctype_alnum($row['critical']))
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
>>> Hey Teri,
>>> Could the return from the db have a space or something in the value? Perhaps
>>>
>>> If (!empty($row['critical']) && ctype_alnum((int)$row['critical']))
>>>
>>> might work
>>>
>>>
>>> --
>>>
>>> Bastien
>>>
>>> Cat, the other other white meat
>>>
>>>
>>> It's got me stumped, tried it and it still will not echo if the field has a
>>> 0 in it:
>>>
>>> If (!empty($row['critical']) && ctype_alnum((int)$row['critical'])){
>>> echo(" Critical violations found: ". $row['critical'] .". ");
>>>
>> If you echo it out what is the value?
>>
>> echo "[".$row['critical']."]";
>>
>> what do you get?
>>
>> --
>>
>> Bastien
>>
>> Cat, the other other white meat
>>
>> If I echo it I get the int that is in the field from the db fine...so it's
>> something with my statement?
>>
>
> That all depends on WHAT it is you are getting.
>
> Can you tell us WHAT you are getting? Not simply that "I get the int
> that is in the field from the db". We don't have any idea what that
> value is. Only you know that...
>
>
> Numbers are in that field ... So I'm getting 0, 1, 2 etc however many
> violations there are, so why doesn't this work?
>
> If (ctype_alnum((int)$row['critical'])){echo(" Critical violations
> found: ". $row['critical'] .". ");
>
So, the only thing you will see is a number? Correct? What is the
range that the number will fall between?
And, does zero mean anything different then 1, 2, 3...
If, all you want to do is make sure that $row['critical'] is a number
and the value is within a range of numbers, so this.
if (
isset($row['critical']) &&
is_numeric($row['critical']) &&
in_array($row['critical'], range(0, 200))
} {
...
}
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] ForEach Range Problems
I have this script that works, just a couple tweeks needed...
1. I don't want it to default to A being selected
2. I need the number range part to only display one # sign not 10 of them,
somehow I have to have it pull any record that does not start with alpha
';
foreach(range('A','Z') as $c){
($letter == $c)
?
printf('%s ',$c)
: printf('%s ',$c,$c);
}
echo '';
//Other
foreach(range('0','9') as $n){
($letter == $n)
?
printf('%s ',$n)
: printf('# ',$n,$n);
}
echo
"";
?>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Namespace resolution performance implications
Hi Guys / Girls, We are transitioning our framework to use the namespaces which are available in php 5.3. I found an explanation of the resolution rules here : http://www.sitepoint.com/blogs/2009/07/14/php-namespaces-import-alias-resolution/ ( also listed below) and I was wondering what the performance implications of the different stages of name resolution are. For example for the code in the framework it's self would it be preferable to use a \Foo\Bar style fully qualified class names in order for the resolution to be done at compile time? Thanks in advance Andrew 1. Calls to fully-qualified functions, classes or constants are resolved at compile-time. 2. Unqualified and qualified names are translated according to the import rules, e.g. if the namespace A\B\C is imported as C, a call to C\D\e() is translated to A\B\C\D\e(). 3. Inside a namespace, all qualified names not already translated according to import rules have the current namespace prepended, e.g. if a call to C\D\e() is performed within namespace A\B, it is translated to A\B\C\D\e(). 4. Unqualified class names are translated according to current import rules and the full name is substituted for short imported name, e.g. if class C in namespace A\B is imported as X, new X() is translated to new A\B\C(). 5. Unqualified function calls within a namespace are resolved at run-time. For example, if MyFunction() is called within namespace A\B, PHP first looks for the function \A\B\MyFunction(). If that is not found, it looks for \MyFunction() in the global space. 6. Calls to unqualified or qualified class names are resolved at run-time. For example, if we call new C() within namespace A\B, PHP will look for the class A\B\C. If that is not found, it will attempt to autoload A\B\C. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Regex Problem
Hi Folks, I have a serious problem. must create a regular expression against all that is between single quote or double quotes. Easy? Ok, i know, but i need that "everything" must to be too an single quote or double quote. If i have this SQL command: SELECT * FROM TSTRENIC.MEI_ACESSO WHERE UPPER(DS_MEI_ACS) LIKE *'%NOME' ASD ' AS'ASD'%' *AND USUARIO = *'oaksdpokasd'asda'* ORDER BY DS_MEI_ACS ASC; SELECT * FROM TSTRENIC.MEI_ACESSO WHERE USUARIO_DATA BETWEEN *'2007-01-02'*AND *'2008-07-08'* Anyone have any idea? I need an expression which case the fields in bold. Regards, Igor Escobar Systems Analyst & Interface Designer + http://blog.igorescobar.com + http://www.igorescobar.com + @igorescobar (twitter)
Re: [PHP] ForEach Range Problems
On Fri, Jul 31, 2009 at 12:53 PM, Miller,
Terion wrote:
>
>
>
>
> I have this script that works, just a couple tweeks needed...
>
> 1. I don't want it to default to A being selected
> 2. I need the number range part to only display one # sign not 10 of them,
> somehow I have to have it pull any record that does not start with alpha
>
>
> $letter =
> isset($_GET['letter']) ? $_GET['letter'] :"A";
>
> echo ' align="center">';
>
> foreach(range('A','Z') as $c){
> ($letter == $c)
> ?
> printf('%s ',$c)
> : printf(' href="browse.php?letter=%s">%s ',$c,$c);
> }
>
> echo '';
> //Other
>
>
> foreach(range('0','9') as $n){
> ($letter == $n)
> ?
> printf('%s ',$n)
> : printf(' href="?letter=%s"># ',$n,$n);
> }
>
> echo
> "";
>
> ?>
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
How about
';
foreach(range('A','Z') as $c){
($letter == $c) ? printf('%s ',$c) : printf('%s ',$c,$c);
}
echo '';
//Other
$bNumberShown = false;
foreach(range('0','9') as $n){
if($letter == $n) {
printf('%s ',$n)
}else{
if ($bNumberShown){
printf('%s ',$n,$n);
}else{
printf('#%s ',$n,$n);
$bNumberShown = true;
}
}
echo "";
?>
--
Bastien
Cat, the other other white meat
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] ForEach Range Problems
On 7/31/09 12:27 PM, "Bastien Koert" wrote:
$letter = isset($_GET['letter']) ? $_GET['letter'] :"";
echo '';
foreach(range('A','Z') as $c){
($letter == $c) ? printf('%s ',$c) : printf('%s ',$c,$c);
}
echo '';
//Other
$bNumberShown = false;
foreach(range('0','9') as $n){
if($letter == $n) {
printf('%s ',$n)
}else{
if ($bNumberShown){
printf('%s ',$n,$n);
}else{
printf('#%s ',$n,$n);
$bNumberShown = true;
}
}
echo "";
Looks like it would work but I keep getting syntax error unexpected { at the
first
}else{
I have tried to move the brackets around but it just moves the error
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] ForEach Range Problems
On Fri, Jul 31, 2009 at 1:40 PM, Miller,
Terion wrote:
>
>
>
> On 7/31/09 12:27 PM, "Bastien Koert" wrote:
>
> $letter = isset($_GET['letter']) ? $_GET['letter'] :"";
>
> echo '';
>
> foreach(range('A','Z') as $c){
> ($letter == $c) ? printf('%s ',$c) : printf(' href="browse.php?letter=%s">%s ',$c,$c);
> }
>
> echo '';
>
> //Other
> $bNumberShown = false;
> foreach(range('0','9') as $n){
> if($letter == $n) {
> printf('%s ',$n)
> }else{
> if ($bNumberShown){
> printf('%s ',$n,$n);
> }else{
> printf('#%s ',$n,$n);
> $bNumberShown = true;
> }
> }
>
> echo "";
>
> Looks like it would work but I keep getting syntax error unexpected { at the
> first
> }else{
> I have tried to move the brackets around but it just moves the error
>
My bad, missed a closing curly brace on the foreach loop
';
foreach(range('A','Z') as $c){
($letter == $c) ? printf('%s ',$c) : printf('%s ',$c,$c);
}
echo '';
//Other
$bNumberShown = false;
foreach(range('0','9') as $n){
if($letter == $n) {
printf('%s ',$n)
}else{
if ($bNumberShown){
printf('%s ',$n,$n);
}else{
printf('#%s ',$n,$n);
$bNumberShown = true;
}
}
}
echo "";
?>
--
Bastien
Cat, the other other white meat
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] ForEach Range Problems
On 7/31/09 12:43 PM, "Bastien Koert" wrote:
On Fri, Jul 31, 2009 at 1:40 PM, Miller,
Terion wrote:
>
>
>
> On 7/31/09 12:27 PM, "Bastien Koert" wrote:
>
> $letter = isset($_GET['letter']) ? $_GET['letter'] :"";
>
> echo '';
>
> foreach(range('A','Z') as $c){
> ($letter == $c) ? printf('%s ',$c) : printf(' href="browse.php?letter=%s">%s ',$c,$c);
> }
>
> echo '';
>
> //Other
> $bNumberShown = false;
> foreach(range('0','9') as $n){
> if($letter == $n) {
> printf('%s ',$n)
> }else{
>if ($bNumberShown){
> printf('%s ',$n,$n);
> }else{
> printf('#%s ',$n,$n);
> $bNumberShown = true;
> }
> }
>
> echo "";
>
> Looks like it would work but I keep getting syntax error unexpected { at the
> first
> }else{
> I have tried to move the brackets around but it just moves the error
>
My bad, missed a closing curly brace on the foreach loop
';
foreach(range('A','Z') as $c){
($letter == $c) ? printf('%s ',$c) : printf('%s ',$c,$c);
}
echo '';
//Other
$bNumberShown = false;
foreach(range('0','9') as $n){
if($letter == $n) {
printf('%s ',$n)
}else{
if ($bNumberShown){
printf('%s ',$n,$n);
}else{
printf('#%s ',$n,$n);
$bNumberShown = true;
}
}
}
echo "";
?>
--
Bastien
Cat, the other other white meat
Argh still nothing just the blank page of death...
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] ForEach Range Problems
Miller, Terion wrote:
>
>
> On 7/31/09 12:43 PM, "Bastien Koert" wrote:
>
> On Fri, Jul 31, 2009 at 1:40 PM, Miller,
> Terion wrote:
>>
>>
>> On 7/31/09 12:27 PM, "Bastien Koert" wrote:
>>
>> $letter = isset($_GET['letter']) ? $_GET['letter'] :"";
>>
>> echo '';
>>
>> foreach(range('A','Z') as $c){
>> ($letter == $c) ? printf('%s ',$c) : printf('> href="browse.php?letter=%s">%s ',$c,$c);
>> }
>>
>> echo '';
>>
>> //Other
>> $bNumberShown = false;
>> foreach(range('0','9') as $n){
>> if($letter == $n) {
>> printf('%s ',$n)
>> }else{
>>if ($bNumberShown){
>> printf('%s ',$n,$n);
>> }else{
>> printf('#%s ',$n,$n);
>> $bNumberShown = true;
>> }
>> }
>>
>> echo "";
>>
>> Looks like it would work but I keep getting syntax error unexpected { at the
>> first
>> }else{
>> I have tried to move the brackets around but it just moves the error
>>
>
> My bad, missed a closing curly brace on the foreach loop
>
> $letter = isset($_GET['letter']) ? $_GET['letter'] :"";
>
> echo '';
>
> foreach(range('A','Z') as $c){
>($letter == $c) ? printf('%s ',$c) : printf(' href="browse.php?letter=%s">%s ',$c,$c);
> }
>
> echo '';
>
> //Other
> $bNumberShown = false;
> foreach(range('0','9') as $n){
>if($letter == $n) {
> printf('%s ',$n)
>}else{
> if ($bNumberShown){
>printf('%s ',$n,$n);
> }else{
>printf('#%s ',$n,$n);
>$bNumberShown = true;
> }
>}
> }
> echo "";
>
> ?>
>
> --
>
> Bastien
>
> Cat, the other other white meat
>
> Argh still nothing just the blank page of death...
Maybe you need a ; after printf('%s ',$n).
Also, maybe you need an editor with a syntax highlighter? You and PJ
should get together and decide on one.
--
Thanks!
-Shawn
http://www.spidean.com
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] ForEach Range Problems
--snip---
--
Well I almost have it with this, I keep getting an undefined index $letter
error though and then it outputs the $menu how do I fix that
//Create array with letters AND number sign $letters
= range('A','Z'); array_push($letters, '#');
$menu = '';
foreach($letters as $letter) { $menu .= ($letter
== $_GET['letter'])? sprintf('%s ',
$letter): sprintf('%s ', $letter, $letter);
}
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] ForEach Range Problems
On Fri, Jul 31, 2009 at 2:51 PM, Miller,
Terion wrote:
>
>
>
> --snip---
>
> --
> Well I almost have it with this, I keep getting an undefined index $letter
> error though and then it outputs the $menu how do I fix that
>
> //Create array with letters AND number sign
> $letters = range('A','Z'); array_push($letters,
> '#'); $menu = '';
> foreach($letters as $letter) {
> $menu .= ($letter == $_GET['letter']) ?
> sprintf('%s ', $letter) : sprintf(' href="browse.php?letter=%s">%s ', $letter, $letter);
> }
>
What if you just add a
$letters = '';
at the top?
--
Bastien
Cat, the other other white meat
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] ForEach Range Problems
On 7/31/09 1:56 PM, "Bastien Koert" wrote: $letters = ''; Nope still gives the same error: Notice: Undefined index: letter -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] ForEach Range Problems
On 7/31/09 2:00 PM, "Miller, Terion" wrote:
On 7/31/09 1:56 PM, "Bastien Koert" wrote:
$letters = '';
Nope still gives the same error: Notice: Undefined index: letter
Well getting closer with this but now my output menu is not a clickable link?
$letter =
isset($_GET['letter']) ? $_GET['letter'] :"";
//Create array with letters AND number sign
$letters = range('A','Z');
array_push($letters, '#');
$menu = ''; foreach($letters as $letter) {
$menu .= ($letter) ?
sprintf('%s', $letter) : sprintf('%s ', $letter, $letter);
}echo "{$menu}";
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: Regex Problem
The solution don't need to be with regex, if anyone can solve this with other way will be very helpfull . Regards, Igor Escobar Systems Analyst & Interface Designer + http://blog.igorescobar.com + http://www.igorescobar.com + @igorescobar (twitter) On Fri, Jul 31, 2009 at 2:23 PM, Igor Escobar wrote: > Hi Folks, > I have a serious problem. > > must create a regular expression against all that is between single quote > or double quotes. Easy? Ok, i know, but i need that "everything" must to be > too an single quote or double quote. > > If i have this SQL command: > > SELECT * FROM TSTRENIC.MEI_ACESSO WHERE UPPER(DS_MEI_ACS) LIKE *'%NOME' > ASD ' AS'ASD'%' *AND USUARIO = *'oaksdpokasd'asda'* ORDER BY DS_MEI_ACS > ASC; > > SELECT * FROM TSTRENIC.MEI_ACESSO WHERE USUARIO_DATA BETWEEN *'2007-01-02' > * AND *'2008-07-08'* > > Anyone have any idea? > > > > I need an expression which case the fields in bold. > > > Regards, > Igor Escobar > Systems Analyst & Interface Designer > > + http://blog.igorescobar.com > + http://www.igorescobar.com > + @igorescobar (twitter) > > > >
[PHP] Re: Regex Problem
Igor Escobar wrote:
> The solution don't need to be with regex, if anyone can solve this with
> other way will be very helpfull .
>
>
> Regards,
> Igor Escobar
> Systems Analyst & Interface Designer
>
> + http://blog.igorescobar.com
> + http://www.igorescobar.com
> + @igorescobar (twitter)
>
>
>
>
>
> On Fri, Jul 31, 2009 at 2:23 PM, Igor Escobar wrote:
>
>> Hi Folks,
>> I have a serious problem.
>>
>> must create a regular expression against all that is between single quote
>> or double quotes. Easy? Ok, i know, but i need that "everything" must to be
>> too an single quote or double quote.
>>
>> If i have this SQL command:
>>
>> SELECT * FROM TSTRENIC.MEI_ACESSO WHERE UPPER(DS_MEI_ACS) LIKE *'%NOME'
>> ASD ' AS'ASD'%' *AND USUARIO = *'oaksdpokasd'asda'* ORDER BY DS_MEI_ACS
>> ASC;
>>
>> SELECT * FROM TSTRENIC.MEI_ACESSO WHERE USUARIO_DATA BETWEEN *'2007-01-02'
>> * AND *'2008-07-08'*
>>
>> Anyone have any idea?
>>
>>
>>
>> I need an expression which case the fields in bold.
>>
>>
>> Regards,
>> Igor Escobar
>> Systems Analyst & Interface Designer
>>
>> + http://blog.igorescobar.com
>> + http://www.igorescobar.com
>> + @igorescobar (twitter)
>>
Not entirely sure I understand. You want to BOLD the things contained
in quotes and you put the * there to show that? If so, this is not tested:
$bolded = preg_replace('#([\'"])(.*?)\1#', '\1\2\1', $text);
--
Thanks!
-Shawn
http://www.spidean.com
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] ForEach Range Problems
On Fri, Jul 31, 2009 at 3:10 PM, Miller,
Terion wrote:
>
>
>
> On 7/31/09 2:00 PM, "Miller, Terion" wrote:
>
>
>
>
> On 7/31/09 1:56 PM, "Bastien Koert" wrote:
>
> $letters = '';
>
> Nope still gives the same error: Notice: Undefined index: letter
>
> Well getting closer with this but now my output menu is not a clickable link?
>
> $letter =
> isset($_GET['letter']) ? $_GET['letter'] :"";
> //Create array with letters AND number sign
> $letters = range('A','Z');
> array_push($letters, '#');
> $menu = ''; foreach($letters as
> $letter) { $menu .= ($letter)
> ? sprintf('%s', $letter) : sprintf(' href="browse.php?letter=%s">%s ', $letter, $letter);
> } echo " align=\"center\">{$menu}";
>
check the view source for the link to see what is happening to make it fail
--
Bastien
Cat, the other other white meat
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] ForEach Range Problems
On 7/31/09 3:08 PM, "Bastien Koert" wrote:
On Fri, Jul 31, 2009 at 3:10 PM, Miller,
Terion wrote:
>
>
>
> On 7/31/09 2:00 PM, "Miller, Terion" wrote:
>
>
>
>
> On 7/31/09 1:56 PM, "Bastien Koert" wrote:
>
> $letters = '';
>
> Nope still gives the same error: Notice: Undefined index: letter
>
> Well getting closer with this but now my output menu is not a clickable link?
>
> $letter =
> isset($_GET['letter']) ? $_GET['letter'] :"";
>//Create array with letters AND number sign
>$letters = range('A','Z');
> array_push($letters, '#');
> $menu = ''; foreach($letters as
> $letter) { $menu .= ($letter)
> ? sprintf('%s', $letter) : sprintf(' href="browse.php?letter=%s">%s ', $letter, $letter);
> }echo " align=\"center\">{$menu}";
>
check the view source for the link to see what is happening to make it fail
--
Bastien
Cat, the other other white meat
I finally got it working pretty much..next I just have to apply it to the query
so that if the user clicks the # it will pull the records that begin with a
number instead of letter from the db...
On the home stretch...
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Re: Regex Problem
Igor Escobar wrote: > No no, i need to make an regex to "match" the bold areas in my string. > Anything between single quotes or double quotes (including quotes and > double quotes). Understand? > > > Regards, > Igor Escobar > Systems Analyst & Interface Designer > > + http://blog.igorescobar.com > + http://www.igorescobar.com > + @igorescobar (twitter) > That's not going to happen without some other criteria. There is no way for the regex engine to guess at which sets of quotes belong inside another set of quotes. -Shawn -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Re: Regex Problem
Shawn McKenzie wrote: > Igor Escobar wrote: >> No no, i need to make an regex to "match" the bold areas in my string. >> Anything between single quotes or double quotes (including quotes and >> double quotes). Understand? >> >> >> Regards, >> Igor Escobar >> Systems Analyst & Interface Designer >> >> + http://blog.igorescobar.com >> + http://www.igorescobar.com >> + @igorescobar (twitter) >> > That's not going to happen without some other criteria. There is no way > for the regex engine to guess at which sets of quotes belong inside > another set of quotes. > > -Shawn Especially since in one of your examples you don't even have an even number of quotes. -- Thanks! -Shawn http://www.spidean.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] ForEach Range Problems
-snip---
So I'm almost almost there, but now when I click the # it shows me all records,
is my foreach range not right?
//Create array with letters AND number sign
$letters = range('A','Z');array_push($letters, '#');
$menu = '';
$selectedLetter = isset($_GET['letter']) ? $_GET['letter'] : null;
foreach($letters as $letter) {$menu .=
($letter == $selectedLetter) ? sprintf('%s ',
$letter) : sprintf('%s ', $letter, $letter);
}echo "{$menu}";
//Show all restaurants that start with $letter not between "A" and "Z"
$other = ctype_digit($letter);
foreach(range('0','9') as
$other) $sql = "SELECT
DISTINCT ID, name, address FROM restaurants WHERE name LIKE '{$other}%' ";
$result = mysql_query($sql)
or die(mysql_error());
while($row =
mysql_fetch_assoc($result)){
$name = $row['name'];
printf(
'%s%s',
$row['ID'],
$row['name'],
$row['address']
);
}
//Show all restaurants that
start with $letter$sql
= "SELECT DISTINCT ID, name, address FROM restaurants WHERE name LIKE
'{$selectedLetter}%'";
$result = mysql_query($sql) or die(mysql_error());
while($row = mysql_fetch_assoc($result)){
$name =
$row['name'];
printf(
'%s%s',
$row['ID'],
$row['name'],
$row['address']
);
}
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Clean break.
Whats the cleanest (I have a really ugly) way to break this:
[21/Jul/2009:00:00:47 -0300]
into:
date=21/jul/2009
time=00:00:47
Caveats:
1) if the day is < 10 the beginning of the string will look like "[1/...
2) the "-0300" will differ depending on DST or TZ. I don't need it
though, it just happens to be there.
This is what I have (it works unless day < 10):
$theParts = split("[\"]", $theCLF);
// IP and date/time
$tmpParts = explode(" ", $theParts[0]);
$theIP = $tmpParts[0];
$x = explode(":", $tmpParts[3]);
$theDate = str_replace("[","", $x[0]);
$theTime = "$x[1]:$x[2]:$x[3]";
the full text for this part looks like:
10.0.0.1 - - [21/Jul/2009:00:00:47 -0300] ... more stuff here
Anyway, any help would be appreciated.
thanks.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Can a range be passed to a query?
I'm still struggling with using ranges... Can they be passed to a query
somehow...
I have this so far but it pulls nothing:
//Show all with $letter not between "A" and "Z"
if ($selectedLetter = "#") {
$other = range('0','9');
$sql = "SELECT DISTINCT ID, name, address FROM restaurants WHERE name LIKE
'$other'";
$result = mysql_query($sql) or die(mysql_error());
}
while($row = mysql_fetch_assoc($result)){
$name = $row['name'];
printf(
'%s%s',
$row['ID'],
$row['name'],
$row['address']
);
}
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Clean break.
On Jul 31, 2009, at 5:22 PM, Paul Halliday
wrote:
Whats the cleanest (I have a really ugly) way to break this:
[21/Jul/2009:00:00:47 -0300]
into:
date=21/jul/2009
time=00:00:47
Caveats:
1) if the day is < 10 the beginning of the string will look like
"[1/...
2) the "-0300" will differ depending on DST or TZ. I don't need it
though, it just happens to be there.
This is what I have (it works unless day < 10):
$theParts = split("[\"]", $theCLF);
// IP and date/time
$tmpParts = explode(" ", $theParts[0]);
$theIP = $tmpParts[0];
$x = explode(":", $tmpParts[3]);
$theDate = str_replace("[","", $x[0]);
$theTime = "$x[1]:$x[2]:$x[3]";
the full text for this part looks like:
10.0.0.1 - - [21/Jul/2009:00:00:47 -0300] ... more stuff here
Anyway, any help would be appreciated.
thanks.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Since it's a fixed length value, what about just using substr() to
pull out the various bits?
Bastien
Sent from my iPod
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Script to Compare Database Structures
I know I CAN hack something together but I hate to reinvent the wheel. I want to be able to compare the structure of two different clients databases that might be on different servers that are firewalled away from each other. Given the two structures it will list all the SQL commands needed to make the database structure the same. In a perfect world on one side you would pull up a PHP page that does a "generate structure" which would create a downloadable file which you could then upload to the other system which would then give a listing of the SQL commands needed to make the local structure match the uploaded structure. Thanks in advance... Matt -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Can a range be passed to a query?
On Jul 31, 2009, at 5:24 PM, "Miller, Terion" > wrote:
I'm still struggling with using ranges... Can they be passed to a
query
somehow...
I have this so far but it pulls nothing:
//Show all with $letter not between "A" and "Z"
if ($
$result = mysql_query($sql) or die(mysql_error());
}
while($row = mysql_fetch_assoc($result)){
$name = $row['name'];
printf(
'%s%s',
$row['ID'],
$row['name'],
$row['address']
);
}
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
What about
selectedLetter = "#") {
$other = range('0','9');
$sql = "SELECT DISTINCT ID, name, address FROM restaurants WHERE left
(name, 1) between 0 and 9";
Bastien
Sent from my iPod
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: Clean break.
On Sat, 01 Aug 2009 00:22:21 +0300, Paul Halliday
wrote:
Whats the cleanest (I have a really ugly) way to break this:
[21/Jul/2009:00:00:47 -0300]
into:
date=21/jul/2009
time=00:00:47
...
Why not just use regexp ?
For example:
$string = "long text.. multiply lines...
[21/Jul/2009:00:00:47 -0300]
[ 1/Jul/2009:00:00:47 -0300]
[22/Jul/2009:00:00:47 -0300]";
preg_match_all('#\[([ 0-9a-zA-Z/]+):([0-9:]+)
[^]]+\]#',$string,$matches,PREG_SET_ORDER);
print_r($matches);
Output:
Array
(
[0] => Array
(
[0] => [21/Jul/2009:00:00:47 -0300]
[1] => 21/Jul/2009
[2] => 00:00:47
)
[1] => Array
(
[0] => [ 1/Jul/2009:00:00:47 -0300]
[1] => 1/Jul/2009
[2] => 00:00:47
)
[2] => Array
(
[0] => [22/Jul/2009:00:00:47 -0300]
[1] => 22/Jul/2009
[2] => 00:00:47
)
)
--
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Re: Clean break.
I was trying to stay away from regex as much as possible due to the
overhead? I might be wrong here.
This script will be parsing a lot of requests/sec. Thousands, maybe
more, which it also needs to toss into a DB. I want to try and keep it
as fast as possible. This is tricky when you don't know what you are
doing :). My coding is limited to hammering away at the search box on
php.net until I get a push in the right direction. It's just a hack
from there.
Using phpster's substr suggestion has already sped this up considerably.
2009/7/31 Ollisso :
> On Sat, 01 Aug 2009 00:22:21 +0300, Paul Halliday
> wrote:
>
>> Whats the cleanest (I have a really ugly) way to break this:
>>
>> [21/Jul/2009:00:00:47 -0300]
>>
>> into:
>>
>> date=21/jul/2009
>> time=00:00:47
>>
> ...
> Why not just use regexp ?
>
> For example:
>
> $string = "long text.. multiply lines...
> [21/Jul/2009:00:00:47 -0300]
>
> [ 1/Jul/2009:00:00:47 -0300]
>
> [22/Jul/2009:00:00:47 -0300]";
>
>
> preg_match_all('#\[([ 0-9a-zA-Z/]+):([0-9:]+)
> [^]]+\]#',$string,$matches,PREG_SET_ORDER);
>
> print_r($matches);
>
> Output:
> Array
> (
> [0] => Array
> (
> [0] => [21/Jul/2009:00:00:47 -0300]
> [1] => 21/Jul/2009
> [2] => 00:00:47
> )
>
> [1] => Array
> (
> [0] => [ 1/Jul/2009:00:00:47 -0300]
> [1] => 1/Jul/2009
> [2] => 00:00:47
> )
>
> [2] => Array
> (
> [0] => [22/Jul/2009:00:00:47 -0300]
> [1] => 22/Jul/2009
> [2] => 00:00:47
> )
>
> )
>
>
> --
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Script to Compare Database Structures
have you tried mysqldiff? ++Tim Hinnerk Heuer++ http://www.ihostnz.com (should be .org) Sponsors welcome to put ads under a linked to page. This is not automated just yet. Only image, swf or preferably text or short html ads, no animations please. Price negotiable. 2009/8/1 Matt Neimeyer > I know I CAN hack something together but I hate to reinvent the wheel. > > I want to be able to compare the structure of two different clients > databases that might be on different servers that are firewalled away > from each other. Given the two structures it will list all the SQL > commands needed to make the database structure the same. > > In a perfect world on one side you would pull up a PHP page that does > a "generate structure" which would create a downloadable file which > you could then upload to the other system which would then give a > listing of the SQL commands needed to make the local structure match > the uploaded structure. > > Thanks in advance... > > Matt > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > >
Re: [PHP] Can a range be passed to a query?
(Sorry, forgot to send this to the whole list.)
On Fri, Jul 31, 2009 at 05:24:45PM -0400, Miller, Terion wrote:
> I'm still struggling with using ranges... Can they be passed to a query
> somehow...
>
> I have this so far but it pulls nothing:
>
> //Show all with $letter not between "A" and "Z"
>
> if ($selectedLetter = "#") {
Problem #1: The above expression will set $selectedLetter to '#', *not*
check whether $selectedLetter is equal to '#'.
>
>$other = range('0','9');
>
> $sql = "SELECT DISTINCT ID, name, address FROM restaurants WHERE name LIKE
> '$other'";
Problem #2: The range() function returns an array (see documentation).
Echo the $sql variable to screen and you may find that it says:
"SELECT DISTINCT ... LIKE 'Array'"
Try this:
$values = implode(',', $other);
$sql = "SELECT DISTINCT ... LIKE '$values'";
(See documentation for implode().)
Paul
--
Paul M. Foster
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Script to Compare Database Structures
On Fri, Jul 31, 2009 at 05:38:44PM -0400, Matt Neimeyer wrote: > I know I CAN hack something together but I hate to reinvent the wheel. > > I want to be able to compare the structure of two different clients > databases that might be on different servers that are firewalled away > from each other. Given the two structures it will list all the SQL > commands needed to make the database structure the same. > > In a perfect world on one side you would pull up a PHP page that does > a "generate structure" which would create a downloadable file which > you could then upload to the other system which would then give a > listing of the SQL commands needed to make the local structure match > the uploaded structure. > > Thanks in advance... I don't know what flavor of SQL you're using, but for SQL-compliant databases, there is an "information_schema" table (I believe that's the correct name) which contains most or all of the data you need. Query that table into an array for each server, and compare the arrays. Here's a query I've used: SELECT table_name, column_name, data_type, column_default, is_nullable, character_maximum_length, numeric_precision, numeric_scale FROM information_schema.columns WHERE table_name = 'tablename' ORDER BY ordinal_position This will not tell you the relations between tables, nor which columns are primary keys, etc. There may be another way to get this out of information_schema. Paul -- Paul M. Foster -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Problem: Writing into Files?
Hi there, I've written a counter for my blog, which keeps the count of visitors in a file. However, when the visitors get too many, it resets to zero. Why? Here's the piece of code: [code] $f = $dir . '/view_counter' .EXT; $fp = fopen($f, "r"); $count =fgets($fp, 1024); fclose($fp); $fw = fopen($f, "w"); $cnew = $count + 1; $countnew = fputs($fw, $count + 1); return $cnew; [/code] I'm thinking this is caused by two visitors visiting the page at the same time; but is there a way to fix it, perhaps the reading/writing parameter? Thanks! -- --- Contact info: Skype: parham-d MSN: fire_lizard16 at hotmail dot com email: parham90 at GMail dot com
[PHP] clean url problem .htaccess
Hi I'm trying to use clean urls in my application: lets say convert http://mysite/article.php?id=3 to http://mysite/article/3/ my problem is to use /article act as it was /article.php here is mt .htacess : ForceType application/x-httpd-php on php code parsing string from $_SERVER['PHP_SELF'] to get id out. this one works if i use article.php (http://mysite/article.php/3/ works) but i want to use /article without php extention. is there a way around? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] ForEach Range Problems
On Fri, Jul 31, 2009 at 4:51 PM, Miller,
Terion wrote:
> //Show all restaurants that start with $letter not
> between "A" and "Z"
>
> $other = ctype_digit($letter);
>
> foreach(range('0','9') as $other) {
>
> $sql = "SELECT DISTINCT ID, name, address
> FROMrestaurants
> WHERE name LIKE '{$other}%' ";
>
> $result = mysql_query($sql) or die(mysql_error());
>
> while($row = mysql_fetch_assoc($result)){
>
> $name = $row['name'];
>
> printf(
> '%s%s'
> . '',
> $row['ID'],
> $row['name'],
> $row['address']
> );
> }
> }
Why are you running 10 individual queries to search for restaurants
whose name begins with a number?
There are (at least) two simple, sargable alternatives available that
will work in MySQL to do the work in one shot:
SELECT DISTINCT ID, name, address
FROMrestaurants
WHERE name LIKE '0%'
OR name LIKE '1%'
OR name LIKE '2%'
OR name LIKE '3%'
OR name LIKE '4%'
OR name LIKE '5%'
OR name LIKE '6%'
OR name LIKE '7%'
OR name LIKE '8%'
OR name LIKE '9%'
(It can use an index on the `name` column and it works, but it's
pretty verbose. Performance might suffer a little if it involves a
table scan because of the OR's, but I'm not sure about that.)
SELECT DISTINCT ID, name, address
FROMrestaurants
WHERE name >= '0' AND name < 'A';
(Its a lot shorter because it takes advantage of string collation. Any
string that begins with the character '0' will be greater than (or
equal if the string is exactly '0') than '0'.)
Also, if your table is set up correctly, you do not need the DISTINCT
keyword in your query. Each restaurant should appear exactly once in
the `restaurants` table.
And just for fun... do you have any restaurants in your list whose
name begins with a punctuation mark or some other non-alphanumeric
character? :-)
Andrew
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Can a range be passed to a query?
On Fri, Jul 31, 2009 at 5:55 PM, Phpster wrote: > What about > > $sql = "SELECT DISTINCT ID, name, address FROM restaurants WHERE > left(name, 1) between 0 and 9"; > > > > > Bastien > > Sent from my iPod You need to wrap the 0 and the 9 in single quotes, or else it returns everything. $sql = "SELECT DISTINCT ID, name, address FROM restaurants WHERE left(name, 1) between '0' and '9'"; Performance could be an issue, also. I tried this and the two versions I posted on her other thread against a table I have that has just over 8700 rows in it. This version took over 9 times longer to execute. (Granted, on a table that small it's still 0.0092 seconds compared to 0.0010 seconds. Either of those times is acceptable in my book, but on a larger table a 9x performance drain could be a serious issue.) That's because the engine has to examine every row in the table and calculate left(name, 1) before it can compare that value to the range. The other versions I posted can simply scan/seek the index within a range. Andrew -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] clean url problem .htaccess
On Sat, Aug 1, 2009 at 2:11 AM, A.a.k wrote: > Hi > I'm trying to use clean urls in my application: > lets say convert http://mysite/article.php?id=3 to > http://mysite/article/3/ > my problem is to use /article act as it was /article.php > here is mt .htacess : > > ForceType application/x-httpd-php > > on php code parsing string from $_SERVER['PHP_SELF'] to get id out. > > this one works if i use article.php (http://mysite/article.php/3/ works) > but i want to use /article without php extention. is there a way around? > Look up mod_rewrite. Andrew -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
