[PHP-DB] Hello

2009-12-13 Thread Karl DeSaulniers
Hi I am new to this list. I am in need of some help or direction. I am new to php and databases, so forgive me if my request seems too simple. I am making a database if users and have had much success in getting it to work however, not all my data is getting shown once I try to display

Re: [PHP-DB] Hello

2009-12-13 Thread Karl DeSaulniers
HI, Thanks for your response. Here is my query. UserID is auto incrament and UserLastLogin is a current_timestamp. $query_users = INSERT INTO users(UserID, Username, UserEmail, UserPassword, UserFirstName, UserLastName, UserCompany, UserAddress, UserAddress2, UserCity, UserState,

Re: [PHP-DB] Hello

2009-12-14 Thread Karl DeSaulniers
, visit: http://www.php.net/unsub.php Karl DeSaulniers Design Drumm http://designdrumm.com

Re: [PHP-DB] Hello

2009-12-14 Thread Karl DeSaulniers
What does this do exactly? Documentation was a bit fuzzy for me. Is it needed at all times to protect with? On Dec 14, 2009, at 8:22 PM, Karl DeSaulniers wrote: mysql_real_escape_string() Karl DeSaulniers Design Drumm http://designdrumm.com

Re: [PHP-DB] Hello

2009-12-15 Thread Karl DeSaulniers
So what's the difference with that and addslashes() ? Karl Sent from losPhone On Dec 15, 2009, at 3:50 PM, Chris dmag...@gmail.com wrote: Karl DeSaulniers wrote: What does this do exactly? Documentation was a bit fuzzy for me. Is it needed at all times to protect with? Per the docs

Re: [PHP-DB] Random pick

2009-12-19 Thread Karl DeSaulniers
Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php Karl DeSaulniers Design Drumm http://designdrumm.com

[PHP-DB] Displaying Password

2009-12-22 Thread Karl DeSaulniers
); } //hide pasword But I keep getting a paramiters error for str_replace. Warning: Wrong parameter count for str_replace() in blah, blah, blah Doesn't strlen return a number value? Thanks in advance. Karl DeSaulniers Design Drumm http://designdrumm.com

Re: [PHP-DB] Displaying Password

2009-12-22 Thread Karl DeSaulniers
Message Date: Monday, December 21, 2009 11:12:48 PM -0600 From: Karl DeSaulniers k...@designdrumm.com To: php-db@lists.php.net Subject: [PHP-DB] Displaying Password Never mind. Got it. $replaceArray = array('a', 'b', 'c', 'd', 'e', 'f', 'g', 'h', 'i', 'j', 'k', 'l', 'm', 'n', 'o

Re: [PHP-DB] Displaying Password

2009-12-22 Thread Karl DeSaulniers
with that. You should try The next code: $UserPassword = str_repeat(#8226;, strlen($UserPassword)); Enjoy. (I hope that you are not a programmer) -- From: Karl DeSaulniers k...@designdrumm.com Sent: Tuesday, December 22, 2009 6:12 AM To: php-db

Re: [PHP-DB] Displaying Password

2009-12-22 Thread Karl DeSaulniers
recently.) http://uk2.php.net/manual/en/function.mcrypt-decrypt.php Regards, Andy Karl DeSaulniers Design Drumm http://designdrumm.com

Re: [PHP-DB] Displaying Password

2009-12-22 Thread Karl DeSaulniers
Thanks for the tip on the mcrypt. I actually had read up a little about it. I will have to investigate more now. Thanks for the suggestion. Karl On Dec 22, 2009, at 4:54 PM, Karl DeSaulniers wrote: Hi Andy, Sorry, I guess I should have explained better. I was speaking about what comes up

Re: [PHP-DB] Displaying Password

2009-12-22 Thread Karl DeSaulniers
Date: Tuesday, December 22, 2009 04:40:22 PM -0600 From: Karl DeSaulniers k...@designdrumm.com Subject: Re: [PHP-DB] Displaying Password Hi Rick, Yes you are correct. I do not store a plan text password. The conversion code is so they cant read the encryption either. If you cant read

Re: [PHP-DB] Displaying Password

2009-12-22 Thread Karl DeSaulniers
are not a programmer) -- From: Karl DeSaulniers k...@designdrumm.com Sent: Tuesday, December 22, 2009 6:12 AM To: php-db@lists.php.net Subject: [PHP-DB] Displaying Password Never mind. Got it. $replaceArray = array('a', 'b', 'c', 'd', 'e', 'f', 'g', 'h', 'i

Re: [PHP-DB] Displaying Password - orale...

2009-12-22 Thread Karl DeSaulniers
/) To unsubscribe, visit: http://www.php.net/unsub.php Karl DeSaulniers Design Drumm http://designdrumm.com

