Re: [PHP-DB] Waiting for localhost

2015-03-15 Thread Jason Pruim
If you load up handleweight.php outside of the script does it load normally? Trying to pin down where the actual problem is. Jason Pruim 352.359.0002 On Mar 14, 2015, at 10:17 PM, Ethan Rosenberg erosenb...@hygeiabiomedical.com wrote: On 03/09/2015 08:27 AM, Ethan Rosenberg, PhD wrote

Re: [PHP-DB] Waiting for localhost

2015-03-15 Thread Jason Pruim
instead of the entire site. Jason Pruim 352.359.0002 On Mar 15, 2015, at 2:40 PM, Ethan Rosenberg erosenb...@hygeiabiomedical.com wrote: On 03/15/2015 09:44 AM, Jason Pruim wrote: If you load up handleweight.php outside of the script does it load normally? Trying to pin down where

Re: [PHP-DB] Problem with mysql and php

2011-11-29 Thread Jason Pruim
Jim, Similar yes... But this was specifically about replacing distinct with something since it was taking WAY to long... But it did evolve into a very similar conversation :) Jason Pruim pru...@gmail.com On Nov 29, 2011, at 6:25 PM, Jim Giner wrote: Didn't the OP begin this very same

[PHP-DB] Problem with mysql and php

2011-11-28 Thread Jason Pruim
records, will be expanding that to many many more times that... To the tune of possibly a couple billion records... Any ideas? :) Jason Pruim li...@pruimphotography.com

Re: [PHP-DB] Problem with mysql and php

2011-11-28 Thread Jason Pruim
Jason Pruim pru...@gmail.com On Nov 28, 2011, at 8:58 PM, Phil Dobbin wrote: On 29/11/11 01:38, Jason Pruim li...@pruimphotography.com wrote: Given the following 2 queries: SELECT DISTINCT areacode FROM main WHERE state = '{$query_exploded[0]}'; SELECT DISTINCT areacode FROM main

[PHP-DB] Odd MySQL Problem...

2011-10-13 Thread Jason Pruim
areacode, exchange, subscriber) "; $sql .= "VALUES({$data[1]}, {$data[2]}, {$padded_number}) "; //mysql_query($sql) or die("Didn't insert you dumb ass FIX IT NOW CLOWN " . mysql_error());echo "SQL: " . $sql . "BR"; } } echo "File Bitches!"; fclose($handle);}?Any ideas on what I'm missing?Thanks everyone! Jason Pruimli...@pruimphotography.com

[PHP-DB] Working with large datasets

2011-10-10 Thread Jason Pruim
it keeps timing out the connection. Is there any advice for working with large datasets? I'm wanting this to be able to load quickly. Thanks in advance! Jason Pruim li...@pruimphotography.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Working with large datasets

2011-10-10 Thread Jason Pruim
Jason Pruim pru...@gmail.com On Oct 10, 2011, at 2:20 PM, Jim Giner wrote: Toby Hart Dyke t...@hartdyke.com wrote in message news:00da01cc8768$ca9e9200$5fdbb600$@hartdyke.com... It sounds as though you don't have an index on the right field. 8 million records should be no problem

Re: [PHP-DB] Working with large datasets

2011-10-10 Thread Jason Pruim
Jason Pruim pru...@gmail.com On Oct 10, 2011, at 2:42 PM, Jim Giner wrote: I don't do command line stuff so I may not be right in my thinking. If you are running a php query from a client, does the query get executed on the database server, or does all the data have to come down to you

Re: [PHP-DB] Working with large datasets

2011-10-10 Thread Jason Pruim
Jason Pruim li...@pruimphotography.com On Oct 10, 2011, at 5:27 PM, Thompson, Jimi wrote: I really think that you should try running it from the command line and see what the issues are. Get both Apache and php out of the way. I've seen some PHP scripts use up all the file handles (OS

Re: [PHP-DB] Parsing Tab Delimited file

2010-10-24 Thread Jason Pruim
On Oct 24, 2010, at 2:46 PM, Ethan Rosenberg wrote: Dear list - Thanks for all your help. I have a tab delimited file which I wish to import into a data base. In MySQL I can use the LOAD DATA command. As far as I know, that command cannot be used in PHP as a mysqli_query. As I

[PHP-DB] always the logic that messes me up.... Database fun!

