[PHP] Create unique non-autoincrement key for 700,000 records?

I have a mySQL database with 700,000 records in it, which are presently keyed with an "auto-increment" field. What I'd like to do is create another field with a field where each and every record number has a unique keyvalue. Example: "su5e23vlskd" for records 1, and "34fdfdsglkdj4" for record

Re: [PHP] Create unique non-autoincrement key for 700,000 records?

update mytable set hash_field = md5(AutoIdField + unix_timestamp()) I _think_ I understand that - - - - but what does the "AutoldField" variable mean? On Monday, December 15, 2008, at 09:37PM, "Bastien Koert" wrote: >On Mon, Dec 15, 2008 at 9:29 PM, Rob Goul

[PHP] Can PHP be used to snatch images cross-domain?

If I have a php script on my own server, can it be used to snatch a JPEG image off of another server on a different domain and upload it to my server? For example, could I provide an URL to an image on another server and a path on my own server in which to place it? I know in the world of Ajax

Re: [PHP] Can PHP be used to snatch images cross-domain?

I'm not sure how to pass an URL into it to get and save to a special directory on my server. I like your example better. On Tuesday, December 16, 2008, at 09:41PM, "Robert Cummings" wrote: >On Tue, 2008-12-16 at 21:29 -0500, Rob Gould wrote: >> If I have a php script

[PHP] PHP/MySQL ISP recommendation that lets one edit ft_min_word_len variable?

Can anyone here recommend an ISP that will let me have a dedicated server (not shared), and also allow me to adjust the ft_min_word_len mySQL parameter? I was originally thinking Dreamhost PS, but I recently found out that they do not allow changes to mySQL environmental variables. I really need

[PHP] Best way to reinstate radio-button states from database?

I have a webpage which allows people to log in and make selections with radio buttons and hit SUBMIT and saves the data from those radio buttons to a mySQL database. However, I'm finding that I also need the ability to allow a user to log back in at a later date (or even on a different comp

[PHP] PHP script for detecting pattern sequences?

Can anyone tell me if there's a PHP library out there that will help me determine "pattern sequences" from a string? Example input: 032258064516129032258064516129032258064516129032258064516129 Sequence = 032258064516129 037037037037037037037037037037037037037037037037037037037037 S

[PHP] use preg_replace to nix and line with "display: none"

I have a bunch of bullets in a list coming from a previous post, and I need to eliminate any line from this string that contains "display: none" Reserved Frontstretch Tower Ticket to the Camping World 300 on Saturday Reserved Frontstretch Tower Ticket to the Daytona 500 on Sunday

Re: [PHP] use preg_replace to nix and line with "display: none"

I wish I could say this works, but I'm not having success with this pattern. All the lines with display: none are still in the $bl string. On Aug 9, 2009, at 1:50 AM, LinuxManMikeC wrote: Reserved Frontstretch Tower Ticket to the Camping World 300 on Saturday Reserved Frontstretch T

Re: [PHP] use preg_replace to nix and line with "display: none"

Yay! That worked. Thanks! On Aug 9, 2009, at 1:53 AM, Michael A. Peters wrote: Rob Gould wrote: I have a bunch of bullets in a list coming from a previous post, and I need to eliminate any line from this string that contains "display: none" Reserved Frontstretch Tower Tic

[PHP] Way to XML-parse data with

Sorry if this is a duplicate post, I'm new to the listserve and I'm not sure my first message made it through I've been trying to retro-fit sample code found at : http:// www.sitepoint.com/article/php-xml-parsing-rss-1-0 to parse XML coming from a server. I'm sooo close to getting this

[PHP] $35 to the first person who can do this XML-parsing PHP script

Ok, well after fiddling around with PHP samples from the web for a few hours, I'm shot. But I have a project due soon that relies on this so I'm willing to pay someone: I'll send $35 to someone via paypal who can create a PHP script that will do the following: 1) Read XML data from an U

Re: [PHP] Re: $35 to the first person who can do this XML-parsing PHP script

Ok, well at least I'm honing in on the problems now. I appears that my ISP is only running php 4.4.4. So back in the PHP 4-days, what was the preferred method of doing such things? - Rob On Mar 8, 2007, at 3:13 PM, Ben Ramsey wrote: On 3/8/07 2:59 PM, Rob Gould wrote: 1) Rea