Re: [PHP-DB] Displaying Password - oy vey...

2009-12-22 Thread Karl DeSaulniers
worked on. Nice work. (I see your serious about your recruiter comment now) Do you have a suggestion where I can get PHP/MySQL certified? or a good dummies book? Best, Karl DeSaulniers Design Drumm http://designdrumm.com

Re: [PHP-DB] Displaying Password

2009-12-22 Thread Karl DeSaulniers
to you, - Karl DeSaulniers The best people in the world are the ones who help each other make it turn. After all, where all here together. On Dec 22, 2009, at 10:16 PM, David McGlone wrote: On Tuesday 22 December 2009 18:05:57 you wrote: I see. Good point. Forgive me with my noob approach. I am

Re: [PHP-DB] Displaying Password - orale...

2009-12-22 Thread Karl DeSaulniers
Thanks for the Zend tip Daevid. I did some search and found Zend Studio for MAC 5.5. it's $299, but thats a goal at least. http://www.tucows.com/preview/504387 Best, Karl

Re: [PHP-DB] Displaying Password - orale...

2009-12-22 Thread Karl DeSaulniers
that may be worth checking into. or a good dummies book? I find the php.net site to be the absolute best source of examples and information.\ I do concur. Best, Karl DeSaulniers Design Drumm http://designdrumm.com

Re: [PHP-DB] Transferring rows between 2 databases on 2 web servers

2010-01-17 Thread Karl DeSaulniers
. Many thanks, Ferdi Karl DeSaulniers Design Drumm http://designdrumm.com

Re: [PHP-DB] Random pick

2010-01-25 Thread Karl DeSaulniers
|| Administrator; I am wanting to stray from the if(foo == bar) { routine. ;) Thanks, Karl DeSaulniers Design Drumm http://designdrumm.com

Re: [PHP-DB] Random pick

2010-01-25 Thread Karl DeSaulniers
Resources, Administrator); $user_level = $level_names[$req_user_level]; Regards, Olavi Ivask On Jan 25, 2010, at 9:13 PM, Karl DeSaulniers wrote: Hello List, Trying to learn the right way to code this line. Can anyone tell me if I am doing this the right way? if $req_user_level == 0 || 1

Re: [PHP-DB] Random pick

2010-01-25 Thread Karl DeSaulniers
I am trying to avoid doing this: if ($req_user_level == 0) { $req_user_level = Guest; } else if ($req_user_level == 1) { req_user_level = Regular User } etc.. Karl DeSaulniers Design Drumm http://designdrumm.com

Re: [PHP-DB] Random pick

2010-01-25 Thread Karl DeSaulniers
, 2010, at 1:32 PM, Peter Beckman wrote: On Mon, 25 Jan 2010, Karl DeSaulniers wrote: Hello List, Trying to learn the right way to code this line. Can anyone tell me if I am doing this the right way? if $req_user_level == 0 || 1 || 2 || 3 || 4 || 5 || 6 || 7 || 8 || 9 ? Guest || Regular User

Re: [PHP-DB] Random pick

2010-01-25 Thread Karl DeSaulniers
: http://www.php.net/unsub.php Karl DeSaulniers Design Drumm http://designdrumm.com

[PHP-DB] PHP Help with pagination

2010-01-28 Thread Karl DeSaulniers
if($Submit) ? Use this if you want, I took bits and pieces and put this together for you, but hope that helps. Karl DeSaulniers Design Drumm http://designdrumm.com

[PHP-DB] MIME Alternatimve Emails

2010-01-30 Thread Karl DeSaulniers
to work properly? Currently it does not display the HTML on MAC but it does in Hotmail. MAC mail is grabbing the text version. So my susspicion is that the headers are just wrong. It has worked on MAC mail before I tried the MIME boundaries. TIA, Karl DeSaulniers Design Drumm http

Re: [PHP-DB] MIME Alternatimve Emails

