Re: [PHP-DB] Waiting for localhost

part instead of the entire site. Jason Pruim 352.359.0002 > On Mar 15, 2015, at 2:40 PM, Ethan Rosenberg > 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

Re: [PHP-DB] Waiting for localhost

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 > wrote: > >> On 03/09/2015 08:27 AM, Ethan Rosenberg, PhD wrote: >>

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

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 v

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

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

[PHP-DB] Problem with mysql and php

g with a dataset of 89 million 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

[PHP-DB] Odd MySQL Problem...

Hey everyone,Have a weird issue that I can't seem to figure out...Using PHP to insert phone numbers into the site... I have the Area Code, & Exchange, and then dynamically create the last 4 digits... Once it's inserted it's dropping the leading zero's... Here's some samples:Copied from phpMySQL: Ed

Re: [PHP-DB] Working with large datasets

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 th

Re: [PHP-DB] Working with large datasets

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 t

Re: [PHP-DB] Working with large datasets

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

[PHP-DB] Working with large datasets

believe 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] Parsing Tab Delimited file

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 unders

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

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 tro

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

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. s

[PHP-DB] When does using multiple tables make sense?

er I think.. Was anyone able to determine what I am really asking in this long mess of words? :) -- 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, v

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

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

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

) Also... If you are dealing 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 :)

Re: [PHP-DB] Question about databases and foreign keys

pdate things with them! So if anyone knows of a good resource I'd appreciate it... Until then, I'm off to search the web and figure this stuff out! -- Jason Pruim Raoset Inc. Technology Manager MQC Specialist 11287 James St Holland, MI 49424 www.raoset.com [EMAIL PROTECTED]

[PHP-DB] Question about databases and foreign keys

store 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 Specia

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

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/)

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

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: to type="text" name="txtFName" READONLY> Read only fields still get passed with POST'ed info where as disabled does not. A

Re: [PHP-DB] Kesalahan posting?

ou get back. Thanks. -- PHP 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:

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

disable it then they don't submit. I need to find a better to stop accidental editing rather then just 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 very strange: ..

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

_escape_string() on your post variables before using them in a query. mysql_real_escape_string() won't help with my mysqlI connection though :) I will be wrapping the whole thing in a prepared statement before going to production with this. At this point this is simply a proof of conce

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

on the PK to the record correctly. One 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 PROTEC

[PHP-DB] Problem with updating MySQL table

) | YES | | NULL| | | City | varchar(20) | YES | | NULL| | | State | varchar(2) | YES | | NULL| | | Zip| varchar(10) | YES | | NULL| | | Coffee | varchar(20) | YES | | NULL| | | Meeting| text| YES | | NULL| | ++-+--+-+-+---+ The problem is when I am attempting to update some of the info, 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] Question about access rights in php/mysql

y get a piece of mail with the pURL on it, and then go there to "follow up" on the web. I think though that I will go with the 1 login, with a simple variable like to described. Thanks Dan! -- Jason Pruim Raoset Inc. Technology Manager MQC Specialist 11287 James St Holland, MI 49424 www.raoset.com [EMAIL PROTECTED]

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

ns to the database with 2 separate logins? One for the initial load which just has select privileges and a second for when they hit edit which then gives them update privileges? Or, should i just do 1 login with select, and update privileges? Any ideas or suggestions? Thanks! -- Jason Pru

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

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 [

Re: [PHP-DB] Timestamps

p.net/manual/en/language.operators.execution.php I'll have to take a look at that and see what it says in a little bit. -- 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.

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

have to email it. Basically I have 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 Su

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

Be a better friend, 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 Databas

Re: [PHP-DB] Timestamps

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 p

Re: [PHP-DB] Timestamps

d: Wed, 30 Apr 2008 10:39:11 AM CDT From: Jason Pruim <[EMAIL PROTECTED]> To: Stut <[EMAIL PROTECTED]>Cc: php-db@lists.php.net Subject: Re: [PHP-DB] Timestamps 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

Re: [PHP-DB] Timestamps

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

[PHP-DB] Timestamps

imple right? Not quite...in my database it's storing a "0" in the timestamp field which is a int(10) field. I have googled, and searched manuals, but have not been able to figure out what is going on Any Ideas? -- Jason Pruim Raoset Inc. Technology Manager MQC Spec

Re: [PHP-DB] php database

r question? -- 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] mysqli_stmt_bind_param question

to mess around 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

[PHP-DB] mysqli_stmt_bind_param question

and I just 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] Not updating certain fields in same row

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 f

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

Maybe you can post your full code? Evert Daniel Brown wrote: On Tue, Mar 25, 2008 at 1:14 PM, Jason Pruim <[EMAIL PROTECTED]> wrote: the actual query I'm using is this: $chpwsql = "UPDATE current SET customerName='$customerName', loginName='$log

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

PW = md5("$salt$password"); I can't undo the MD5 and I don't really want to... Just want to be able to change it rather then view what it is. On Tue, Mar 25, 2008 at 11:59 AM, Jason Pruim <[EMAIL PROTECTED]> wrote: Hi everyone, I am attempting to update

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

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.

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

a value in the form it sets the field to be blank in MySQL. 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] PHP, MySQL and Lookups

="$MySuperHardPassword"; Of course, this is untested 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 Specialis

Re: [PHP-DB] Question about database design

rminology? > > Any help would be greatly appreciated! > > Thanks for looking! > > ohhh... and in case it makes a difference it's MySQL 5.* and I'll be > writing the stuff to access that database with php 5. > > -- > > Jason Pruim > Raoset Inc. > Te

Re: [PHP-DB] Question about database design

t; database. Sounds like for your purposes that is a good idea. If you I missed anything or you have more specific questions, feel free to email me on or off list. Cheers, Tim Tim McGeary '99, '06G Senior Systems Specialist Lehigh University 610-758-4998 [EMAIL PROTECTED] Jaso

[PHP-DB] Question about database design

nd in case it makes a difference it's MySQL 5.* 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]