2010-07-18 Thread Jason Pruim
Hi everyone! I'm trying to put together a completely database driven site so I can learn how to do it... I've gone to the extent of creating apache rewrite rules to redirect all non-existent files/folders to my script to see if it exists which works perfectly. Where I'm running into

Re: [PHP-DB] session management

2010-04-23 Thread Jason Gerfen
Here I have a blog I setup but have not finished regarding web application authentication which includes source code and classes you can utilize. Unfortunately I have not been able to finish writing the article due to three jobs and school work. I can however assist you in getting it up and

Re: [PHP-DB] session management

2010-04-22 Thread Jason Gerfen
How secure would you want it? Is this is a public facing web application? Are you in a shared hosting environment vs. a dedicated hosting environment? Do you require alternative session management such as database or mcache vs. flat file session support? Have you thought about cross site

[PHP-DB] php, session_set_save_handler disappearing session vars

2010-02-04 Thread Jason Gerfen
with: $handles['session']-register( 'token', $token ); -- Jason Gerfen Systems Administration/Web application development jason.ger...@scl.utah.edu Marriott Library Lab Systems PC 295 South 1500 East Salt Lake City, Utah 84112-0806 Ext 5-9810 -- PHP Database Mailing List (http://www.php.net

Re: [PHP-DB] Storing Images #2

2010-02-04 Thread Jason Gerfen
If its outside the html root you would need to create a symlink pointing to the appropriate folder % ln -s /path/to/hidden /path/to/public *however this is very insecure Then if your wise you could create a simple image serving script to prevent direct navigation by checking the referring

Re: [PHP-DB] PHP Update query

2009-11-04 Thread Jason Gerfen
From the manual page: For other type of SQL statements, INSERT, UPDATE, DELETE, DROP, etc, *mysql_query()* returns *TRUE* on success or *FALSE* on error. If $client_result == true you know the query was successful. -- Jason Gerfen Systems Administration/Web application development jason.ger

Re: [PHP-DB] DATETIME

2009-10-08 Thread Jason Gerfen
WHERE event_date BETWEEN ('2009-09-01 00:00:00.000' AND '2009-10-01 23:59:59.999') -- Jason Gerfen Systems Administration/Web application development jason.ger...@scl.utah.edu Marriott Library Lab Systems PC 295 South 1500 East Salt Lake City, Utah 84112-0806 Ext 5-9810 -- PHP Database

Re: [PHP-DB] DATETIME

2009-10-08 Thread Jason Gerfen
something like: SELECT * FROM my_table WHERE event_date BETWEEN ('2009-09-01 00:00:00.000' AND '2009-10-01 23:59:59.999') -- Jason Gerfen Systems Administration/Web application development jason.ger...@scl.utah.edu Marriott Library Lab Systems PC 295 South 1500 East Salt Lake City, Utah 84112

Re: [PHP-DB] Need help with the code

2009-10-02 Thread Jason Gerfen
/a here to enter the members page; $_SESSION['username']=$username; } else echo incorrect password; } else die(That user dosen't exist); } else die(pelase enter a username and a password); ? -- Jason Gerfen Systems Administration/Web application development jason.ger

Re: [PHP-DB] Need help with the code

2009-10-02 Thread Jason Gerfen
in' /form /html Did you try looking at the $_POST array data? echo var_dump(print_r($_POST)); -- Jason Gerfen Systems Administration/Web application development jason.ger...@scl.utah.edu Marriott Library Lab Systems PC 295 South 1500 East Salt Lake City, Utah 84112-0806 Ext

Re: [PHP-DB] Need help with the code

2009-10-02 Thread Jason Gerfen
prasad wrote: Yes I did but still its not working on my web server however its working fine with my WAMP server locally. On Fri, Oct 2, 2009 at 9:17 PM, Jason Gerfen jason.ger...@scl.utah.edu mailto:jason.ger...@scl.utah.edu wrote: nagendra prasad wrote: OK so here is the form

Re: [PHP-DB] Need help with the code

2009-10-02 Thread Jason Gerfen
Maybe you should google for information regarding the php.ini and error reporting. nagendra prasad wrote: Yes I did but still its not working on my web server however its working fine with my WAMP server locally. On Fri, Oct 2, 2009 at 9:17 PM, Jason Gerfen jason.ger...@scl.utah.eduwrote

[PHP-DB] Prepared Statement Insert Problem

2009-07-21 Thread Jason Carson
Hello everyone, I have a problem. I use the following to *try* and insert data into my MySQL database... //Variables come from a form $username= $_POST['username']; $password = $_POST['password']; $email = $_POST['email']; //Connect to the database $connect = mysqli_connect($hostname,

Re: [PHP-DB] Prepared Statement Insert Problem

2009-07-21 Thread Jason Carson
, sha1($password), $email); On Tue, Jul 21, 2009 at 8:01 PM, Jason Carson ja...@jasoncarson.ca wrote: Hello everyone, I have a problem. I use the following to *try* and insert data into my MySQL database... //Variables come from a form $username= $_POST['username']; $password = $_POST