2010-01-30 Thread Karl DeSaulniers
if a user can receive HTML emails or text. Any thoughts on what order I should be putting the headers I have? TIA, Karl On Jan 30, 2010, at 7:13 AM, Richard Quadling wrote: On 30 January 2010 13:04, Karl DeSaulniers k...@designdrumm.com wrote: Hi List, Good morning. Hope all are well

Re: [PHP-DB] Storing images

2010-02-02 Thread Karl DeSaulniers
. But it will increase the database size. So try referring the URL.. Karl DeSaulniers Design Drumm http://designdrumm.com

Re: [PHP-DB] Storing images

2010-02-03 Thread Karl DeSaulniers
Thank you all for your numerous responses. I hear you loud and clear. I was wanting to see if it would be less of a burden on the server and secure my images better to put the images inside a database, but as you all have almost uniformly stated, this would not be the best situation. I

Re: [PHP-DB] Storing images

2010-02-03 Thread Karl DeSaulniers
2010 16:07, Karl DeSaulniers k...@designdrumm.com wrote: Thank you all for your numerous responses. I hear you loud and clear. I was wanting to see if it would be less of a burden on the server and secure my images better to put the images inside a database, but as you all have almost

Re: [PHP-DB] Storing images

2010-02-03 Thread Karl DeSaulniers
have any writers, then you need to introduce a locking mechanism or some other protection. Karl DeSaulniers Design Drumm http://designdrumm.com

Re: [PHP-DB] PHP Objects and SQL Results

2010-02-12 Thread Karl DeSaulniers
this? Thanks, Paul -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php Karl DeSaulniers Design Drumm http://designdrumm.com

[PHP-DB] Getting total quantities

2010-02-14 Thread Karl DeSaulniers
for adding multiple rows field values? EG: Say I have three individual products and Product one has 10 and Product 2 has 20 and Product three has 5, and these values are set in the field $ProductStock, I want to get the result of 35 and not 3. Any help is appreciated. TIA Karl DeSaulniers Design

Re: [PHP-DB] Getting total quantities

2010-02-14 Thread Karl DeSaulniers
Would it be? $q = SUM(ProductStock) FROM products; or $q = SELECT SUM(ProductStock) AS ProductStock FROM products; if I want to return $ProductStock as the value? Karl On Feb 14, 2010, at 10:55 PM, Karl DeSaulniers wrote: Hello List, I have a situation where I want to figure out

Re: [PHP-DB] Getting total quantities

2010-02-14 Thread Karl DeSaulniers
Ok, sweet, then I am on the right track. Now I did notice that I forgot the SELECT in the first query, does that matter? Can I just start out with SUM? Thanks for your response. Karl On Feb 14, 2010, at 11:32 PM, Chris wrote: Karl DeSaulniers wrote: Would it be? $q = SUM(ProductStock

[PHP-DB] For the Qualified

2010-02-25 Thread Karl DeSaulniers
are taken by unqualified people. Best Regards, Karl DeSaulniers Design Drumm http://designdrumm.com

[PHP-DB] Little Direction Please

2010-02-26 Thread Karl DeSaulniers
Hello, I am not sure if this is a cross post, if it is, I do apologize. Does anyone know of a list like this but for Javascript? If anyone knows of one, I would greatly appreciate it. Thanks, Karl DeSaulniers Design Drumm http://designdrumm.com

[PHP-DB] RegExp

2010-03-11 Thread Karl DeSaulniers
like sharing :) and thought this could help someone. Best, http://lawrence.ecorp.net/inet/samples/regexp-format.php Karl DeSaulniers Design Drumm http://designdrumm.com Karl DeSaulniers Design Drumm http://designdrumm.com

Re: [PHP-DB] RegExp

2010-03-12 Thread Karl DeSaulniers
Correction, this actually starts the pages. http://lawrence.ecorp.net/inet/samples/regexp-intro.php Enjoy!, Thanks Lawrence ;) Karl On Mar 12, 2010, at 1:47 AM, Partha Sarathy wrote: hi Thanks. Useful site. On Fri, Mar 12, 2010 at 1:07 PM, Karl DeSaulniers k...@designdrumm.comwrote

Re: [PHP-DB] Online PHP-Mysql Meeting