Re: [PHP] $35 to the first person who can do this XML-parsing PHP script

I have to say this is the most helpful listserve I've ever joined! Such friendly people and such good information. Well, the main thing I learned is - - - PHP 5 rocks, and PHP 4 semi- rocks, but not enough to make XML-parsing enjoyable. So, what I did was I installed MAMP on my Mac OS X box

[PHP] How to take output from an include, and embed it into a variable?

I have an invoice table that is drawn on a number of pages, so I have all the logic in an include-file like this: include "invoicetable_bottom.php"; However, now I'm needing to take the output from that include file and pass it as an email. To do that, I need to somehow take the output f

[PHP] RewriteRule to hide PHP vars in URL

I'm trying to follow the RewriteRule docs to make it so that: http://benchwarmersports.com/packages/super-bowl-xliv/1 can be entered into the web-browser, and it transforms into: http://benchwarmersports.com/packages.php?title=super-bowl-xliv&eventid=1 The good news is that it does transform

Re: [PHP] RewriteRule to hide PHP vars in URL

Isn't there a way to tell the Rewrite rule to skip anything found in a js or images subfolder? On Oct 25, 2009, at 12:26 PM, Ashley Sheridan wrote: On Sun, 2009-10-25 at 11:04 -0400, Rob Gould wrote: I'm trying to follow the RewriteRule docs to make it so tha

[PHP] UrlRewrite htaccess confusion

I feel like I'm really close to a solution for the clean-url method in htaccess. I've successfully got it now so that: http://benchwarmersports.com/packages/basketball/2010/nba-all-star-game maps to: http://benchwarmersports.com/packages.php?category=basketball&year=2010&title=nba-all-star-g

[PHP] Re: UrlRewrite htaccess confusion

You are indeed correct! Absolute URLs for everything, images, css, javascript, and links fixed the issue. Took me forever to change every link in the whole site, but it's happy now. Seems like there ought to be an easier way. On Oct 29, 2009, at 10:52 AM, Shawn McKenzie wrote:

[PHP] How to POST JSON data via PHP?

I've used curl before to post "field" data to a server, but in this case, I actaully need to post JSON data. However, when I run this PHP script, I get nothing back. If I do this curl manually in Terminal, it works. I'm pretty sure the bug has something to do with CURLOPT_POSTFIELDS - -

[PHP] help with preg_replace pattern

It appears that IE renders it's display: none in all caps while Firefox and other browsers pass it back in lowercase. This throws off my php line of code the is supposed to nuke blank bullets from a string of text: $bl = Reserved Frontstretch Tower Ticket to the NextEra Energy Reso

[PHP] PHP or SQL to do this?

I'm not sure if I need to write a PHP for-loop to do this, or if it can all be done in one SQL statement? Basically, I want to copy all the barcodes from one table and put them into another table, but only if the barcode in the first table > 0, and only if the wineid's match from table to table

[PHP] PHP to access shell script to print barcodes

I am trying to replicate the functionality that I see on this site: http://blog.maniac.nl/webbased-pdf-lto-barcode-generator/ Notice after you hit SUBMIT QUERY, you get a PDF file with a page of barcodes. That's _exactly_ what I'm after. Fortunately, the author gives step-by-step instructions o

Re: [PHP] PHP to access shell script to print barcodes

27;s the source file that works. Where PHP would be handy is at the very bottom of the script http://www.winecarepro.com/kiosk/fast/shell/barcodemerge.ps.zip On Mar 23, 2010, at 7:48 AM, Richard Quadling wrote: > On 23 March 2010 05:48, Jochem Maas wrote: >> Op 3/23/10 3:27 AM, Rob

Re: [PHP] PHP to access shell script to print barcodes

der("Content-Disposition: attachment; filename: 'barcodemerge.ps'"); > > That tells the browser to download the file. You can also try setting > the content-type > > header('Content-type: application/postscript'); > > Either of the above might do

[PHP] Server-side postscript-to-PDF on-the-fly conversion

Is there a free solution out there that will enable me to take a PHP-generated postscript output file, and dynamically, on-the-fly convert it to a PDF document and send to the user as a download when the user clients on a link? More description of what I'm trying to do: 1) I've got a web-page

