Re: [PHP] concat and join stuff
This is not really a PHP question, but a mysql question. Anyways, your query should work, as far as i can see. If you give the structure dumps and some relevant data dumps i don't mind to give it a try here. - http://devshed.excudo.net http://devshed.excudo.net -- View this message in context: http://www.nabble.com/concat-and-join-stuff-tp22874340p22999438.html Sent from the PHP - General mailing list archive at Nabble.com. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] user access/roles/privs functionality
bruce-60 wrote: Hi list... I need a way of managing users/teams/etc.. implementing roles/access rights/privs,etc... Have a look at Zend_Acl: http://framework.zend.com/manual/en/zend.acl.html - http://devshed.excudo.net http://devshed.excudo.net -- View this message in context: http://www.nabble.com/user-access-roles-privs-functionality-tp20508624p20620446.html Sent from the PHP - General mailing list archive at Nabble.com. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Weird pdo-mysql behavior
I agree, add some checks in your testcase so you can track exactly what is happening and see of what type your variables are. Also, try what happens when you - switch off persistent-connections (PDO::ATTR_PERSISTENT= false) - pass the object by reference (getClientFullName($id,$dbh)) - http://devshed.excudo.net http://devshed.excudo.net -- View this message in context: http://www.nabble.com/Weird-pdo-mysql-behavior-tp20478083p20496495.html Sent from the PHP - General mailing list archive at Nabble.com. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] mySQL query question
I would create a separate table for this (confirmation_numbers or something) with an autoincrement primary key. That way you can simply insert a new record for you contact and then ask (using mysql_insert_id()) what the confirmation number is. This approach is much safer as you can be 100% sure the number is unique and it's much less complicated. (of course you still need to check if the query didn't fail) - http://devshed.excudo.net http://devshed.excudo.net -- View this message in context: http://www.nabble.com/mySQL-query-question-tp20495466p20501473.html Sent from the PHP - General mailing list archive at Nabble.com. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Weird pdo-mysql behavior
What do you mean with 'stops working'? Also, have you created a test-script that only contains (what you think is) the core-problem? If so, can you paste it here? And if not, i advise you to make one, so you can exclude that other factors play a role here. Thodoris wrote: Hi list, I am developing something using PDO and I've noticed something weird that I want to share with you. I am creating a database handler in a script and I pass the handler to many functions I use in order to avoid creating a new connection into the function itself. Although this works in a compiled LAMP I have, this stops working when I use a prepackaged version of another LAMP I have. If I change the script in the non-working system and make the connection from inside the function using a new handler then everything works like a charm. Is there a chance that I am using a different configuration in say php.ini that can cause such behavior. Let me know what you think. -- Thodoris -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php - http://devshed.excudo.net http://devshed.excudo.net -- View this message in context: http://www.nabble.com/Weird-pdo-mysql-behavior-tp20478083p20478667.html Sent from the PHP - General mailing list archive at Nabble.com. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] ImageMagick functions
These classes contain methods which are just normal functions only residing in a class. pichoscosama wrote: When I look at online documentations of PHP I can not see ImageMagick functions. Only classes. What happened? -- Allah varsa çocuklar neden ölüyor ki? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php - http://devshed.excudo.net http://devshed.excudo.net -- View this message in context: http://www.nabble.com/ImageMagick-functions-tp20199962p20201449.html Sent from the PHP - General mailing list archive at Nabble.com. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Building an array, kind of?
Or, if your mysql version allows it: SELECT 1, GROUP_CONCAT(some_col) FROM history GROUP BY 1 LIMIT 0,16 That would take away the need to create a comma seperated string in php, because mysql will have already done it for you ;-) Dan Shirah wrote: TGIF? Apparently my brain isn't working this Friday. I'm trying to query my table to get the first 16 ID's. I then want to assign the ID's to a variable and have them comma seperated. // My query to select the first 16 rows $get_charges2 = SELECT FIRST 16 * FROM history WHERE id = '$id; // Executing the query $charge_result2 = ifx_query ($get_charges2, $connect_id); How would I assign the result to a variable? For instance, say my query returns rows like: 1234 1235 1236 1237 1238 1239 How would I go about putting that in a variable to equal 1234,1235,1236,1237,1238,1239 ? - http://devshed.excudo.net http://devshed.excudo.net -- View this message in context: http://www.nabble.com/Building-an-array%2C-kind-of--tp20151654p20162597.html Sent from the PHP - General mailing list archive at Nabble.com. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: re[PHP] declare classes dynamically
Defining multiple classes with the same name but different implementation doesn't seem like a good idea to me. Why did you choose to do this? also, have a look at this function: http://www.php.net/autoload i'm not sure what you're trying to accomplish exactly, but whatever it is, it might be helpfull :-) - http://devshed.excudo.net http://devshed.excudo.net -- View this message in context: http://www.nabble.com/redeclare-classes-dynamically-tp20106931p20109780.html Sent from the PHP - General mailing list archive at Nabble.com. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php