2010-03-14 Thread Karl DeSaulniers
/unsub.php -- akan ada dimana mulut terkunci dan suara tak ada lagi.. saat itu gunakanlah HP untuk melakukan SMS!! - ini aliran bedul.. bukan aliran aneh. tertawa sebelum tertawa didepan RSJ.. Karl DeSaulniers Design Drumm http://designdrumm.com -- PHP Database Mailing List (http

Re: [PHP-DB] Online PHP-Mysql Meeting

2010-03-15 Thread Karl DeSaulniers
, at 4:15 AM, Gunawan Wibisono wrote: I create tutorial.. perhaps you can comment my first tutorial *hope better for next tutorial On 3/15/10, Karl DeSaulniers k...@designdrumm.com wrote: We can do it at my house.. :) Sounds like a great idea. +1 Karl On Mar 14, 2010, at 8:11 PM, Gunawan Wibisono

[PHP-DB] Calculator

2010-03-16 Thread Karl DeSaulniers
, a payment calc if you will. TIA Karl DeSaulniers Design Drumm http://designdrumm.com

Re: [PHP-DB] Calculator

2010-03-16 Thread Karl DeSaulniers
, Karl DeSaulniers k...@designdrumm.com wrote: Hello, I have been asked to see if I can set up an online calculator. I was wondering if anyone had some pointers on where I can lear/find a script that calculates percentages. The regular math part I think I can figure out. Its not a complicated calc

Re: [PHP-DB] Calculator

2010-03-17 Thread Karl DeSaulniers
=http://www.godfatheruk.com;GodfatherUK/a/td /tr /table /form /center /div /body /html Karl DeSaulniers Design Drumm http://designdrumm.com

[PHP-DB] imagecopyresize???????

2010-04-05 Thread Karl DeSaulniers
? Most grateful for any help, pointers, tuts. Best, Karl DeSaulniers Design Drumm http://designdrumm.com

Re: [PHP-DB] imagecopyresize???????

2010-04-05 Thread Karl DeSaulniers
Oh, I am sorry, is this not a php list? or is this strictly php to database? Karl On Apr 5, 2010, at 11:32 PM, Rasmus Lerdorf wrote: On 04/05/2010 09:03 PM, Karl DeSaulniers wrote: Hello List, I am hoping this will be a quick and easy for someone to help me with. I am trying to create

Re: [PHP-DB] imagecopyresize???????

2010-04-05 Thread Karl DeSaulniers
Found it. Thank you. Karl On Apr 6, 2010, at 12:05 AM, Lester Caine wrote: Karl DeSaulniers wrote: Oh, I am sorry, is this not a php list? or is this strictly php to database? Questions related to database use with PHP ... http://www.php.net/mailing-lists.php -- Lester Caine - G8HFL

Re: [PHP-DB] imagecopyresize???????

2010-04-06 Thread Karl DeSaulniers
Thanks Gunawan. I got on the gen list. Thanks for the response. Karl On Apr 6, 2010, at 3:38 AM, Gunawan Wibisono wrote: actualy no but if you ask in php-windows or other milis.. U will have good and quick answer On Tue, Apr 6, 2010 at 11:49 AM, Karl DeSaulniers k

[PHP-DB] Session Timeout question

2010-04-16 Thread Karl DeSaulniers
); } } } } But it doesn't time anything out.. I could walk away for an hour and come back and go to a link. TIA, Karl DeSaulniers Design Drumm http://designdrumm.com

Re: [PHP-DB] Sharing happiness!!

2010-04-21 Thread Karl DeSaulniers
. -- Postgresql php tutorials http://www.designmagick.com/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php Karl DeSaulniers Design Drumm http://designdrumm.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http

Re: [PHP-DB] Sharing happiness!!

2010-04-21 Thread Karl DeSaulniers
On Apr 22, 2010, at 12:16 AM, Chris wrote: Karl DeSaulniers wrote: Well what's weird is that the person who it says sent it is someone who helped me with a PHP problem. So that means the spammers are spoofing our email addresses to send their spam. That's nothing new. Too true

Re: [PHP-DB] Sharing happiness!!

2010-04-21 Thread Karl DeSaulniers
I keep getting two messages from you. Karl On Apr 22, 2010, at 12:16 AM, Chris wrote: Karl DeSaulniers wrote: Well what's weird is that the person who it says sent it is someone who helped me with a PHP problem. So that means the spammers are spoofing our email addresses to send

