[Zend Certification]

thats downright sneaky!   

[Zend Certification]

lol i would have gotten that question wrong, needle before haystack seems more intuitive to me

[Zend Certification]

I think it's too easy. Anyway, you'll have to show up at a test center. The test is a closed book multiple choice test spanning 90 minutes. Some questions have multiple answers, and some do only have a single answer. You won't have to actually write any code yourself. You'll need knowledge in OOP/OOD, security, XML, web services and features, string manipulation, regular expressions, streams and network programming, syntax, and databases.

 

Personally, I do not regard it very highly, but potential employers may have another opinion. However, if you want it, by all means, go for it. If you know your stuff then you should have plenty of time to complete it.

 

thanks for the reply!

 

I know my stuff but there's certain things like XML and Streams that I'm gonna have to read up on...haven't used XML since I discovered JSON

 

Here in Brazil not many people have it so I figured it'd be a good thing for me to have

[Zend Certification]

I've decided to take the next step and get my ZCE Certification next month.  I'm in a position where I have some extra free time so I can afford to study a bit and think it'll be good for me professionally.

 

I got a Study Guide but it just lists every topic you're expected to know but doesn't actually tell you anything about the exam (is it by hand, by computer?  multiple choice?  code?  etc?)

 

Wondering if anyone here is certified and if there's any tips they can give.

 

Thanks!

 

-Alex

[Help with script please]

im not sure i get what you mean and also there's no UPDATE queries anywhere in there, so the DB never changes...

 

also, just a quick tip change the WHERE id LIKE xxx to WHERE id = xxx

[Header is not going to the location specified]

just tried this out, its missing the "http://"

 

if you dont specify the protocol, it assumed its a local path so it will look for a folder called www.yahoo.com 

[Apache to LightTPD Simple Rewrite?]

gonna hop on this thread if you don't mind cause i have a very similar question

I was wondering if Lighttpd had a similar mod_rewrite, i guess it does

[Yii framework]

Heard awesome things about it, anyone have any hands-on experience?

 

yii

[help me pick a new IDE]

at the moment all i code is PHP and related web stuff like Javascript, CSS, XML, etc

 

but at uni we have Java and also C# classes and in my free time im trying to learn Flex so I guess Eclipse is pretty solid in that respect as the only language it doesn't support is .NET and frankly i hate it and only use it for uni assignments...

 

I'm just wrapping up a project I have to deliver this week, then I'll have some time to mess around with other IDEs and see which one jells for me

[Search function issues]

thats a lot to go through, would really help me if you posted a screenshot of the search form so i could understand how all the different options fit in together

 

and just by taking a glance at it this comes up kinda often:

WHERE pitchid=pitchid

you should change that to:

pitchid='$pitchid'

 

might do the trick

[help me pick a new IDE]

I just got an open source IDE called aptana... its pretty good, i would give it a shot.

 

man i just took a look at the website and it looks awesome! 

 

one thing that always pissed me off about dreamweaver was its piss-poor PHP code completion and this has even got a jQuery plugin... sweet!

 

downloading now, gonna try it on a new project asap!

 

thx!

[[SOLVED] fake subdomains]

thanks for the replies, someone on another forum showed me a link that solved my problem

 

someone should sticky this...

 

using mod_rewrite for fake subdomains

[help me pick a new IDE]

dude, actually "regular exasperation" is usually correct 

 

and thanks for the suggestions, gonna take a look at the open-source one, i have netbeans installed too for java and i think its the full version so ill give that a shot too

[help me pick a new IDE]

hey all,

getting kinda frustrated lately with the amount of extra work im doing debugging a script...

 

i started php using dreamweaver a couple years ago im not sure why and i like it for doing the whole front-end thing, but really its very limited as a PHP development tool.

 

i constantly find myself polluting my scripts with echos and var_dumps and whatnot and its a real pain in the ass debugging.

 

i loved the good ol VB6 days when i could set breakpoints and step through functions and stuff and this is pretty standard stuff.

 

SO,

can anyone please suggest me a better IDE?

 

thx! 

[[SOLVED] fake subdomains]

searched both the forums and google and haven't found anything that works...

 

here's the deal (and i can see this is pretty popular too):

 

URL: one.mydomain.test

REDIRECT: mydomain.test/redir.php?sub=one

 

and so on... whatever the subdomain used i want it to be passed as a GET variable to the file redir.php

 