Re: [PHP-DB] Prepared Statement Insert Problem

2009-07-21 Thread Jason Carson
Done. Thanks for letting me know about that. kesavan trichy rengarajan wrote: could be rewritten as: mysqli_stmt_bind_param($submitadmin, isss, $numrows, $admin, sha1($password), $email); Turning on E_STRICT in PHP 5.3 will show PHP Strict Standards: Only variables should be

Re: [PHP-DB] MySQLand a prepared statement problem

2009-07-17 Thread Jason Carson
I solved the problem by turning off magic_quotes_gpc in my php.ini file. I was under the impression that using prepared statements means you don't need to use those functions. check into stripslashes ,addslashes and mysqli_real_escape_string functions. Jack 2009/7/17 Jason Carson ja

[PHP-DB] MySQLand a prepared statement problem

2009-07-16 Thread Jason Carson
Hello everyone, I have a problem. When I insert a href=http://example.comExample/a into my database with the following code... $connect = mysqli_connect($hostname, $username, $password, $database); $sql=INSERT INTO notes VALUES ('$id', '$note'); $result=mysqli_query($connect, $sql);

Re: [PHP-DB] MySQLand a prepared statement problem

2009-07-16 Thread Jason Carson
Hello everyone, I have a problem. When I insert a href=http://example.comExample/a into my database with the following code... $connect = mysqli_connect($hostname, $username, $password, $database); $sql=INSERT INTO notes VALUES ('$id', '$note'); $result=mysqli_query($connect, $sql);

Re: [PHP-DB] MySQLand a prepared statement problem

2009-07-16 Thread Jason Carson
I was under the impression that using prepared statements means you don't need to use those functions. check into stripslashes ,addslashes and mysqli_real_escape_string functions. Jack 2009/7/17 Jason Carson ja...@jasoncarson.ca Hello everyone, I have a problem. When I insert

Re: [PHP-DB] Re: [PHP] A prepared statements question

2009-07-12 Thread Jason Carson
[Redirected to PHP-DB: php...@lists.php.net] On Sun, Jul 12, 2009 at 00:31, Jason Carsonja...@jasoncarson.ca wrote: Hello everyone, I am having a problem getting my prepared statements working. Here is my setup...    index.php - authenticate.php - admin.php 1)index.php

Re: [PHP-DB] mysqli error

2009-07-01 Thread Jason Gerfen
Kevin Castiglia wrote: Whenever I run the following code, I get the error: Commands out of sync; you can't run this command now as I try to execute my prepared Update statement. ?php $fpiDataAddr = fopen('outputAddr.txt','r') or die(can not open In File ); //Connect to mySQL server

Re: [PHP-DB] mysqli error

2009-07-01 Thread Jason Gerfen
Jason Gerfen wrote: Kevin Castiglia wrote: Whenever I run the following code, I get the error: Commands out of sync; you can't run this command now as I try to execute my prepared Update statement. ?php $fpiDataAddr = fopen('outputAddr.txt','r') or die(can not open In File ); //Connect

Re: [PHP-DB] multiple finder

2009-06-29 Thread Jason Gerfen
Emiliano Boragina wrote: Hi, I must do e finder for properties... I know do a simple search but not a search like this with more one possibility, with all or some fields full... How do it? Thanks a lot Example database table to search: TableName Field001 Field002 Field003 Example SQL to

Re: [PHP-DB] postgres - pg_query works; pg_query_params doesn't

2009-06-15 Thread Jason Gerfen
Carol Walter wrote: Hello, I have a php 5 and PostgreSQL 8.3.6. I wrote the original program using pg_query. Now, I need to replace pg_query with pg_query_params. I'm having trouble doing so. In this code pg_query works but pg_query_params doesn't work. The code snippet is as follows:

Re: [PHP-DB] session variable in select query showing picture from database

2009-02-12 Thread Jason Pruim
On Feb 12, 2009, at 6:07 AM, Mika Jaaksi wrote: I'm trying to show picture from database. Everything works until I add variable into where part of the query. It works with plain number. example ...WHERE id=11... ...picture is shown on the page. Here's the code that retrieves the picture.

Re: [PHP-DB] re:php debugging skills

2008-09-26 Thread Jason Pruim
with databases (Since this is the DB list :)) I'd recommend to echo out your db statements to make sure you are doing what you think you are doing... Can't tell you how many times that screwed me up... Just my experience, take it or leave it :) -- Jason Pruim Raoset Inc. Technology Manager

Re: [PHP-DB] re:php debugging skills

2008-09-26 Thread Jason Pruim
On Sep 26, 2008, at 1:17 PM, muhsin wrote: Jason Pruim wrote: On Sep 26, 2008, at 11:22 AM, muhsin wrote: Could you guys share your development setup, like what kinds of software (IDE's/Editors) you are using for developing php scripts? It might sound silly but I am just curios, as I just

[PHP-DB] Question about databases and foreign keys

2008-09-15 Thread Jason Pruim
the actual time, hopefully making the math part easier :) Do I need the foreign key and the 2 tables? Or should I just add the column's into the database since it will be for a small company? Ideas? Suggestions? Thanks! -- Jason Pruim Raoset Inc. Technology Manager MQC Specialist 11287

Re: [PHP-DB] solution reqd for summation of vertical columns in PHP

2008-09-13 Thread Jason Pruim
On Sep 13, 2008, at 10:05 PM, Vaibhav Informatics wrote: Please let me know if there is a simple method to total up the column values in Mysql database tables using php as in excel. I believe what you are looking for is count(fieldname) -- PHP Database Mailing List (http://www.php.net/)

[PHP-DB] Problem with updating MySQL table

2008-08-27 Thread Jason Pruim
, it erases the info in the field. Anyone got a clue as to what is going on? :) Thanks for looking! -- Jason Pruim Raoset Inc. Technology Manager MQC Specialist 11287 James St Holland, MI 49424 www.raoset.com [EMAIL PROTECTED]

Re: [PHP-DB] Problem with updating MySQL table

2008-08-27 Thread Jason Pruim
suggestion: you may want put mysql_real_escape_string() wrappers around all those $_POST[] fields to prevent SQL hijacking of your site. HTH, Yves -- Original Message -- Received: Wed, 27 Aug 2008 11:07:20 AM CDT From: Jason Pruim [EMAIL PROTECTED] To: php-db@lists.php.net Subject: [PHP

Re: [PHP-DB] Problem with updating MySQL table

2008-08-27 Thread Jason Pruim
fine, if I DO disable it then they don't submit. I need to find a better to stop accidental editing rather then just input type=text disable On Wed, Aug 27, 2008 at 6:38 PM, Jason Pruim [EMAIL PROTECTED] wrote: On Aug 27, 2008, at 12:24 PM, Evert Lammerts wrote: Your index.php looks

Re: [PHP-DB] Kesalahan posting?

2008-08-27 Thread Jason Pruim
Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- Jason Pruim Raoset Inc. Technology Manager MQC Specialist 11287 James St Holland, MI 49424 www.raoset.com [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe

Re: [PHP-DB] Problem with updating MySQL table

2008-08-27 Thread Jason Pruim
On Aug 27, 2008, at 12:48 PM, Jason Pruim wrote: For everyone that has helped me on this thank you! :) the solution was changing from: input type=text name=txtFName DISABLED to input type=text name=txtFName READONLY Read only fields still get passed with POST'ed info where as disabled

[PHP-DB] Question about access rights in php/mysql

2008-08-26 Thread Jason Pruim
Hi Everyone, I am attempting to wrap my head around an issue and wanted to see if I was thinking right. I am attempting to setup a pURL site, one where they go to something like: example.com/purl.php?purl=jason1234 and the site says Welcome Jason. I have that part of it working, and it's

Re: [PHP-DB] Question about access rights in php/mysql

2008-08-26 Thread Jason Pruim
Jason. I have that part of it working, and it's pulling the info from the database just fine, what I'm wondering about is locking it down a little bit more so that they can't just edit the info in the main page, but they have to specifically hit a button to edit the info. Is it better

Re: [PHP-DB] Multi-level marketing system

2008-08-14 Thread Jason Pruim
And what precisely does this have to do with PHP or databases? I have a feeling if you google for MLM Systems you'll get more then you could ever want... -- Jason Pruim Raoset Inc. Technology Manager MQC Specialist 11287 James St Holland, MI 49424 www.raoset.com [EMAIL PROTECTED

Re: [PHP-DB] Timestamps

2008-05-02 Thread Jason Pruim
On May 1, 2008, at 8:31 PM, Chris wrote: PS... Was it you, Jason, or someone else who asked about the security of the community knowing their database structure and I encouraged the use of `backticks` around all field and table names? Yeah it was me... Old habits die hard :) I'm