Re: [PHP-DB] Sharing happiness!!

2010-04-21 Thread Karl DeSaulniers
- not as up to date but it'll find this convo eventually) and phpbuilder and other places too. Karl DeSaulniers Design Drumm http://designdrumm.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] php mysql comparing two rows in two columns for username and passwort

2010-04-29 Thread Karl DeSaulniers
. thank you yours sincerly Alexander Schunk -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php Karl DeSaulniers Design Drumm http://designdrumm.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net

Re: [PHP-DB] php mysql comparing two rows in two columns for username and passwort

2010-04-29 Thread Karl DeSaulniers
Yes. You are correct. Did not include that part, sry. Dont forget mysql_real_escape_string. :) Karl On Apr 29, 2010, at 9:37 AM, Peter Lind wrote: On 29 April 2010 15:00, Karl DeSaulniers k...@designdrumm.com wrote: Hi, Maybe try... $benutzername = $_GET['username']; $pass = $_GET

[PHP-DB] grabbing from multiple tables

2010-04-30 Thread Karl DeSaulniers
manner. Short-hand if you will, if that is possible. TIA, Best, Karl DeSaulniers Design Drumm http://designdrumm.com

Re: [PHP-DB] grabbing from multiple tables

2010-04-30 Thread Karl DeSaulniers
Thanks Peter. So what is the logic behind foreign keys? Why use them? Thx. Karl Sent from losPhone On Apr 30, 2010, at 5:09 AM, Peter Lind peter.e.l...@gmail.com wrote: On 30 April 2010 12:02, Karl DeSaulniers k...@designdrumm.com wrote: Hello All, I have a product database

Re: [PHP-DB] grabbing from multiple tables

2010-04-30 Thread Karl DeSaulniers
...@gmail.com Subject: Re: [PHP-DB] grabbing from multiple tables To: Karl DeSaulniers k...@designdrumm.com Cc: php-db@lists.php.net php-db@lists.php.net Date: Friday, April 30, 2010, 12:31 PM On 30 April 2010 12:26, Karl DeSaulniers k...@designdrumm.com wrote: Thanks Peter. So what is the logic behind

Re: [PHP-DB] grabbing from multiple tables

2010-04-30 Thread Karl DeSaulniers
, 2010, at 2:59 PM, David Murphy wrote: -Original Message- From: Karl DeSaulniers [mailto:k...@designdrumm.com] Sent: Friday, April 30, 2010 1:50 PM To: php-db@lists.php.net Subject: Re: [PHP-DB] grabbing from multiple tables No, please confuse me. I need to know this stuff. @Peter

Re: [PHP-DB] grabbing from multiple tables

2010-04-30 Thread Karl DeSaulniers
.. :) Karl On Apr 30, 2010, at 2:59 PM, David Murphy wrote: -Original Message- From: Karl DeSaulniers [mailto:k...@designdrumm.com] Sent: Friday, April 30, 2010 1:50 PM To: php-db@lists.php.net Subject: Re: [PHP-DB] grabbing from multiple tables No, please confuse me. I need to know

Re: [PHP-DB] grabbing from multiple tables

2010-05-01 Thread Karl DeSaulniers
to it. A single product ID can have multiple group IDs set to it. I am trying to single out a product option. The option has a group ID and a product ID assigned to it. TIA Karl On Apr 30, 2010, at 3:54 PM, Karl DeSaulniers wrote: To elaborate a little more, In essence, the options

Re: [PHP-DB] grabbing from multiple tables

2010-05-01 Thread Karl DeSaulniers
Thank you Peter... again.. :) Which would be the source field and which the target field? Karl On May 1, 2010, at 3:22 AM, Peter Lind wrote: On 30 April 2010 20:49, Karl DeSaulniers k...@designdrumm.com wrote: No, please confuse me. I need to know this stuff. @Peter thanks

Re: [PHP-DB] grabbing from multiple tables

2010-05-01 Thread Karl DeSaulniers
GOLD! Thank you. Karl On May 1, 2010, at 4:12 AM, Peter Lind wrote: On 1 May 2010 11:00, Karl DeSaulniers k...@designdrumm.com wrote: Thank you Peter... again.. :) Which would be the source field and which the target field? You place the constraint on the table that has the foreign key

