addressalign-toparrow-leftarrow-rightbackbellblockcalendarcameraccwchatcheckchevron-downchevron-leftchevron-rightchevron-small-downchevron-small-leftchevron-small-rightchevron-small-upchevron-upcircle-with-checkcircle-with-crosscircle-with-pluscrossdots-three-verticaleditemptyheartexporteye-with-lineeyefacebookfolderfullheartglobegmailgoogleimageimagesinstagramlinklocation-pinmagnifying-glassmailminusmoremuplabelShape 3 + Rectangle 1outlookpersonplusprice-ribbonImported LayersImported LayersImported Layersshieldstartickettrashtriangle-downtriangle-uptwitteruseryahoo

Mailing List Archive

Subject Sender Date
Re: [php-49] I oops on the way IN (SQL) - Oops, needed to scroll up. Maybe it's the smart quotes instead of regular quotes? One of the joys of copying from an email. On 7/29/[masked]:10, max steinmetz wrote: > yes - the whole things works now once i put the single quotes into the > stri Tim B. Jul 29, 2016 12:14 PM
Re: [php-49] I oops on the way IN (SQL) - Ditto Adam's question. What data type are you using for CharID? On 7/29/[masked]:54, Adam Bassett wrote: > Max, > > > > So when you run it directly in MySQL like this: > > 'SELECT Codename, CharID > > FROM ma_Characters > > WHERE CharID IN ( Tim B. Jul 29, 2016 12:12 PM
Re: [php-49] I oops on the way IN (SQL) - yes - the whole things works now once i put the single quot max s. Jul 29, 2016 12:10 PM
RE: [php-49] I oops on the way IN (SQL) - Adam B. Jul 29, 2016 12:05 PM
Re: [php-49] I oops on the way IN (SQL) - Have your tried the following appro Alfredo J. Jul 29, 2016 12:00 PM
Re: [php-49] I oops on the way IN (SQL) - Hi Adam, In a max s. Jul 29, 2016 11:58 AM
RE: [php-49] I oops on the way IN (SQL) - Adam B. Jul 29, 2016 11:53 AM
Re: [php-49] I oops on the way IN (SQL) - I got the error the I originally asked about. But when i im max s. Jul 29, 2016 11:42 AM
RE: [php-49] I oops on the way IN (SQL) - Adam B. Jul 29, 2016 11:37 AM
Re: [php-49] I oops on the way IN (SQL) - Tim is right regarding my earlier var_dump, for Tim is (in max s. Jul 29, 2016 11:11 AM
RE: [php-49] I oops on the way IN (SQL) - Adam B. Jul 29, 2016 10:11 AM
RE: [php-49] I oops on the way IN (SQL) - Adam I'm pretty sure the quotes of the string are from var_dump and not part of the var itself On Jul 29,[masked]:57 AM, "Adam Bassett" < adam@bassettandbr Tim B. Jul 29, 2016 10:04 AM
Re: I oops on the way IN (SQL) - Looks right.  What  happens when you dump $sqlCharTags? On Jul 29,[masked]:45 AM, "Max" < [address removed] > wrote: Tim B. Jul 29, 2016 10:03 AM
RE: [php-49] I oops on the way IN (SQL) - Adam B. Jul 29, 2016 9:57 AM
I oops on the way IN (SQL) - Hi Folks - h max s. Jul 29, 2016 9:45 AM
Re: [php-49] SQL - The Sequel to my last SQL question - https://cdn.meme.am/instances/500x/64556979.jpg On 7/27/[masked]:51, Andrew wrote: > It depends upon your table structure and the relationships between them. > If your fields are in the joined table, you can add the field names to > the SELECT. > > Tim B. Jul 27, 2016 11:07 AM
Re: [php-49] SQL - The Sequel to my last SQL question - It depends upon your table structure and the relationships between them. If your fields are in the joined table, you can add the field names to the SELECT. Doing 1 extra SQL call to get a data set isn't necessarily a Andrew Jul 27, 2016 10:50 AM
Re: [php-49] SQL - The Sequel to my last SQL question - Thank you George and Andrew. I really can’t thank you eno max s. Jul 27, 2016 10:48 AM
Re: [php-49] SQL - The Sequel to my last SQL question - >  at school they tell us to do everything with a single call Generally you want to minimize the number of SQL calls, because George M. Jul 27, 2016 9:19 AM
Re: [php-49] SQL - The Sequel to my last SQL question - Thank you Andrew. max s. Jul 27, 2016 7:14 AM
Re: [php-49] SQL - The Sequel to my last SQL question - For Your SQL, the JOIN clause is incorrect. You want to be checking fields for equality between the two tables - because that's how they get connected. for example, something like this. Andrew Jul 26, 2016 10:46 PM
SQL - The Sequel to my last SQL question - Hi Folks, max s. Jul 26, 2016 6:57 PM
Re: [php-49] Dropdown stopped dropping down... - Thanks - i know i need to break things down more and I will max s. Jul 26, 2016 6:45 PM
Re: [php-49] Dropdown stopped dropping down... - The code you have above is kinda hard to read. You want to keep your logic and your display code separate as much as possible. I'd use one function to interact with the database. You'll return an array of objects or an arr Andrew Jul 26, 2016 5:10 PM
Re: [php-49] Dropdown stopped dropping down... - Thank you super muchly George. max s. Jul 26, 2016 1:21 PM
Re: [php-49] Dropdown stopped dropping down... - Thank you George - i know that micro/atomic commits are the max s. Jul 26, 2016 11:35 AM
Re: [php-49] Dropdown stopped dropping down... - You need to get used to using source control. Don't save backup copies of your files into the repository. Save a series of changes (commits) which can be used to recreate the file at that point in time. There are better backups wit George M. Jul 26, 2016 10:20 AM
Re: [php-49] Dropdown stopped dropping down... - Thank you Ryan for the notes and guidance. As usual, i’m max s. Jul 26, 2016 9:02 AM
Re: [php-49] Dropdown stopped dropping down... - I wouldn't have expected an <a> inside an <option> to ever work. If you really just want a list of links as opposed to a control that has a value, your second option is much better. You'll need some javascript to make it Ryan I. Jul 26, 2016 8:41 AM
Dropdown stopped dropping down... - Hi Folks, max s. Jul 26, 2016 8:01 AM
Re: [php-49] Speakers Have Been Announced. Did You Get Your Ticket? Early Bird Ends Soon! - Some corrections now that I spoke with my team again. :) I got too excited sending off an email. We may be extending our early bird special :) Tessa M. Jul 25, 2016 12:01 PM
Speakers Have Been Announced. Did You Get Your Ticket? Early Bird Ends Soon! - Hi All, This is a friendly reminder that speakers have been announced on our Pacific Northwest PHP Conference website. We are bringing a range of world renown speakers from everywhere, from the founder of La Tessa M. Jul 25, 2016 11:34 AM
Re: [php-49] Need a dropdown in handsontable. - OK sir. On Jul 25,[masked]:20 PM, "Andrew" < [address removed] > wrote: Ramesh K Jul 25, 2016 10:51 AM
Re: [php-49] Need a dropdown in handsontable. - I don't know. I've never heard of handontable before today. I didn't realize it was a JS library. I thought "handsontable" was the name of your database table. Have you looked at their documenation? Andrew Jul 25, 2016 10:49 AM
Re: [php-49] Need a dropdown in handsontable. - Andrew beat me to it - his solution looks very nice to m max s. Jul 25, 2016 10:24 AM
Re: [php-49] Need a dropdown in handsontable. - How can I use this in handsontable sir.? On Jul 25,[masked]:44 PM, "Andrew" < [address removed] > wrote: Ramesh K Jul 25, 2016 10:21 AM
Re: [php-49] Need a dropdown in handsontable. - Hey Ramesh, Each framework (WordPress vs Laravel vs Zend ) has it's own way of connecting to databases and running queries. Here is a simple way to do it outside of a framework.  For the following code to work Andrew Jul 25, 2016 10:14 AM
Need a dropdown in handsontable. - how can i show a dropdown in handsontable with values already stored in database. for example, am having a certain students name in db. now want to show all student name in dropdown which is saved in db using class. Ramesh K Jul 25, 2016 8:30 AM
Re: [php-49] Do you have the Time a minute from now? - how can i show a dropdown in handsontable with values already stored in database. for example, am having a certain students name in db. now want to show all student name in dropdown which is saved in db using class. please hel Ramesh K Jul 25, 2016 6:02 AM
Re: [php-49] Do you have the Time a minute from now? - Hey Max, This is a slightly different way to achieve a similar result. My initial time is based on the current time, where as the other results above are based on a known timestamp. Andrew Jul 23, 2016 10:02 PM
We need your help with PNWPHP - Hey Everyone, The Pacific Northwest PHP Conference (PNWPHP) is coming up in September. We are still in great need of sponsors. It's sponsorship that helps make things happen. We'd like for each of you to do 3 things to he Andrew Jul 23, 2016 5:59 PM
Re: [php-49] Do you have the Time a minute from now? - Yup, sorry. I missed copying $format into the top of the code sample. :-) And yes, I'll be in Seattle for PNWPHP! That reminds me: Y'all need to get your tickets!!! Check out the schedule Jeremy Cole L. Jul 23, 2016 12:17 PM
Re: [php-49] Do you have the Time a minute from now? - Oh… Thank you guys. It works for me know. Learned some nifty things and will dig into this more after lunch. thank you cheers everyone - m > On Jul 23, 2016, at 12:14 PM, Tim Bond wrote: > > Jeremy's snippet works fine fo max s. Jul 23, 2016 12:16 PM
Re: [php-49] Do you have the Time a minute from now? - Jeremy's snippet works fine for me; just have to set $format to something that date() recognizes https://3v4l.org/3VJ5L On 7/23/[masked]:10, max steinmetz wrote: > Hi Jeremy - so i tried all three and all three gave me white pages of death. > > Tim B. Jul 23, 2016 12:14 PM
Re: [php-49] Do you have the Time a minute from now? - Hi Jeremy - so i tried all three and all three gave me white pages of death. I added default max s. Jul 23, 2016 12:10 PM
Re: [php-49] Do you have the Time a minute from now? - Thank you Jeremy - i will explore these. Are y max s. Jul 23, 2016 11:59 AM
Re: [php-49] Do you have the Time a minute from now? - Ok. Uhm so i tried this as a retool. This didn’t worked. max s. Jul 23, 2016 11:58 AM
Re: [php-49] Do you have the Time a minute from now? - Hey Max, there are actually a few ways to do it, but it takes some reading in the PHP manual to fully understand each one, especially the last one. // Using strtotime() function (Easiest) $time = strtotime( Jeremy Cole L. Jul 23, 2016 11:56 AM
Re: [php-49] Do you have the Time a minute from now? - Look at your loop. There's nothing variable about it. You just have it wrapped in a for statement that executes the same thing 10 times. On 7/23/[masked]:40, max steinmetz wrote: > isn’t that what i was doing in the highlighted portion of the sni Tim B. Jul 23, 2016 11:42 AM
Re: [php-49] Do you have the Time a minute from now? - isn’t that what i was doing in the highlighted portion of max s. Jul 23, 2016 11:40 AM
Re: [php-49] Do you have the Time a minute from now? - Not exactly sure what your end goal is, but a loop that does an echo 12 times will execute in a few milliseconds, so time() is going to return the same thing on ever iteration. Maybe you meant time() + $x? On 7/23/[masked]:01, max steinmetz wrote: Tim B. Jul 23, 2016 11:18 AM
Do you have the Time a minute from now? - Hi folks and forks (spoons and knives too*), max s. Jul 23, 2016 10:00 AM
Re: [php-49] Comma Separated String No Separate? - Wow - the devil really is in the subtle details sometimes ( max s. Jul 20, 2016 5:18 PM
Re: [php-49] Comma Separated String No Separate? - It looks like your input string does not have a space after the comma, so you don't want to put a space after the comma in your delimiter. If you do that, PHP will look for 1, 2, 3, 4 instead of 1,2,3,4 Anand C. Jul 20, 2016 5:16 PM
Re: [php-49] Comma Separated String No Separate? - That was the first thing i tried but it didn’t work (for max s. Jul 20, 2016 5:13 PM
Re: [php-49] Comma Separated String No Separate? - Unless I'm misunderstanding something...It looks like you should be using explode(',' , $charTag); (the comma should be in single quotes, as the first argument passed to explode is the delimiter Anand C. Jul 20, 2016 4:50 PM
Comma Separated String No Separate? - So i’m trying to create a little string of comma separate max s. Jul 20, 2016 4:46 PM
Re: [php-49] dh-php5 - Looks like a helper library for Debian's (and related distributions) use of PECL. See here: https://packages.debian.org/si­d/dh-php David David M. Jul 18, 2016 8:23 PM
dh-php5 - Does anyone know what the dh-php and dh-php5 packages are on Ubuntu? When I Google it, I see plenty of places to acquire it but nothing explaining what it was. I see the changelog and the copyright on my system but neither explains what these packa Tim B. Jul 18, 2016 8:08 PM
Re: [php-49] Source code editors - How's Sublime's linter working out for you? On 7/18/[masked]:10, Siggi B wrote: > I've been using Netbeans but decided it really wasn't working for me. > After some research I settled on two candidates, PHPStorm and Sublime > Text. While they both se Tim B. Jul 18, 2016 10:28 AM
Re: [php-49] Source code editors - I've been using Netbeans but decided it really wasn't working for me. After some research I settled on two candidates, PHPStorm and Sublime Text. While they both seemed like very capable source code editors I ended up buying a licen Siggi B Jul 18, 2016 10:09 AM
Re: [php-49] Source code editors - I've been using PHP Storm for about 4+ years now and I have to second anything Andrew said. All those small details helps you write better code. Along its ability to index all your project's code, so you can easily go to, say, a function definitio Alfredo J. Jul 18, 2016 8:26 AM
Re: [php-49] Source code editors - If you work in languages other than PHP, I would recommend getting Jetbrains IntelliJ IDEA and installing the PHP plugin. That gets you at par with PHPStorm (same underlying editor, same product Shivaas G. Jul 17, 2016 5:48 PM
Re: [php-49] Source code editors - I've been doing the 30 day trial of PHP Storm. I started using it for the debugging tools, and integration with XDebug. I still use Vim a lot, but for developing more complex projects, I'm enjoying PHPStorm. I like that PHPStor Andrew Jul 17, 2016 12:27 PM
Re: [php-49] SQL - Do you have the time? - Hi Everyone, Again thank you all for all the notes - kind of overwhelming, very much appreciated too. With all t max s. Jul 17, 2016 12:21 PM
Re: [php-49] My First PDO problem - Hi George. Actually I tried to prevent misconception (but I am not sure) Yes, I follow this topic and I know the context of discussion :)   Maybe, I should post a general e-mail and explain what is PDO, Prepared State Bahruz A. Jul 17, 2016 11:10 AM
Re: [php-49] SQL - Do you have the time? - Thank you everyone…. So like, i max s. Jul 17, 2016 10:48 AM
Re: [php-49] SQL - Do you have the time? - Hi Max The problem you're describing is something that has definitely been solved before, so you'll find lots of resources on how to do it. The way that most CMSes like Joomla or Wordpress do it is with a few data Chad W. Jul 17, 2016 10:44 AM
Re: [php-49] SQL - Do you have the time? - checkout  https://dev.mysql.com/doc/refm­an/5.5/en/date-and-time-functi­ons.html where you can do all sorts of cool shit with your dates.  Todd C. Jul 17, 2016 10:43 AM
Re: [php-49] SQL - Do you have the time? - In this case there is no "right way". If Wordpress had forced people to set up cron jobs to get this sort of basic functionality, there's no way it would have the market share it does. But it is often maligned *because* it does these types of things Tim B. Jul 17, 2016 10:32 AM
Re: [php-49] Source code editors - Exactly. The cost of learning a new IDE was the reason for my reluctance, especially since my previous experiences with PHP IDEs (NetBeans and Zend) was disappointing. I used VIM primarily for quite some time, because I was very comfortable George M. Jul 17, 2016 10:31 AM
Re: [php-49] SQL - Do you have the time? - I want it to teach me to do things the right way and not make my friends cringe when they think ‘oh my god he did what now…?’. My site is, in the end, all about me and me learning things and learning to do them well and in a proper way so i can sit max s. Jul 17, 2016 10:29 AM
Re: [php-49] SQL - Do you have the time? - Sounds more like a blog than a forum, with scheduled posts and all. PHP's most popular project has this functionality. It has a different way to go about doing this, but both are valid approaches. You need to calculate the visibility changes (exp Tim B. Jul 17, 2016 10:26 AM
Re: [php-49] SQL - Do you have the time? - I’m gonna have a messy messy week - where are my overalls max s. Jul 17, 2016 10:14 AM
Re: [php-49] SQL - Do you have the time? - A typical way of dealing with this is to store timestamps. This is the number of seconds since some date, referred to as the beginning of the Unix epoch, which is January 1, 1970 GMT. You would then deal with time zone issues when convertin George M. Jul 17, 2016 10:12 AM
Re: [php-49] My First PDO problem - Heh, that was for Bahruz, not you Max. > 1. What is a positional parameter? If you use question marks in your SQL, instead of named parameters, you're using positional parameters. You George M. Jul 17, 2016 9:52 AM
SQL - Do you have the time? - Hi, i’m working on a create table statement for my silly max s. Jul 17, 2016 9:35 AM
Re: [php-49] Source code editors - FWIW, I've been using Netbeans, primarily because of its well-integrated Chrome plugin for testing. On Jul 17, 2016, at 9:10 AM, Daniel Jul 17, 2016 9:16 AM
Re: [php-49] Source code editors - So your saying it’s like ‘How much is your time worth� max s. Jul 17, 2016 9:14 AM
Re: [php-49] Source code editors - And, this thread beings anew. (Thanks for breaking it out Tim.) I highly recommend PhpStorm. I was reluctant to give it a try, after some disappointing issues with Zend IDE. I finally tried it a few years ago, and I George M. Jul 17, 2016 9:10 AM
Re: [php-49] My First PDO problem - No no George, I didn’t think anything you wrote was an ov max s. Jul 17, 2016 9:09 AM
Re: [php-49] My First PDO problem - I'm sorry if you thought that was an oversimplification, but I think you missed the point. In the context of this discussion, the point of PDO is to avoid SQL injection attacks. For Max (who is not a professional dev) George M. Jul 17, 2016 8:57 AM
Re: [php-49] My First PDO problem - Everyone i know recommends PhPStorm, max s. Jul 17, 2016 8:34 AM
Re: [php-49] Source code editors - PhpStorm https://www.jetbrains.com/phps­torm/ On Jul 17,[masked]:22 AM, "Ramesh K" < [address removed] > wrote: Tim B. Jul 17, 2016 1:06 AM
Re: [php-49] My First PDO problem - Please give me a suggestion for source code editors for php On Jul 17,[masked]:44 AM, "max steinmetz" < [address removed] > wrote: Ramesh K Jul 16, 2016 11:49 PM
Re: [php-49] My First PDO problem - I believe i got it working :D max s. Jul 16, 2016 9:06 PM
Re: [php-49] My First PDO problem - I’m still hammering on this and thought I’d send an update for any curious or really bored. max s. Jul 16, 2016 7:22 PM
Re: [php-49] My First PDO problem - Hi Folks, Still hammering on this. Still confused. I thought perhaps the issue was that i wa max s. Jul 16, 2016 5:25 PM
Re: [php-49] My First PDO problem - Thank you George, your notes were greatly appreciated as are those from Conor and Chad. Stil max s. Jul 16, 2016 12:14 PM
Re: [php-49] My First PDO problem - '" The point of using PDO is, basically, to get the parameters into the query in a safe manner. "  [ Bahruz A. Jul 16, 2016 12:11 PM
Re: [php-49] My First PDO problem - The point of using PDO is, basically, to get the parameters into the query in a safe manner. Safe, as in someone can't input a value that causes problems. Problems like:  https://xkcd.com/ George M. Jul 16, 2016 9:19 AM
Re: [php-49] My First PDO problem - Hi Guys, I tried to follow your advice, but i just got more and more confused i think. I don max s. Jul 16, 2016 7:38 AM
Re: [php-49] My First PDO problem - Yep conor is probably right, use the update / set syntax. Also you may want to look into named PDO placeholders, which makes it a bit easier to identify and then bind to them: Chad W. Jul 16, 2016 4:27 AM
Re: [php-49] My First PDO problem - Hey Max,  Not really a PDO issue, I think you just confused your UPDATE and INSERT sql syntax.  The update command should look like  & conor Jul 15, 2016 9:54 PM
My First PDO problem - Hi folks, working with PDO finally and i’ve hit my first max s. Jul 15, 2016 8:26 PM
Re: [php-49] Javascript has me by the hook - Thank you Bob - I had to fiddle with it just a bit, mostly i had to remove everything i did and bring the script back to the starting point, then applied what you suggested and its now a very spiffy little ui effect. Thank you very much for max s. Jul 14, 2016 3:14 PM
Re: [php-49] Javascript has me by the hook - Thank you Bob, I will try that. I'm still just a php hobbist and only now pushing into all this other stuff which is very interesting but really confusing at times. Again Thank you for the suggestion. max s. Jul 14, 2016 12:12 PM
Re: [php-49] Javascript has me by the hook - Looks like jQuery's one() function only binds once. " The  Bob A. Jul 14, 2016 11:40 AM
Javascript has me by the hook - I’ve attempted and reattempted to imp max s. Jul 14, 2016 9:11 AM
Re: [php-49] caught up in an uncaught exception (PDO works though) - Yes that is indeed the line with the error. https://github.com/monkeework/WrDK/commit/744d43039a2fb7317d96a75fbd5f312358760396#commitcomment[masked] On 7/12/[masked]:56, max steinmetz wrote: > Hi folks - so i’ve jumped into the PDO pool and so fa Tim B. Jul 12, 2016 10:57 AM

Our Sponsors

  • TUNE

    Meeting space and food

  • PluralSight

    PluralSight subscriptions for developer training

  • O'Reilly

    Disc Code: PCBW is good for 40% off print and 50% off ebooks and videos

  • JetBrains PhpStorm

    Occasional free licenses to raffle off at meetups

People in this
Meetup are also in:

Sign up

Meetup members, Log in

By clicking "Sign up" or "Sign up using Facebook", you confirm that you accept our Terms of Service & Privacy Policy