Re: [PHP-DB] Timestamps

2008-05-01 Thread Jason Pruim
On Apr 30, 2008, at 5:03 PM, Philip Thompson wrote: On Apr 30, 2008, at 10:54 AM, Jason Pruim wrote: Hi Yves, Thanks for the tip, that worked, I think I'll use that from now on.. Just out of curiosity though, any idea why it wasn't working as I was writing it :) Did you try putting

Re: [PHP-DB] How to do a Newsletter

2008-05-01 Thread Jason Pruim
, newshound, and know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ -- Jason Pruim Raoset Inc. Technology Manager MQC Specialist 3251 132nd ave Holland, MI, 49424-9337 www.raoset.com [EMAIL PROTECTED] -- PHP Database Mailing List (http

Re: [PHP-DB] How to do a Newsletter

2008-05-01 Thread Jason Pruim
run a query according to user criteria of newsletter and send it via email - Original Message From: Jason Pruim [EMAIL PROTECTED] To: Nasreen Laghari [EMAIL PROTECTED] Cc: php-db@lists.php.net Sent: Thursday, May 1, 2008 5:03:43 PM Subject: Re: [PHP-DB] How to do a Newsletter That's

Re: [PHP-DB] Timestamps

2008-04-30 Thread Jason Pruim
On Apr 30, 2008, at 11:35 AM, Stut wrote: On 30 Apr 2008, at 16:29, Jason Pruim wrote: Okay... So I know this should be simple... Trying to store a timestamp in a MySQL database... The timestamp I am making like so: $modifiedTimestamp = time(); and then just $sql = Update `mytable` set

Re: [PHP-DB] php database

2008-04-18 Thread Jason Pruim
? -- Jason Pruim Raoset Inc. Technology Manager MQC Specialist 3251 132nd ave Holland, MI, 49424-9337 www.raoset.com [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] mysqli_stmt_bind_param question

2008-04-04 Thread Jason Pruim
can't figure this one out... RTFM's are appreciated, as long as M is defined! :) Thanks for taking the time to look! -- Jason Pruim Raoset Inc. Technology Manager MQC Specialist 3251 132nd ave Holland, MI, 49424-9337 www.raoset.com [EMAIL PROTECTED]

Re: [PHP-DB] mysqli_stmt_bind_param question

2008-04-04 Thread Jason Pruim
with so many parameters. What do you mean by this? -- Jason Pruim Raoset Inc. Technology Manager MQC Specialist 3251 132nd ave Holland, MI, 49424-9337 www.raoset.com [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Not updating certain fields in same row

2008-03-27 Thread Jason Pruim
verified :) So Thanks! :) On Mar 25, 2008, at 12:59 PM, Jason Pruim wrote: Hi everyone, I am attempting to update a record for a login system while leaving certain fields untouched if they arn't changed, and am running into issues. Basically what I want to do, is say I have these fields

Re: [PHP-DB] numeric string to single digit array

2008-03-26 Thread Jason Gerfen
that produces. -- Jason Gerfen I practice my religion while stepping on your toes... ~The Ditty Bops -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Not updating certain fields in same row

2008-03-25 Thread Jason Pruim
. Which is what I am trying to avoid. Any ideas? -- Jason Pruim Raoset Inc. Technology Manager MQC Specialist 3251 132nd ave Holland, MI, 49424-9337 www.raoset.com [EMAIL PROTECTED]

Re: [PHP-DB] Not updating certain fields in same row