Re: [PHP-DB] grabbing from multiple tables

2010-05-01 Thread Karl DeSaulniers
things down. I'll let you know if I am successful. Best, On May 1, 2010, at 3:59 AM, Peter Lind wrote: I'm starting to wonder about your data model. Karl DeSaulniers Design Drumm http://designdrumm.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net

Re: [PHP-DB] How to use PHP to fill in existing pdf document

2010-05-01 Thread Karl DeSaulniers
in the database. The php script will have to be attached to the basic pdf before its uploaded, but I think that is possible. Might be worth some investigating. Doesn't seem to difficult. Karl On May 2, 2010, at 12:18 AM, Karl DeSaulniers wrote: Hi Ron, I have done this once before and what I had to do

[PHP-DB] Updating MySQL Database after install

2010-05-04 Thread Karl DeSaulniers
without loosing my current info? If so, how? Fields in the user table have not changed except foreign keys have been assigned to it. TIA, Karl DeSaulniers Design Drumm http://designdrumm.com

Re: [PHP-DB] MySQL Wildcard

2010-05-07 Thread Karl DeSaulniers
$array_results; } On May 7, 2010, at 11:46 AM, Karl DeSaulniers wrote: ... -- Onur Yerlikaya Thanks Onur, but same error message. It is not setting the % as a wild card. Not sure the way around this. Karl -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http

Re: [PHP-DB] File Downloads

2010-05-28 Thread Karl DeSaulniers
. Obviously, if you have a music track... you'll need to adjust the mime type accordingly. http://stackoverflow.com/questions/258365/php-link-to-image-file- outside-default-web-directory/258380#258380 Good luck. Adam -Original Message- From: Karl DeSaulniers [mailto:k

Re: [PHP-DB] File Downloads

2010-05-28 Thread Karl DeSaulniers
On May 28, 2010, at 4:33 PM, Karl DeSaulniers wrote: On May 28, 2010, at 4:18 PM, Adam Schroeder wrote: Hi Karl -- You can store the file contents outside of the web tree and use PHP to read the contents. This allows you to place access control restrictions in the PHP script

Re: [PHP-DB] File Downloads

2010-05-28 Thread Karl DeSaulniers
each other as I have loved you. John 15:12 --- Oh my.. thank you for that. Karl DeSaulniers Design Drumm http://designdrumm.com

Re: [PHP-DB] File Downloads

2010-05-28 Thread Karl DeSaulniers
logging) Is there any reason not to log them in by personalized means? (such as email/username) -Original Message- From: Karl DeSaulniers [mailto:k...@designdrumm.com] Sent: Friday, May 28, 2010 6:39 PM To: php-db@lists.php.net Subject: Re: [PHP-DB] File Downloads On May 28, 2010, at 4:49 PM

Re: [PHP-DB] File Downloads

2010-05-28 Thread Karl DeSaulniers
This is for a small project of limited edition audio or pictures or scripts, etc. Hens, I'd like to limit each user in the allotted 150 to be able to download (whatever it is) only once. But up to 150 users can get in on it kind of thing. Karl On May 28, 2010, at 6:36 PM, Karl DeSaulniers

Re: [PHP-DB] File Downloads

2010-05-28 Thread Karl DeSaulniers
the file more than once...) Good luck Eli -Original Message- From: Karl DeSaulniers [mailto:k...@designdrumm.com] Sent: Friday, May 28, 2010 7:40 PM To: php-db@lists.php.net Subject: Re: [PHP-DB] File Downloads This is for a small project of limited edition audio or pictures or scripts

Re: [PHP-DB] upload images

2010-05-30 Thread Karl DeSaulniers
imagen. move_uploaded_file($_FILES['foto']['tmp_name'], ../fotografias/.$timestamp..jpg); HTH, Karl DeSaulniers Design Drumm http://designdrumm.com

Re: [PHP-DB] upload images

2010-05-31 Thread Karl DeSaulniers
conventions don't mandate a sterilized format I woul still recommend using a confirmed new variable. Just my two cents :-) Eli On May 30, 2010, at 10:04 PM, Karl DeSaulniers k...@designdrumm.com wrote: Very good point. I did not think of that. Change it from time() to the date + time() w/ seconds

Re: [PHP-DB] upload images