i'm running xampp on windows and i've already set up a virtual host and enabled ServerAlias *.mydomain.test and www.mydomain.test works fine

 

here's my htaccess:

RewriteEngine On
RewriteCond %{HTTP_HOST} !^www\.mydomain\.test
RewriteCond %{HTTP_HOST} ([^.]+)\.mydomain\.test
RewriteRule ^(.*)$ /redir.php?sub=%1 [R,L]

 

whenever i try to access any subdomain (or even just mydomain.test - without the www) i get a page not found error...

 

can anyone please help?

[strip url before sql insert]

oh and if you meant the first option like just get rid of the start and end parts you can probably use string functions to locate the 'http://', 'www' and all occurences of '.' so you probably will just need to identify the limits and extract a substring

 

(not as elegant as using preg_replace)

[strip url before sql insert]

you want to just store the parts in the middle of the url?

 

www.phpfreaks.com would become phpfreaks ?

 

its perfectly safe to replace special html entities, espace strings and just store the entire thing...either way if you search the forums there's tons of example and PHP also has a set of built in "filter" functions...

[Send IM Via PHP or Email]

I've got one but it only works locally (Brazil)

 

either way, you obviously haven't been looking in the right places

[How to delete session cookies?]

I was pretty sure you could just:

 

unset($_COOKIE['varname'])

 

is there something I'm missing?

 

ps - also, instead of an empty string if I'm not mistaken you can just assign the value NULL to effectively delete the cookie (not sure about this one)

 

Alex

[[Query] Left join, AVG, invalid use of group function]

try this:

 

- run the query without the GROUP BY clause and see if it returns the correct info

 

- if yes, try

GROUP BY score

(using the alias you gave it) - not sure if this has any impact at all but I'd try anyway to see what happens

- if not, make sure pictures.gender is storing an integer value because that's what you're comparing it with in your WHERE clause....again, I'm not sure how forgiving MySQL is with treating a string of numbers ("123") with a number (123) but if its not selecting anything try that

 

without a similar db schema to run queries against its kind of hard to test...

gl!

[Date field not working correctly]

again without the code we're limited to guessing, but probably something do with the way your script and MySQL represent dates (MySQL is yyyy-mm-dd) and most people do (dd-mm-yyyy) so maybe its just not recognizing the date you give it as valid and filling in a default value (which happens to be the current date?

[more expensive to run multiple queries or select * and manipulate in PHP?]

So you're second query would be the same query just with a different WHERE clause?

 

Actually the SELECT clause might change too (from the example: stats.time wasn't even selected in the initial query and then as in the new query), in fact, the only thing that remains constant is the table name...

 

Maybe this would be a good scenario to play with prepared statements 

 

SELECT ? FROM stats WHERE ? LIMIT ?

???????) (gotta read up on this)

 

but either way corbin thanks for clearing it up about multiple queries, i had a feeling that might be the case but always good to get confirmation!

[more expensive to run multiple queries or select * and manipulate in PHP?]

So what exactly would you be filtering?  Not quite sure I see your problem/question.

 

that was just one example!

 

i'm gonna have to mostly re-order and hide subsets of the resultset (which as far as i know is ok to do with arrays) but for example there's a time column, remember that so far is not used. 

 

through the gui the user will be able to select filters and format the data the way he wants.  so he might for example decide to filter only the results from the last 7 days for example.

 

in that case (assuming 800 results), as far as i know its definitely more efficient to perform another query than to filter the entire array (also because you might have to sort it first to avoid iterating through all results)

 

know what I mean?

 

I've been adopting some practices recently and I'm kinda curious as to how they compare to proven methods of achieving the same thing. 

[got problem on mysql]

true, i had no idea what MoveLast was so i did some quick research and for some reason assumed it just returned the last item in the result set (my solution) and not the entire result set with the internal pointer at the end (yours)

[Reset ID Field]

EDIT: note you can also do this to force the next auto increment id to a certain value (not sure how this behaves if you specify a taken value, but im pretty sure it'll work like the above function and get the largest auto inc + 1

SET insert_id = 1;

I've never heard of that.

 

If you're starting again fresh, you can use TRUNCATE to empty the table properly, instead of DELETE.

 

that's the point:

 

delete only the id column, not the entire table!!  then re-create it as auto-inc (and possibly reset the counter by using ALTER TABLE) and it will assign new numbers.

 

and about "SET insert_id" look it up its in the manual