2008-03-25 Thread Jason Pruim
On Mar 25, 2008, at 1:09 PM, Daniel Brown wrote: On Tue, Mar 25, 2008 at 12:59 PM, Jason Pruim [EMAIL PROTECTED] wrote: Hi everyone, I am attempting to update a record for a login system while leaving certain fields untouched if they arn't changed, and am running into issues. [snip!] I

Re: [PHP-DB] Not updating certain fields in same row

2008-03-25 Thread Jason Pruim
at 11:59 AM, Jason Pruim [EMAIL PROTECTED] wrote: Hi everyone, I am attempting to update a record for a login system while leaving certain fields untouched if they arn't changed, and am running into issues. Basically what I want to do, is say I have these fields: Field1 Field2 Field3 Field4 I

Re: [PHP-DB] Not updating certain fields in same row

2008-03-25 Thread Jason Pruim
, Jason Pruim [EMAIL PROTECTED] wrote: the actual query I'm using is this: $chpwsql = UPDATE current SET customerName='$customerName', loginName='$loginName', loginPassword='$PW', email='$email', adminLevel='$adminLevel' WHERE Record='$Record1'; What it is doing now is if I don't set

Re: [PHP-DB] PHP, MySQL and Lookups

2008-02-26 Thread Jason Pruim
check the mysql site for specifics on using update. Also... always be sure to escape your data or you are asking for trouble... That should be enough to get you started! -- Jason Pruim Raoset Inc. Technology Manager MQC Specialist 3251 132nd ave Holland, MI, 49424-9337 www.raoset.com [EMAIL

Re: [PHP-DB] md5() function

2008-01-14 Thread Jason Gerfen
are looking for is the base64_encode() and base64_decode() functions which will perform a simple encoding of data. -- Jason Gerfen I practice my religion while stepping on your toes... ~The Ditty Bops -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http

Re: [PHP-DB] Credit Card Encryption

2007-12-26 Thread Jason Gerfen
] ) ); } elseif( !function_exists( sha1 ) ) { $keys[] = md5( md5( $array[$x] ) ); } else { $keys[] = mhash( MHASH_SHA1, sha1( $array[$x] ) ); } That will look to see if the 'mhash()', 'sha1()' functions exist and use them accordingly. HTH. Jason Gerfen wrote: Jason Gerfen wrote: Daniel Brown wrote

Re: [PHP-DB] Credit Card Encryption

2007-12-26 Thread Jason Gerfen
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 What I wrote there will work but I would highly recommend recompiling PHP with the --with-mcrypt --with-mhash switches. The mcrypt libraries can be found on sourceforge. http://libmcrypt.sourceforge.net Jason Gerfen wrote: I got messaged off list

Re: [PHP-DB] Credit Card Encryption

2007-12-19 Thread Jason Gerfen
for that gig - -- Jason Gerfen I practice my religion while stepping on your toes... ~The Ditty Bops -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.7 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFHaUTR5vk8bwKVAaIRAlPOAJoCUbI6rVCvhG6pvuIzWTkbiyLVQgCfdE26

Re: [PHP-DB] Credit Card Encryption

2007-12-19 Thread Jason Gerfen
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Jason Gerfen wrote: Daniel Brown wrote: On Dec 19, 2007 2:41 AM, Keith Spiller [EMAIL PROTECTED] wrote: Ok I've done some research and some thinking. What about storing orders in the database (product info and customer info) and then using GnuPG

Re: [PHP-DB] Sending value to another page...

2007-11-29 Thread Jason Gerfen
; INPUT type=submit name=new_record value=Add Line /nbsp;nbsp; INPUT type=reset name=clear value=Clear //TD /TR /FORM /TABLE /BODY /HTML - -- Jason Gerfen I practice my religion while stepping on your toes

Re: [PHP-DB] array issue

2007-11-27 Thread Jason Gerfen
)); } - -- Jason Gerfen I practice my religion while stepping on your toes... ~The Ditty Bops -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.7 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFHTGMM5vk8bwKVAaIRAhAjAJ9FklveFH1PORVl0HC9nCb+klgcUACeOren RgXSIP0bl/bt9rI6g9a

[PHP-DB] Question about database design

2007-10-24 Thread Jason Pruim
.* and I'll be writing the stuff to access that database with php 5. -- Jason Pruim Raoset Inc. Technology Manager MQC Specialist 3251 132nd ave Holland, MI, 49424 www.raoset.com [EMAIL PROTECTED]