2010-05-31 Thread Karl DeSaulniers
Good to hear. Karl Sent from losPhone On May 31, 2010, at 2:41 PM, Emiliano Boragina emiliano.borag...@gmail.com wrote: Thanks a lot... this last solution is the best for me... thanks a lot to all!!! 2010/5/31 Karl DeSaulniers k...@designdrumm.com You are probably right. The use

Re: [PHP-DB] Image linking help in PHP

2010-07-04 Thread Karl DeSaulniers
will be the heading of the page so no need to echo out twice right. Best, Guru. Karl DeSaulniers Design Drumm http://designdrumm.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] imagettftext

2010-07-11 Thread Karl DeSaulniers
Nevermind. found it on my own. On Jul 9, 2010, at 8:13 PM, Karl DeSaulniers wrote: Is there a way to get the width and height of text created with imagettftext? Karl DeSaulniers Design Drumm http://designdrumm.com Karl DeSaulniers Design Drumm http://designdrumm.com -- PHP Database

Re: [PHP-DB] Re: Stuck in apostrophe hell

2010-08-03 Thread Karl DeSaulniers
= mysql_real_escape(VALUES); before submitting or something similar? maybe urlencode Karl DeSaulniers Design Drumm http://designdrumm.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Re: Stuck in apostrophe hell

2010-08-03 Thread Karl DeSaulniers
pointed out previously. -- Postgresql php tutorials http://www.designmagick.com/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php didnt see this post, was in my spam folder Karl DeSaulniers Design Drumm http://designdrumm.com -- PHP

[PHP-DB] Slashes or no slashes

2010-08-19 Thread Karl DeSaulniers
Hello, When I add an item to my database and I use addslashes(), do I have to use addslashes() to a query that looks for that item? Or would I be adding double slashes and canceling my own result? TIA Karl DeSaulniers Design Drumm http://designdrumm.com

Re: [PHP-DB] Slashes or no slashes

2010-08-19 Thread Karl DeSaulniers
On Aug 19, 2010, at 4:36 PM, Daevid Vincent wrote: You should be using http://us2.php.net/manual/en/function.mysql-escape-string.php You don't need to search with extra slashes for retrieval. -Original Message- From: Karl DeSaulniers [mailto:k...@designdrumm.com] Sent: Thursday

Re: [PHP-DB] Slashes or no slashes

2010-08-19 Thread Karl DeSaulniers
On Aug 19, 2010, at 4:36 PM, Daevid Vincent wrote: You should be using http://us2.php.net/manual/en/function.mysql-escape-string.php You don't need to search with extra slashes for retrieval. -Original Message- From: Karl DeSaulniers [mailto:k...@designdrumm.com] Sent: Thursday

Re: [PHP-DB] Slashes or no slashes

2010-08-19 Thread Karl DeSaulniers
On Aug 19, 2010, at 4:44 PM, Karl DeSaulniers wrote: On Aug 19, 2010, at 4:36 PM, Daevid Vincent wrote: You should be using http://us2.php.net/manual/en/function.mysql-escape-string.php You don't need to search with extra slashes for retrieval. -Original Message- From: Karl

Re: [PHP-DB] Slashes or no slashes

2010-08-19 Thread Karl DeSaulniers
will work for what I am doing. Thank you all for your responses. Again. Best, Karl On Aug 19, 2010, at 5:40 PM, kapuorigi...@gmail.com wrote: I think you should use prepared statements. Kapu -- From: Karl DeSaulniers k...@designdrumm.com Sent

Re: [PHP-DB] Slashes or no slashes

2010-08-23 Thread Karl DeSaulniers
On Aug 22, 2010, at 7:12 PM, Chris wrote: On 20/08/10 08:05, Karl DeSaulniers wrote: On Aug 19, 2010, at 4:44 PM, Karl DeSaulniers wrote: On Aug 19, 2010, at 4:36 PM, Daevid Vincent wrote: You should be using http://us2.php.net/manual/en/function.mysql-escape-string.php You don't need

Re: [PHP-DB] Slashes or no slashes

