Re: [PHP] Re: 4/1/2013 3:46:37 AM
No spam filters for this list ? On Mon, Apr 1, 2013 at 5:46 AM, Adil Adil adil.dri...@yahoo.com wrote: http://www.siamphotographer.com/clvrcng/nikoffbkvvnjjcgwapmay.xmhpwcbrd -- Badea Sorin (unu.sorin) sorin.bade...@gmail.com unu_so...@yahoo.com Pagina personala: http://badeasorin.com
[PHP] Re: 4/1/2013 3:46:37 AM
On Mon, 1 Apr 2013 09:50:58 +0300, Sorin Badea wrote: No spam filters for this list ? On Mon, Apr 1, 2013 at 5:46 AM, Adil Adil adil.dri...@yahoo.com wrote: http://www.SLIME-BALL-SPAMMER.com/clvrcng/nikoffbkvvnjjcgwapmay.xmhpwcbrd Obviously not, BECAUSE YOU WERE ABLE TO RE-POST THE !$#@^%#*% URL FOR THE SLIME_BALL SPAMMMER!! -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] mysqli nested queries - maybe I'm rusty...
I am putting together an application where we are almost exclusively
using stored procedures in MySQL because most of the heavy lifting (as
it should be) is done in the database.
I have exactly one situation where I need to execute a stored procedure
and while returning the results if I run a across a particular value in
those results I need to execute another SP to handle. Because I have
forgotten which combination or store_result, use_result, fetch_row (not
to mention that fetch row doesn't have the column names in the array,
just the index) to use I am banging my head against the wall while
getting the dastardly 2014 Commands out of sync; error. Can someone
provide some insight please?
Assume that $mysqli is the connection -
$sql = CALL sp_ONE( . $product . , . $level . );
if(!$result = $mysqli-multi_query($sql)) {
echo Error: ( . $mysqli-errno . ) . $mysqli-error . on
Query . $sql;
} else {
do {
if($side = $mysqli-store_result()) {
/* output the list */
echo 'ul';
while($row = $side-fetch_row()) {
/* careful, column names aren't carried over */
echo 'li data-page=' . $row[2] . '' . $row[1] .
'/li';
/* do we need to do a another stored procedure? */
if(isset($row[3])) {
/* get the info */
$sql = CALL sp_TWO( . $product . , . $row[0] . );
if(!$subResult = $mysqli-multi_query($sql)) {
echo Error: ( . $mysqli-errno . ) .
$mysqli-error . on Query . $sql;
}
/* output the extra info */
echo 'ul';
while($sub = mysqli_fetch_array($subResult)) {
echo 'li data-page=' . $sub[1] . '' .
$sub[0] . '/li';
}
echo '/ul';
}
}
echo '/ul';
$side-close();
}
} while($mysqli-next_result());
}
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] A relative date puzzle
I'm looking for some ideas on how to handle the following get a datetime value that is relative to a specific future date when presented with a partial day time value. Specifically, I have an appl that requires some lengthy input involving days and times. I have streamlined the d/e effort so that it can be done entirely using the number keypad (if available), or else just with numeric entries. Works great, very quick (JS) and accurate. Basically the users type some numbers and end up with something like: Sat 08:00am or Fri 07:00pm etc. Does anyone have an idea on how I can convert this value to a true datetime value for my database updates, where the above value is relative to a specific date in the future? IE, the d/e takes place a few days before a certain upcoming date and I want my entry of Sat to translate to the Saturday following that certain date. This could take place one to two weeks prior to the start date, so just adding next to the value above won't work. I really need to incorporate a specific date in the solution. Thoughts anyone? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] A relative date puzzle
On 4/1/13 11:05 AM, Jim Giner wrote: I'm looking for some ideas on how to handle the following get a datetime value that is relative to a specific future date when presented with a partial day time value. Specifically, I have an appl that requires some lengthy input involving days and times. I have streamlined the d/e effort so that it can be done entirely using the number keypad (if available), or else just with numeric entries. Works great, very quick (JS) and accurate. Basically the users type some numbers and end up with something like: Sat 08:00am or Fri 07:00pm etc. Does anyone have an idea on how I can convert this value to a true datetime value for my database updates, where the above value is relative to a specific date in the future? IE, the d/e takes place a few days before a certain upcoming date and I want my entry of Sat to translate to the Saturday following that certain date. This could take place one to two weeks prior to the start date, so just adding next to the value above won't work. I really need to incorporate a specific date in the solution. Thoughts anyone? Use strtotime() to get a UNIX time stamp, then use date() to format it as you like. $myDate = strtotime(wed 11:00 am); //1365012000 echo date(Y-m-d H:i:s, $myDate); //2013-04-03 11:00:00 On two lines for clarity. Cheers, Mattias -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] A relative date puzzle
On 4/1/13 11:15 AM, Mattias Thorslund wrote: On 4/1/13 11:05 AM, Jim Giner wrote: I'm looking for some ideas on how to handle the following get a datetime value that is relative to a specific future date when presented with a partial day time value. Specifically, I have an appl that requires some lengthy input involving days and times. I have streamlined the d/e effort so that it can be done entirely using the number keypad (if available), or else just with numeric entries. Works great, very quick (JS) and accurate. Basically the users type some numbers and end up with something like: Sat 08:00am or Fri 07:00pm etc. Does anyone have an idea on how I can convert this value to a true datetime value for my database updates, where the above value is relative to a specific date in the future? IE, the d/e takes place a few days before a certain upcoming date and I want my entry of Sat to translate to the Saturday following that certain date. This could take place one to two weeks prior to the start date, so just adding next to the value above won't work. I really need to incorporate a specific date in the solution. Thoughts anyone? Use strtotime() to get a UNIX time stamp, then use date() to format it as you like. $myDate = strtotime(wed 11:00 am); //1365012000 echo date(Y-m-d H:i:s, $myDate); //2013-04-03 11:00:00 On two lines for clarity. Cheers, Mattias I'm sorry, I didn't read the last part of your question too closely. strtotime() should help you there as well. Just put the timestamp of the date to compare the string expression to as the second parameter. $relativeToDate = strtotime(2013-04-04); //1365058800 $myDate = strtotime(wed 11:00 am, $relativeToDate); //1365616800 echo date(Y-m-d H:i:s, $myDate); //2013-04-10 11:00:00 For more advanced date manipulation, there are the Date/Time functions but this is simple stuff. You can even do it OO-style with the DateTime class Co. Cheers, Mattias -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] A relative date puzzle
On 4/1/2013 2:32 PM, Mattias Thorslund wrote: On 4/1/13 11:15 AM, Mattias Thorslund wrote: On 4/1/13 11:05 AM, Jim Giner wrote: I'm looking for some ideas on how to handle the following get a datetime value that is relative to a specific future date when presented with a partial day time value. Specifically, I have an appl that requires some lengthy input involving days and times. I have streamlined the d/e effort so that it can be done entirely using the number keypad (if available), or else just with numeric entries. Works great, very quick (JS) and accurate. Basically the users type some numbers and end up with something like: Sat 08:00am or Fri 07:00pm etc. Does anyone have an idea on how I can convert this value to a true datetime value for my database updates, where the above value is relative to a specific date in the future? IE, the d/e takes place a few days before a certain upcoming date and I want my entry of Sat to translate to the Saturday following that certain date. This could take place one to two weeks prior to the start date, so just adding next to the value above won't work. I really need to incorporate a specific date in the solution. Thoughts anyone? Use strtotime() to get a UNIX time stamp, then use date() to format it as you like. $myDate = strtotime(wed 11:00 am); //1365012000 echo date(Y-m-d H:i:s, $myDate); //2013-04-03 11:00:00 On two lines for clarity. Cheers, Mattias I'm sorry, I didn't read the last part of your question too closely. strtotime() should help you there as well. Just put the timestamp of the date to compare the string expression to as the second parameter. $relativeToDate = strtotime(2013-04-04); //1365058800 $myDate = strtotime(wed 11:00 am, $relativeToDate); //1365616800 echo date(Y-m-d H:i:s, $myDate); //2013-04-10 11:00:00 For more advanced date manipulation, there are the Date/Time functions but this is simple stuff. You can even do it OO-style with the DateTime class Co. Cheers, Mattias Thanks for this - I'll experiment and see if I have it. Basically I never read the strtotime doc close enough to get past the word now in the syntax. Obviously it is EXACTLY what I needed. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] A relative date puzzle
Thanks for this - I'll experiment and see if I have it. Basically I never
read the strtotime doc close enough to get past the word now in the
syntax. Obviously it is EXACTLY what I needed.
$var = strtotime('now');
Is the same as
$var = time();
Unless of course, I didn't understand what you're referring too :P
But strtotime() is a very useful function, unless of course you want the OO
stuff ;)
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Is there a PHP based authentication library?
Hi, I stumbled upon this payment library: http://ci-merchant.org/ which abstracts the different payment backends away and exposes a new easy to use interface for the app developer to use. Thus making it very easy to use different payment providers. I was wondering if something like that is also existing for authentication? For example, in authentication you have quite a few different ones: - Mozilla Persona - openid - facebook connect - google (openid?) - use/pass based authentication (a.k.a. the self made version that every dev begins with) - oauth - twitter connect - etc... Is there such a library in existence? I'm especially looking for one with mozilla persona implemented. Kind regards, Mark -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Is there a PHP based authentication library?
On Mon, Apr 1, 2013 at 5:26 PM, Mark mark...@gmail.com wrote: Hi, I stumbled upon this payment library: http://ci-merchant.org/ which abstracts the different payment backends away and exposes a new easy to use interface for the app developer to use. Thus making it very easy to use different payment providers. I was wondering if something like that is also existing for authentication? For example, in authentication you have quite a few different ones: - Mozilla Persona - openid - facebook connect - google (openid?) - use/pass based authentication (a.k.a. the self made version that every dev begins with) - oauth - twitter connect - etc... Is there such a library in existence? I'm especially looking for one with mozilla persona implemented. Kind regards, Mark -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php https://github.com/openid/php-openid
Re: [PHP] Is there a PHP based authentication library?
Hi Mark, I think a simple Google search would be faster. Anyway, an unified way for 3rd party authentication doesn't exist from my knowledge, but for Persona you could use the sample from mozilla github account https://github.com/mozilla/browserid-cookbook . Good luck, Sorin! On Tue, Apr 2, 2013 at 12:26 AM, Mark mark...@gmail.com wrote: Hi, I stumbled upon this payment library: http://ci-merchant.org/ which abstracts the different payment backends away and exposes a new easy to use interface for the app developer to use. Thus making it very easy to use different payment providers. I was wondering if something like that is also existing for authentication? For example, in authentication you have quite a few different ones: - Mozilla Persona - openid - facebook connect - google (openid?) - use/pass based authentication (a.k.a. the self made version that every dev begins with) - oauth - twitter connect - etc... Is there such a library in existence? I'm especially looking for one with mozilla persona implemented. Kind regards, Mark -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- Badea Sorin (unu.sorin) sorin.bade...@gmail.com unu_so...@yahoo.com Pagina personala: http://badeasorin.com
Re: [PHP] Is there a PHP based authentication library?
On Tue, Apr 2, 2013 at 12:25 AM, David OBrien dgobr...@gmail.com wrote: On Mon, Apr 1, 2013 at 5:26 PM, Mark mark...@gmail.com wrote: Hi, I stumbled upon this payment library: http://ci-merchant.org/ which abstracts the different payment backends away and exposes a new easy to use interface for the app developer to use. Thus making it very easy to use different payment providers. I was wondering if something like that is also existing for authentication? For example, in authentication you have quite a few different ones: - Mozilla Persona - openid - facebook connect - google (openid?) - use/pass based authentication (a.k.a. the self made version that every dev begins with) - oauth - twitter connect - etc... Is there such a library in existence? I'm especially looking for one with mozilla persona implemented. Kind regards, Mark -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php https://github.com/openid/php-openid That's OpenID only. What i meant is one library with some plugin structure where you can add in a plugin for each authentication method. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Is there a PHP based authentication library?
On Tue, Apr 2, 2013 at 12:27 AM, Sorin Badea sorin.bade...@gmail.com wrote: Hi Mark, I think a simple Google search would be faster. Anyway, an unified way for 3rd party authentication doesn't exist from my knowledge, but for Persona you could use the sample from mozilla github account https://github.com/mozilla/browserid-cookbook . Good luck, Sorin! On Tue, Apr 2, 2013 at 12:26 AM, Mark mark...@gmail.com wrote: Hi, I stumbled upon this payment library: http://ci-merchant.org/ which abstracts the different payment backends away and exposes a new easy to use interface for the app developer to use. Thus making it very easy to use different payment providers. I was wondering if something like that is also existing for authentication? For example, in authentication you have quite a few different ones: - Mozilla Persona - openid - facebook connect - google (openid?) - use/pass based authentication (a.k.a. the self made version that every dev begins with) - oauth - twitter connect - etc... Is there such a library in existence? I'm especially looking for one with mozilla persona implemented. Kind regards, Mark -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- Badea Sorin (unu.sorin) sorin.bade...@gmail.com unu_so...@yahoo.com Pagina personala: http://badeasorin.com I couldn't find it on google thus i asked in the one place where - if it exists - people would probably know. I find it quite surprising that a library like this isn't in existence yet. I can imagine tons of sites would certainly benefit from having one generic interface to use. Anyway, thank you for your pointer and reply. If you (or anyone else) finds a lib for this, please don't hesitate to post it in here. :) -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Is there a PHP based authentication library?
I started building one at my last job, though it was part of a framework I was developing. I knew I was going to need to authenticate against both LDAP and old-fashioned database username/md5-password columns. (Ah, legacy user databases.) If it would be useful, I could dig out what I had and try to make it into a stand-alone set of functions, but I never got further than those two options. Basically there was a script that took in a username and password from a web form, then looked at a config file to decide which set of the sub-functions to use. For a DB, it checked to see if the username and hashed password matched a row in the database; for LDAP, it did some re-encoding to handle the weird encrypt that our OpenLDAP server used, then ran through the process of checking to see if the user actually had that as their password. Like I said, let me know if anyone wants to see it... I'm unemployed right now, and a project to work on this week (or next... this week is kind of busy) might be a good thing. -Andy McKenzie On Mon, Apr 1, 2013 at 6:49 PM, Mark mark...@gmail.com wrote: On Tue, Apr 2, 2013 at 12:27 AM, Sorin Badea sorin.bade...@gmail.com wrote: Hi Mark, I think a simple Google search would be faster. Anyway, an unified way for 3rd party authentication doesn't exist from my knowledge, but for Persona you could use the sample from mozilla github account https://github.com/mozilla/browserid-cookbook . Good luck, Sorin! On Tue, Apr 2, 2013 at 12:26 AM, Mark mark...@gmail.com wrote: Hi, I stumbled upon this payment library: http://ci-merchant.org/ which abstracts the different payment backends away and exposes a new easy to use interface for the app developer to use. Thus making it very easy to use different payment providers. I was wondering if something like that is also existing for authentication? For example, in authentication you have quite a few different ones: - Mozilla Persona - openid - facebook connect - google (openid?) - use/pass based authentication (a.k.a. the self made version that every dev begins with) - oauth - twitter connect - etc... Is there such a library in existence? I'm especially looking for one with mozilla persona implemented. Kind regards, Mark -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- Badea Sorin (unu.sorin) sorin.bade...@gmail.com unu_so...@yahoo.com Pagina personala: http://badeasorin.com I couldn't find it on google thus i asked in the one place where - if it exists - people would probably know. I find it quite surprising that a library like this isn't in existence yet. I can imagine tons of sites would certainly benefit from having one generic interface to use. Anyway, thank you for your pointer and reply. If you (or anyone else) finds a lib for this, please don't hesitate to post it in here. :) -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] php-fpm (5.4.13) takes up all cpu resources
Hi All, I have a strange problem with php-fpm, I checkd lots of document, but I can't fix it. I'm using a Freebsd 91 server to host my website. Nginx and php-fpm 5.4.13 and mysql are using. The hardware of my server is 12Core CPUs, 32G memory 6 HDD used as a Raidz2 array to host website 2 SSD used as a mirror array to host Database After I upgrade from 5.4.11 o 5.4.13, I got below problem. Usually, my system is in below status:(top) last pid: 52977; load averages: 4.70, 4.66, 5.55 301 processes: 2 running, 299 sleeping CPU: 6.5% user, 0.0% nice, 6.3% system, 0.9% interrupt, 86.3% idle Mem: 7029M Active, 11G Inact, 12G Wired, 1076M Cache, 399M Free ARC: 8412M Total, 3190M MFU, 1763M MRU, 624K Anon, 209M Header, 3249M Other Swap: 36G Total, 145M Used, 36G Free PID USERNAMETHR PRI NICE SIZERES STATE C TIME WCPU COMMAND 52728 www 1 250 150M 35564K accept 13 0:01 5.86% php-fpm 52735 www 1 250 150M 35416K accept 16 0:01 5.76% php-fpm 52740 www 1 250 150M 37668K accept 14 0:01 5.66% php-fpm 52739 www 1 240 150M 36424K accept 12 0:01 5.66% php-fpm 52708 www 1 240 150M 36324K accept 10 0:01 5.66% php-fpm 52724 www 1 240 150M 37740K select 16 0:01 5.57% php-fpm 52714 www 1 250 150M 36952K accept 21 0:01 5.57% php-fpm 52719 www 1 250 150M 37252K accept 23 0:01 5.57% php-fpm 52717 www 1 250 150M 39004K accept 12 0:01 5.57% php-fpm 52734 www 1 250 150M 37720K accept 18 0:01 5.57% php-fpm 52726 www 1 240 150M 37308K accept 23 0:01 5.47% php-fpm 52737 www 1 250 150M 37832K accept 14 0:01 5.37% php-fpm 52721 www 1 250 150M 36548K accept 22 0:01 5.37% php-fpm 52710 www 1 250 154M 38792K accept 16 0:01 5.37% php-fpm 52723 www 1 250 150M 35768K accept 10 0:01 5.37% php-fpm But sometimes, I found a php-fpm will take up about 25%+ cpu resource, then the cpu usage of php-fpm will get increased one by one. Then php-fpm will take up all CPU resources. Like below: last pid: 54212; load averages: 75.83, 75.55, 75.73 up 3+10:47:39 10:27:53 301 processes: 6 running, 295 sleeping CPU: 6.8% user, 0.0% nice, 95.2% system, 0.7% interrupt, 0.0% idle Mem: 7021M Active, 11G Inact, 12G Wired, 1358M Cache, 561M Free ARC: 8525M Total, 3438M MFU, 1619M MRU, 1866K Anon, 213M Header, 3253M Other Swap: 36G Total, 145M Used, 36G Free PID USERNAMETHR PRI NICE SIZERES STATE C TIME WCPU COMMAND 53939 www 1 310 150M 33096K accept 22 0:01 28.59% php-fpm 53941 www 1 310 154M 38144K accept 20 0:01 28.40% php-fpm 53938 www 1 300 150M 32816K accept 3 0:01 27.57% php-fpm 53677 www 1 520 150M 28440K accept 2 0:04 26.49% php-fpm 53948 www 1 270 150M 28964K accept 19 0:01 24.69% php-fpm 53947 www 1 260 150M 29272K accept 8 0:01 24.05% php-fpm 53951 www 1 250 150M 31208K accept 17 0:01 23.86% php-fpm 53953 www 1 240 150M 35300K accept 15 0:00 23.86% php-fpm 53950 www 1 250 150M 28268K accept 2 0:00 23.76% php-fpm 53954 www 1 240 150M 35476K accept 19 0:00 23.76% php-fpm 53955 www 1 240 150M 31292K accept 21 0:00 23.76% php-fpm 53956 www 1 240 150M 34064K accept 19 0:00 23.66% php-fpm 53962 www 1 240 150M 33224K CPU99 0:00 23.66% php-fpm 53960 www 1 240 150M 33548K CPU17 17 0:00 23.66% php-fpm Below is the php-fpm.slow. [01-Apr-2013 16:46:52] WARNING: [pool www] child 96623, script '/web/www/forum.php' (request: GET /forum.php) executing too slow (30.661218 sec), logging [01-Apr-2013 16:46:52] WARNING: [pool www] child 96620, script '/web/www/forum.php' (request: GET /forum.php) executing too slow (31.778921 sec), logging [01-Apr-2013 16:46:52] NOTICE: child 96764 stopped for tracing [01-Apr-2013 16:46:52] NOTICE: about to trace 96764 [01-Apr-2013 16:46:52] NOTICE: finished trace of 96764 [01-Apr-2013 16:46:52] NOTICE: child 96763 stopped for tracing [01-Apr-2013 16:46:52] NOTICE: about to trace 96763 [01-Apr-2013 16:46:52] ERROR: failed to ptrace(PT_IO) pid 96763: Bad address (14) [01-Apr-2013 16:46:52] NOTICE: finished trace of 96763 [01-Apr-2013 16:46:52] NOTICE: child 96762 stopped for tracing [01-Apr-2013 16:46:52] NOTICE: about to trace 96762 [01-Apr-2013 16:46:52] NOTICE: finished trace of 96762 [01-Apr-2013 16:46:52] NOTICE: child 96761 stopped for tracing [01-Apr-2013 16:46:52] NOTICE: about to trace 96761 The only way to fix this issue is to restart php-fpm. At first, I though it's a mysql error, but I monitorred mysql process, and I found that there is no slowlog. I tried to reinstall php, but this issue still