Re: [PHP-DB] Question about database design

2007-10-24 Thread Jason Pruim
? On Oct 24, 2007, at 9:28 AM, Tim McGeary wrote: Hi Jason, There are a couple ways you could do this. Yes, this would make it a relational database. If you go with a second table, you'll want to be sure to include the UID from the main address table in the SnowBirds table so

Re: [PHP-DB] Question about database design

2007-10-24 Thread Jason Pruim
with php 5. -- Jason Pruim Raoset Inc. Technology Manager MQC Specialist 3251 132nd ave Holland, MI, 49424 www.raoset.com [EMAIL PROTECTED] Express yourself with free Messenger emoticons. Get them today! -- Jason Pruim Raoset Inc. Technology Manager MQC Specialist 3251 132nd ave

[PHP-DB] different behaviour with CLI and Apache PHP with database connection

2007-08-26 Thread Jason Cartledge
this problem? Thank you Jason _ Feel like a local wherever you go with BackOfMyHand.com http://www.backofmyhand.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Unique fields, grabbing errors

2006-04-07 Thread Jason Gerfen
{ ... } -- Jason Gerfen You will never be ready for me. ~ Me -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Mailing List Question: Outlook Express

2005-11-10 Thread Jason Aeschilman
in all email clients. Can you at least provide that as an option? I'd love to contribute to the list, but it makes it hard when you have to click each message as an attachment to read them. Jason

Re: [PHP-DB] Limited connections to the database. .

2005-10-27 Thread Jason
Norland, Martin wrote: http://www.google.com/search?q=oracle+limit+client+connections http://www.oracle.com/technology/pub/articles/php_experts/scaling_oracle _and_php.html Summary - either you're not using persistent connections, or your site is just very busy. If it's just that the site is

Re: [PHP-DB] Limited connections to the database. .

2005-10-27 Thread Jason
Sorry, I should've replied to your post first, but, have you tried manually limiting the connections via PHP? Code used from Omega Engine (Copyright Omega Vortex): $ini_data = $engine-ini_data['file']; setup_errors(); if ($ini_data['DB']['connections'] 5) { $engine-error = There are too

[PHP-DB] problem with mysql_error()

2005-10-27 Thread Jason Gerfen
]\;$defined[mail]/a ); Because I have set a couple of the fields to unique I should be recieving an error of 'duplicate entry' but i am getting an empty result for mysql_error(). Any help is appreciated. -- Jason Gerfen Student Computing Labs, University Of Utah [EMAIL PROTECTED] J. Willard Marriott

RE: [PHP-DB] retrieve enum values