2010-08-23 Thread Karl DeSaulniers
! Username and password confirmed } else{ return 2; //Indicates password failure } } The password was added to the database with md5() applied after escaping. Thank you for responding so quickly. Karl DeSaulniers Design Drumm http://designdrumm.com -- PHP Database Mailing

Re: [PHP-DB] Slashes or no slashes

2010-08-23 Thread Karl DeSaulniers
tutorials http://www.designmagick.com/ -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php Ahhh. I see. But I do still put the escape on what they entered so it will match what is in the database. Ok. Thank you Thank you Thank you. Best, Karl

Re: [PHP-DB] Slashes or no slashes

2010-08-23 Thread Karl DeSaulniers
On Aug 23, 2010, at 10:04 PM, Karl DeSaulniers wrote: On Aug 23, 2010, at 9:31 PM, Chris wrote: To be more specific. Is this correct? function confirmUP($username, $password){ $username = mysql_real_escape_string($username); /* Verify that user is in database */ $q = SELECT password FROM

Re: [PHP-DB] Slashes or no slashes

2010-08-23 Thread Karl DeSaulniers
$dbarray['password'] to $password, don't I have to escape $password and then md5 it? TIA Karl DeSaulniers Design Drumm http://designdrumm.com @david.lopez: Your emails are getting blocked by my isp, so I have not seen any of your emails. Not ignoring you, promise. -- PHP Database Mailing List

Re: [PHP-DB] Slashes or no slashes

2010-08-23 Thread Karl DeSaulniers
On Aug 23, 2010, at 11:38 PM, Karl DeSaulniers wrote: On Aug 23, 2010, at 10:35 PM, Chris wrote: Just to make sure, cause I am ready to get past this. Is this correct? function confirmUP($username, $password){ /* Verify that user is in database */ $q = SELECT password FROM .TBL_USERS

Re: [PHP-DB] finding out if a user left our website ?

2010-08-25 Thread Karl DeSaulniers
) closing the window i guess, we could use the javascript onclose or something similar but for the user moving away from my website by entering a different URL is what i would like to be able to find out. Thanks, Vinay Karl DeSaulniers Design Drumm http://designdrumm.com -- PHP Database

[PHP-DB] Database management

2010-08-25 Thread Karl DeSaulniers
will never do it again, I swear. :)) Karl DeSaulniers Design Drumm http://designdrumm.com

Re: [PHP-DB] Database management

2010-08-26 Thread Karl DeSaulniers
and it is a Win32 app (meaning you'll have to run it in VirtualBox or something similar). : Ashay -Original Message- From: Karl DeSaulniers [mailto:k...@designdrumm.com] Sent: Thursday, August 26, 2010 1:28 AM To: php-db@lists.php.net Subject: [PHP-DB] Database management Hello fellow

Re: [PHP-DB] Database management

2010-08-26 Thread Karl DeSaulniers
at it. The thing is SSMS is also a great IDE. If non-freeware is an option, take a look at mylittleadmin - it's ASP based though. : Ashay -Original Message- From: Karl DeSaulniers [mailto:k...@designdrumm.com] Sent: Thursday, August 26, 2010 9:06 AM To: php-db@lists.php.net Subject: Re

Re: [PHP-DB] Database management

2010-08-26 Thread Karl DeSaulniers
Nice. Thanks for that. I will def. take a look. Best, Karl On Aug 26, 2010, at 7:59 AM, Ashay Chaudhary wrote: It appears to be. I've downloaded the free/trial version, I haven't had time to play with it. : Ashay -Original Message- From: Karl DeSaulniers [mailto:k

Re: [PHP-DB] SELECT / ORDER BY

2010-09-11 Thread Karl DeSaulniers
are in alphabetical order? Ron Ron -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php Karl DeSaulniers Design Drumm http://designdrumm.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Creating an INDEX on multiple tables?

2010-10-21 Thread Karl DeSaulniers
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php Karl DeSaulniers Design Drumm http://designdrumm.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Creating an INDEX on multiple tables?

2010-10-21 Thread Karl DeSaulniers
. Bastien Koert 905-904-0334 Sent from my iPhone On 2010-10-21, at 7:24 AM, Karl DeSaulniers k...@designdrumm.com wrote: Excuse me for intruding, but wouldn't this be a Foreign Key solution? If one field is the same on all tables, can't you just set a Foreign Key that all tables

Re: [PHP-DB] How to Sync MySQL with iPhone or Google Contacts

2010-10-22 Thread Karl DeSaulniers
! - Ron -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php Karl DeSaulniers Design Drumm http://designdrumm.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

  1   2   3   4   >