[PHP] Looking for PHP/JS/MySQL gurus in the Northern VA area

Can anyone tell me if there are folks on this list in the Northern VA area? I need to find a freelancer who knows PHP, Javascript, and mySQL. My client likes face-to-face meetings on occasion, so I really need someone local. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, vi

[PHP] Help! Having trouble getting one XML field from this feed reliably

Can anyone tell me what I'm doing wrong here? I'm trying to get the VASTAdTagURI field from the XML data at this url: http://afe.specificclick.net/?l=32259&t=x&rnd=123456 Here's my code. (below). It works maybe 30% of the time, but most of the time it just returns nothing from that field.

[PHP] How to handle rows of checkboxes upon form submit?

Let's say I have a PHP script which lists a series of objects for sale at a yard sale, each with a checkbox to the left of the name of the item. If I wanted to have a submit button, and run through the list of items that were checked and act on them, how would I do that? To gain some knowledge,

[PHP] How to take video embed codes and change all their widths/heights?

Can anytime give me some insights on how to write a PHP script that could accept any of the below strings below and edit the strings to change their width and height settings dynamically? For instance, if I want all embedded videos to have a width of 320, and a height of 240, using PHP's st

[PHP] PHP/mySQL question about groups

Let's say I have a PHP-based wine application, and it's taking a set of mySQL data that looks like this: wineidname size 123 Silver Oak 750ML 123

[PHP] question about database field-types and special characters

I've got a PHP application that pulls in data from a mySQL database. The data is a series of wine producers, and many of them have special foreign characters over the a's and o's. When I go and view the data from my database using myPHPAdmin, the characters look fine, but when I pull the dat

[PHP] PHP/mySQL dropping zeros after inserting number into record

I've got a PHP script that inserts "00012345678" into a record in a mySQL database (it's a barcode). Things work ok unless the number has preceding zeros, and then the zeros get cut off and all I get is "12345678". I have the mySQL database fieldtype set to bigint(14). If the maximum length a

[PHP] Copying specific fields from table to table

I've got 2 tables. One table which contains a series of barcodes assigned to product id #'s, and another table with JUST product id #'s. I need to somehow transfer all the barcodes from the first table into the second table, but only where the id #'s match. Can anyone tell me if this is someth

[PHP] Character set problems

I'm having a hard time figuring out why my character sets and data look when when viewed in phpAdmin when browsing the table-columns, but then I go to show the data on my web-page with PHP, I get garbage-characters where I should be seeing apostrophs and special foreign-characters. I copied all

Re: [PHP] Character set problems

in my code everywhere I make a SQL call? On Thursday, April 03, 2008, at 11:14PM, "Robert Cummings" <[EMAIL PROTECTED]> wrote: > >On Thu, 2008-04-03 at 21:56 -0700, Rob Gould wrote: >> I'm having a hard time figuring out why my character sets and data look whe

[PHP] How to determine which column "matched"

I'm trying to figure out a way that SQL can pass a flag to PHP to say which column "matched" during a query. Let's say for instance that I want to search for the word "apple" in both column "producer", and column "designation". I was hoping I could do something like this: Select producer,

[PHP] Can Safari 3 be forced to cache a large jpeg with PHP headers?

I am creating a touch-screen kiosk application, using a full-screen version of Safari 3.1, and was wondering if there's a way I can force Safari to cache a large background image JPEG. What I'm finding is that Safari 3 will sometimes cache my large 1.1 MB background image (1680x1050), and dis

[PHP] PHP/mySQL question using ORDER BY with logic

Question about mySQL and PHP, when using the mySQL ORDER BY method... Basically I've got data coming from the database where a "wine producer-name" is a word like: Château Bahans Haut-Brion or La Chapelle de La Mission Haut-Brion or Le Clarence de

[PHP] Query-within-a-query with mySQL/PHP

This is somewhat complicated, so I'll try to give examples with real- world data. Basically, I'd like to know how I could take data like this, from mySQL: 2006 Liberty School Central Coast, California, Central Coast, USA Chardonnay 2006 Liberty School Paso Robles, California, Central Coast, U