2005-04-14 Thread Jason
= mysql_fetch_row($result)) { $enumVal = $row[0]; $name= $row[1]; Print option value=\$enumVal\$name/option; } ? /select Hope that speaks to your question. Jason -Original Message- From: mel list_php [mailto:[EMAIL PROTECTED] Sent: Thursday, April 14, 2005 5:54 AM To: php-db@lists.php.net Subject

Re: [PHP-DB] password in md5 to connect to mysql instead of clear password

2005-02-28 Thread Jason Wong
this file owned and readable only by root. Set the program owned by root, executable by everyone and suid. If you don't need the flexibility of the custom program and would rather make use of existing infrastructure: http://marc.theaimsgroup.com/?l=php-generalm=110137778213700w=2 -- Jason Wong

Re: [PHP-DB] password in md5 to connect to mysql instead of clear password

2005-02-28 Thread Jason Wong
as. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * -- Search the list archives before you post http://marc.theaimsgroup.com/?l=php-db

Re: [PHP-DB] password in md5 to connect to mysql instead of clear password

2005-02-26 Thread Jason Wong
server. Now if someone somehow had access to your key then it's game over for you. Unless you password protected your key which -- would be extremely impractical. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet

Re: [PHP-DB] password in md5 to connect to mysql instead of clear password

2005-02-25 Thread Jason Wong
: if I have access to your key then I can connect. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * -- Search the list archives before you post

[PHP-DB] 'Page can not be displayed' when hitting the back button

2005-02-13 Thread Jason Walker
the POST DATA message stating that post data has already been sent, blah blah blah. In IE, I get the Page Can Not Be Display. I am just curious if anyone else has come across this and if they found a solution/cause. Thanks. Jason Walker

RE: [PHP-DB] 'Page can not be displayed' when hitting the back button

2005-02-13 Thread Jason Walker
security issues. I did find some stuff about this affecting downloads, but there are no downloads through PHP pages. Thanks. -Original Message- From: Jason Walker [mailto:[EMAIL PROTECTED] Sent: Sunday, February 13, 2005 7:17 PM To: php-db@lists.php.net Subject: [PHP-DB] 'Page can

Re: [PHP-DB] accessing mysql on non default port - windows

2005-02-05 Thread Jason Wong
. If mysql.default_port is not defined *then* it will start loking at other places (as detailed in the comments). -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development

Re: [PHP-DB] accessing mysql on non default port - windows

2005-02-05 Thread Jason Wong
/mysql client to a mysql server running on 330[not 6] All the time! -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * -- Search the list

Re: [PHP-DB] Storing JPEGS in MySQL

2005-02-02 Thread Jason Wong
. Yep, because you haven't stored anything resembling an image in the DB! -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * -- Search the list

Re: [PHP-DB] Table from an array?

2005-02-02 Thread Jason Wong
SQL statement to create table? -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * -- Search the list archives before you post http

Re: [PHP-DB] Auto Responses?

2005-01-23 Thread Jason Wong
from getting a auto response. Or if they own their own server they can do the same. More specifically, smart autoresponders will not respond to mailing lists, bounces, etc. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting

Re: [PHP-DB] Auto Responses?

2005-01-23 Thread Jason Wong
On Monday 24 January 2005 02:13, Samar wrote: On Mon, 24 Jan 2005 01:56:03 +0800, Jason Wong [EMAIL PROTECTED] wrote: More specifically, smart autoresponders will not respond to mailing lists, bounces, etc. If they are some kind of extensions or plug-ins to email clients, I guess you could

Re: [PHP-DB] mysql - image storing

2005-01-18 Thread Jason Wong
() should never be used on data retrieved from the DB (that is assuming your data was inserted correctly in the first place). -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development

Re: [PHP-DB] mysql - image storing

2005-01-18 Thread Jason Wong
On Wednesday 19 January 2005 01:51, [EMAIL PROTECTED] wrote: Jason, can you explain why stripslashes should not be used on data taken from the db? when you store data in the db i thought it was good practice to addslashes, when you retrieve from the db, you will need to use stripslashes

Re: [PHP-DB] ssh tunneling with phpmyadmin

2005-01-10 Thread Jason Wong
and port 13306. -- Jason Wong - Gremlins Associates - www.gremlins.biz Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * -- Search the list archives before you post http://marc.theaimsgroup.com/?l=php-db

[PHP-DB] Trying to connext to MySQL with PEAR

2005-01-06 Thread Jason Davis
funcitons on the db. Any thoughts on what might be wrong? Thanks Jason -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP-DB] Trying to connext to MySQL with PEAR

2005-01-06 Thread Jason Wong
On Thursday 06 January 2005 23:41, Jason Davis wrote: Hi all I am new to PHP and am trying to connect to mysql for the first time. In that case I strongly suggest that you at least vaguely familiarise yourself with using the basic PHP-native mysql_*() functions first. Go through the examples

Re: [PHP-DB] Trying to connext to MySQL with PEAR

2005-01-06 Thread Jason Davis
Pear DB version is 1.6.8 Jason Davis [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] MySQL 4.1 PHP 4.3.10 PEAR 0.5.0 (I think, not sure how to test that) On two different boxes one is an XP Pro box one is an Win2K Pro Box both running IIS Richard Hutchins [EMAIL PROTECTED

Re: [PHP-DB] Trying to connext to MySQL with PEAR

2005-01-06 Thread Jason Davis
Message- From: Jason Davis [mailto:[EMAIL PROTECTED] Sent: Thursday, January 06, 2005 10:42 AM To: php-db@lists.php.net Subject: [PHP-DB] Trying to connext to MySQL with PEAR Hi all I am new to PHP and am trying to connect to mysql for the first time. I get activity on the mysql monitor when

Re: [PHP-DB] Trying to connext to MySQL with PEAR

2005-01-06 Thread Jason Davis
Ok tried that and go this error message instead. Client does not support authentication protocol requested by server; consider upgrading MySQL client Going to MySQL site to try to figure out what this means/which other clients are available. Jason Davis Jason Wong [EMAIL PROTECTED] wrote

  1   2   3   4   5   6   7   8   9   >