Re: [PHP] Chrome 1.0 released
Hah, the world will only be a small collateral fallout in the mighty battles . . . On Mon, 15 Dec 2008, German Geek wrote: Conspiracy against M$? I thought they were conspiring against the world :-) Tim-Hinnerk Heuer http://www.ihostnz.com On Mon, Dec 15, 2008 at 2:22 PM, Yeti y...@myhich.com wrote: It more and more seems like a conspiracy against M$ to me. A company trying to make up its own standards every once in a while, how can that be wrong? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Good PHP book?
O'reillys Learning PHP 5: http://oreilly.com/catalog/9780596005603/index.html Thank you, Micah Gersten onShore Networks Internal Developer http://www.onshore.com jeffery harris wrote: Hi guys/gals. I'm a first time user. Does anyone know of a good php book? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Re: apache and PHP / Eclipse
TEric Butera schrieb: On Sun, Dec 14, 2008 at 10:33 AM, Nathan Rixham nrix...@gmail.com wrote: Eduardo Vizcarra wrote: I am having a hard time trying to get some pages work. I have PHP 5.2.8, Apache 2.2 and MySQL 5.1 running in a Windows Vista home edition. All packages were installed, and configured, the strange thing is that pages commonly work but when I add a new line (e.g. an echo line) with a dummy text, Apache crashes and it is restarted I am using Eclipese europa to create the code e.g. I have this code and the page works: include 'upper_pagina.php'; include 'forma.php'; $link = mysql_connect(127.0.0.1,root,root); if (!$link) { echo table width='100%' border='0' cellspacing='0' cellpadding='5' bordercolor='FF'\n; echo tr\n; echo td bgcolor='FF9327'\n; echo bLa Base de datos no esta disponible en este momento.BR; echo Disculpe las molestias, intente mas tarde/b; echo /td\n; echo /tr\n; echo /table\n; } mysql_select_db(estoydevacacionesdb) or die(No pudo seleccionarse la BD.); $busquedasql1 = select * from servicios; include 'bottom_pagina.php'; but if I add a new line ($servicios1 = mysql_query($busquedasql1);) before the last include line, apache crashes, it has been very hard for me to identify what it is causing this problem any clue ? Regards Eduardo also.. you may find it worth while to upgrade to the PDT 2.0 version of eclipse which uses ganymede and comes with the zend debugger, allowing you to test and debug you're code in eclipse. http://www.zend.com/en/community/pdt -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php I was playing with that last week at work. It's quite buggy. Try to use Xampp apachefriends.org Regards Carlos -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] Good PHP book?
[snip] Hi guys/gals. I'm a first time user. Does anyone know of a good php book? [/snip] http://www.amazon.com/PHP-Advanced-Visual-QuickPro-Guide/dp/0321376013 if you are already a programmer but want to get up to speed on PHP -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] XML Get Value of Node DOMXPath
Hello all, Need help to get the value of the node. We know how to get the value of the city , item and itemPrice nodes below. How do we get the value of NumberOfRooms? $hotelElements = $xpath-query( '', $searchReponseElement ); foreach( $hotelElements as $hotelElement ) { $city = $xpath-query( 'City' , $hotelElement ); $item = $xpath-query( 'Item' , $hotelElement ); $itemPrice = $xpath-query( 'ItemPrice' , $hotelElement ); $confirmation = $xpath-query( 'Confirmation' , $hotelElement ); } Here is an example of the XML Response: Hotel HasExtraInfo=true City Code=AMS![CDATA[ Amsterdam ]]/City Item Code=JAN![CDATA[ JAN LUYKEN HTL AND RESIDENCE]]/Item LocationDetails Location Code=G1![CDATA[ Central ]]/Location /LocationDetails StarRating4/StarRating HotelRooms HotelRoom Code=SB NumberOfRooms=1 / HotelRoom Code=TB ExtraBed=true NumberCots=1 NumberOfExtraBeds=2 NumberOfRooms=1 SharingBedding=true / /HotelRooms Thanks -- View this message in context: http://www.nabble.com/XML-Get-Value-of-Node-DOMXPath-tp21015877p21015877.html Sent from the PHP - General mailing list archive at Nabble.com. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Re: apache and PHP / Eclipse
On Sun, Dec 14, 2008 at 10:33 AM, Nathan Rixham nrix...@gmail.com wrote: Eduardo Vizcarra wrote: I am having a hard time trying to get some pages work. I have PHP 5.2.8, Apache 2.2 and MySQL 5.1 running in a Windows Vista home edition. All packages were installed, and configured, the strange thing is that pages commonly work but when I add a new line (e.g. an echo line) with a dummy text, Apache crashes and it is restarted I am using Eclipese europa to create the code e.g. I have this code and the page works: include 'upper_pagina.php'; include 'forma.php'; $link = mysql_connect(127.0.0.1,root,root); if (!$link) { echo table width='100%' border='0' cellspacing='0' cellpadding='5' bordercolor='FF'\n; echo tr\n; echo td bgcolor='FF9327'\n; echo bLa Base de datos no esta disponible en este momento.BR; echo Disculpe las molestias, intente mas tarde/b; echo /td\n; echo /tr\n; echo /table\n; } mysql_select_db(estoydevacacionesdb) or die(No pudo seleccionarse la BD.); $busquedasql1 = select * from servicios; include 'bottom_pagina.php'; but if I add a new line ($servicios1 = mysql_query($busquedasql1);) before the last include line, apache crashes, it has been very hard for me to identify what it is causing this problem any clue ? Regards Eduardo also.. you may find it worth while to upgrade to the PDT 2.0 version of eclipse which uses ganymede and comes with the zend debugger, allowing you to test and debug you're code in eclipse. http://www.zend.com/en/community/pdt -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php I was playing with that last week at work. It's quite buggy. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Chrome 1.0 released
At 5:22 PM -0800 12/14/08, Yeti wrote: It more and more seems like a conspiracy against M$ to me. A company trying to make up its own standards every once in a while, how can that be wrong? The more experienced you become, the more you'll see M$ for what it is. They are concerned about the bottom line and nothing else. If complying to standards serves their interest, then they will. However if they can figure out a way to make money by not complying, then they won't. One can say that all companies are concerned about the bottom line, but not all companies rate that at the expense of everything else. Cheers, tedd -- --- http://sperling.com http://ancientstones.com http://earthstones.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] header modify errors
I am working from home today and getting this error with my copy of my project: *Warning*: Cannot modify header information - headers already sent by (output started at C:\Inetpub\Xampp\htdocs\SNLeader\WOSystem\Welcome.php:31) in *C:\Inetpub\Xampp\htdocs\SNLeader\WOSystem\inc\dbconn_openTest.php* on line *3* *Warning*: Cannot modify header information - headers already sent by (output started at C:\Inetpub\Xampp\htdocs\SNLeader\WOSystem\Welcome.php:31) in *C:\Inetpub\Xampp\htdocs\SNLeader\WOSystem\inc\dbconn_openTest.php* on line *4* Could not connect to the database. I have set my php.ini file output_buffering to ON it was off (read in a past post that will fix this error--but it did not) I also set session.cache_limiter = to nothing it was set to nocache Any other things I'm missing? Thanks Terion
[PHP] Re: header modify errors
Terion Miller wrote: I am working from home today and getting this error with my copy of my project: *Warning*: Cannot modify header information - headers already sent by (output started at C:\Inetpub\Xampp\htdocs\SNLeader\WOSystem\Welcome.php:31) in *C:\Inetpub\Xampp\htdocs\SNLeader\WOSystem\inc\dbconn_openTest.php* on line *3* *Warning*: Cannot modify header information - headers already sent by (output started at C:\Inetpub\Xampp\htdocs\SNLeader\WOSystem\Welcome.php:31) in *C:\Inetpub\Xampp\htdocs\SNLeader\WOSystem\inc\dbconn_openTest.php* on line *4* Could not connect to the database. I have set my php.ini file output_buffering to ON it was off (read in a past post that will fix this error--but it did not) I also set session.cache_limiter = to nothing it was set to nocache Any other things I'm missing? Thanks Terion What's on/around line 31 in Welcome.php? J -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] header modify errors
Terion Miller wrote: I am working from home today and getting this error with my copy of my project: *Warning*: Cannot modify header information - headers already sent by (output started at C:\Inetpub\Xampp\htdocs\SNLeader\WOSystem\Welcome.php:31) in *C:\Inetpub\Xampp\htdocs\SNLeader\WOSystem\inc\dbconn_openTest.php* on line *3* *Warning*: Cannot modify header information - headers already sent by (output started at C:\Inetpub\Xampp\htdocs\SNLeader\WOSystem\Welcome.php:31) in *C:\Inetpub\Xampp\htdocs\SNLeader\WOSystem\inc\dbconn_openTest.php* on line *4* Could not connect to the database. I have set my php.ini file output_buffering to ON it was off (read in a past post that will fix this error--but it did not) I also set session.cache_limiter = to nothing it was set to nocache Any other things I'm missing? Thanks Terion Make sure you have no .htaccess or VirtualHost ... blocks that are overriding your php.ini settings. Plus, make sure you restart to make the changes take effect. -- Jim Lucas Some men are born to greatness, some achieve greatness, and some have greatness thrust upon them. Twelfth Night, Act II, Scene V by William Shakespeare -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Re: header modify errors
Jay Moore wrote: Terion Miller wrote: I am working from home today and getting this error with my copy of my project: *Warning*: Cannot modify header information - headers already sent by (output started at C:\Inetpub\Xampp\htdocs\SNLeader\WOSystem\Welcome.php:31) in *C:\Inetpub\Xampp\htdocs\SNLeader\WOSystem\inc\dbconn_openTest.php* on line *3* *Warning*: Cannot modify header information - headers already sent by (output started at C:\Inetpub\Xampp\htdocs\SNLeader\WOSystem\Welcome.php:31) in *C:\Inetpub\Xampp\htdocs\SNLeader\WOSystem\inc\dbconn_openTest.php* on line *4* Could not connect to the database. I have set my php.ini file output_buffering to ON it was off (read in a past post that will fix this error--but it did not) I also set session.cache_limiter = to nothing it was set to nocache Any other things I'm missing? Thanks Terion What's on/around line 31 in Welcome.php? J Jay. I agree with your thought process. Why not fix the warning instead of hiding it. But that isn't what the OP is asking for. I think the OP understands why it is giving this warning, but is looking for a way to not display the error. Sounds like his production environment is setup to where it does not display the warning. So, he wants his newly installed test machine to match what the production is doing. Correct me if I'm wrong Terion. -- Jim Lucas Some men are born to greatness, some achieve greatness, and some have greatness thrust upon them. Twelfth Night, Act II, Scene V by William Shakespeare -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Re: header modify errors
On Mon, Dec 15, 2008 at 11:37 AM, Jim Lucas li...@cmsws.com wrote: Jay Moore wrote: Terion Miller wrote: I am working from home today and getting this error with my copy of my project: *Warning*: Cannot modify header information - headers already sent by (output started at C:\Inetpub\Xampp\htdocs\SNLeader\WOSystem\Welcome.php:31) in *C:\Inetpub\Xampp\htdocs\SNLeader\WOSystem\inc\dbconn_openTest.php* on line *3* *Warning*: Cannot modify header information - headers already sent by (output started at C:\Inetpub\Xampp\htdocs\SNLeader\WOSystem\Welcome.php:31) in *C:\Inetpub\Xampp\htdocs\SNLeader\WOSystem\inc\dbconn_openTest.php* on line *4* Could not connect to the database. I have set my php.ini file output_buffering to ON it was off (read in a past post that will fix this error--but it did not) I also set session.cache_limiter = to nothing it was set to nocache Any other things I'm missing? Thanks Terion What's on/around line 31 in Welcome.php? J Jay. I agree with your thought process. Why not fix the warning instead of hiding it. But that isn't what the OP is asking for. I think the OP understands why it is giving this warning, but is looking for a way to not display the error. Sounds like his production environment is setup to where it does not display the warning. So, he wants his newly installed test machine to match what the production is doing. Correct me if I'm wrong Terion. -- Jim Lucas Some men are born to greatness, some achieve greatness, and some have greatness thrust upon them. Twelfth Night, Act II, Scene V by William Shakespeare -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php Well If there is a problem with the script and that is why its giving the warning I would want to fix that, I just figured the php.ini file on the live server at the office is different from the one i have on my home xampp install and I am not allowed access to the php.ini on the server at work, I just tried getting it to compare it to my own. I have to go check to see about the .htaccess file, I need to read up on these, like what is the difference and if you have one do you need the other? .htaccess is for directory control yes? If that is the case there is none in the directory I have this project in. I just stopped and restarted my xampp and that didn't work either...should I make a .htaccess file for this directory to over ride whatever setting is preventing the headers from loading? Thanks guys Terion
Re: [PHP] Re: header modify errors
Hey, Few things: 1) Check to see if you have any trailing spaces after the end of the file. 2) Check to see if your session_start() is not the first line of the code. Thanks, V On Mon, Dec 15, 2008 at 9:36 AM, Terion Miller webdev.ter...@gmail.comwrote: On Mon, Dec 15, 2008 at 11:29 AM, Jay Moore jaymo...@accu-com.com wrote: Terion Miller wrote: I am working from home today and getting this error with my copy of my project: *Warning*: Cannot modify header information - headers already sent by (output started at C:\Inetpub\Xampp\htdocs\SNLeader\WOSystem\Welcome.php:31) in *C:\Inetpub\Xampp\htdocs\SNLeader\WOSystem\inc\dbconn_openTest.php* on line *3* *Warning*: Cannot modify header information - headers already sent by (output started at C:\Inetpub\Xampp\htdocs\SNLeader\WOSystem\Welcome.php:31) in *C:\Inetpub\Xampp\htdocs\SNLeader\WOSystem\inc\dbconn_openTest.php* on line *4* Could not connect to the database. I have set my php.ini file output_buffering to ON it was off (read in a past post that will fix this error--but it did not) I also set session.cache_limiter = to nothing it was set to nocache Any other things I'm missing? Thanks Terion What's on/around line 31 in Welcome.php? J Line 32-36 are: ?php If (!empty($msg)){ echo div class=\Error\. $msg ./divBRBR; } ? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Re: header modify errors
On Mon, Dec 15, 2008 at 11:29 AM, Jay Moore jaymo...@accu-com.com wrote: Terion Miller wrote: I am working from home today and getting this error with my copy of my project: *Warning*: Cannot modify header information - headers already sent by (output started at C:\Inetpub\Xampp\htdocs\SNLeader\WOSystem\Welcome.php:31) in *C:\Inetpub\Xampp\htdocs\SNLeader\WOSystem\inc\dbconn_openTest.php* on line *3* *Warning*: Cannot modify header information - headers already sent by (output started at C:\Inetpub\Xampp\htdocs\SNLeader\WOSystem\Welcome.php:31) in *C:\Inetpub\Xampp\htdocs\SNLeader\WOSystem\inc\dbconn_openTest.php* on line *4* Could not connect to the database. I have set my php.ini file output_buffering to ON it was off (read in a past post that will fix this error--but it did not) I also set session.cache_limiter = to nothing it was set to nocache Any other things I'm missing? Thanks Terion What's on/around line 31 in Welcome.php? J Line 32-36 are: ?php If (!empty($msg)){ echo div class=\Error\. $msg ./divBRBR; } ? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] new xampp server problem w/mail
hi I have been searching for a way to get the php mail function to work and have had no luck. I was hoping you could address my situation: I have a fairly new xampp install and I need to know how to get mail() to work. I would like to know tha simplest way possible to get the mail function to work. I guess the major problem is that my xampp install doesn't have an email server. please advise my what I need to do to get one for a linux box. Please keep in mind that I am a newbie and need detailed instructions for installing any software and configuring any files that may need altered in the server's configuration files such as php.ini etc... email me at linia...@yahoo.com if you can help. Thanks, Ian
Re: [PHP] new xampp server problem w/mail
Ian Lin wrote: hi I have been searching for a way to get the php mail function to work and have had no luck. I was hoping you could address my situation: I have a fairly new xampp install and I need to know how to get mail() to work. I would like to know tha simplest way possible to get the mail function to work. I guess the major problem is that my xampp install doesn't have an email server. please advise my what I need to do to get one for a linux box. Please keep in mind that I am a newbie and need detailed instructions for installing any software and configuring any files that may need altered in the server's configuration files such as php.ini etc... email me at linia...@yahoo.com if you can help. Thanks, Ian Why is it a requirement to use mail() ?? Why not use a package like phpmailer or some such email lib? -- Jim Lucas Some men are born to greatness, some achieve greatness, and some have greatness thrust upon them. Twelfth Night, Act II, Scene V by William Shakespeare -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: header modify errors
Terion Miller wrote: *Warning*: Cannot modify header information - headers already sent by (output started at C:\Inetpub\Xampp\htdocs\SNLeader\WOSystem\Welcome.php:31) in *C:\Inetpub\Xampp\htdocs\SNLeader\WOSystem\inc\dbconn_openTest.php* on line *3* Line 32-36 are: ?php If (!empty($msg)){ echo div class=\Error\. $msg ./divBRBR; } ? stick an ob_start(); at the beginning of the file and php will not complain about output started any longer. -jsd- -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] new xampp server problem w/mail
On Mon, Dec 15, 2008 at 2:49 PM, Jim Lucas li...@cmsws.com wrote: Ian Lin wrote: hi I have been searching for a way to get the php mail function to work and have had no luck. I was hoping you could address my situation: I have a fairly new xampp install and I need to know how to get mail() to work. I would like to know tha simplest way possible to get the mail function to work. I guess the major problem is that my xampp install doesn't have an email server. please advise my what I need to do to get one for a linux box. Please keep in mind that I am a newbie and need detailed instructions for installing any software and configuring any files that may need altered in the server's configuration files such as php.ini etc... email me at linia...@yahoo.com if you can help. Thanks, Ian Why is it a requirement to use mail() ?? Why not use a package like phpmailer or some such email lib? -- Jim Lucas Some men are born to greatness, some achieve greatness, and some have greatness thrust upon them. Twelfth Night, Act II, Scene V by William Shakespeare -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php Getting email to work on a Windows installed local machine is a pain in the ass...I usually just code it and test it online since I tend to use the same code all the time -- Bastien Cat, the other other white meat
Re: [PHP] new xampp server problem w/mail
Lets keep things on the list! Ian Lin wrote: Jim Lucas, Thank you for your advise! It is not necessarily crucia that I use the mail() function, but that is what I usually use when writing email scripts for my clients because thier servers all support it. I am a web designer and would like to be able to test these scripts on my server before moving the files to the customer's server. However if it is going to be a mjor pain in the rear to get the php mail() function to work, I still need some way to send emails from php scripts for my own sites, So what solution would you reccomend I try first? --- On Mon, 12/15/08, Jim Lucas li...@cmsws.com wrote: From: Jim Lucas li...@cmsws.com Subject: Re: [PHP] new xampp server problem w/mail To: linia...@yahoo.com Cc: php-general@lists.php.net php-general@lists.php.net Date: Monday, December 15, 2008, 7:49 PM Ian Lin wrote: hi I have been searching for a way to get the php mail function to work and have had no luck. I was hoping you could address my situation: I have a fairly new xampp install and I need to know how to get mail() to work. I would like to know tha simplest way possible to get the mail function to work. I guess the major problem is that my xampp install doesn't have an email server. please advise my what I need to do to get one for a linux box. Please keep in mind that I am a newbie and need detailed instructions for installing any software and configuring any files that may need altered in the server's configuration files such as php.ini etc... email me at linia...@yahoo.com if you can help. Thanks, Ian Why is it a requirement to use mail() ?? Why not use a package like phpmailer or some such email lib? I would integrate a email lib like phpmailer [1] or swiftmailer [2] so that it is surely to work from 99.% of the web hosts. All you need is an outside POP3/SMTP service that allows you to send email and your good to go. 1. http://sourceforge.net/projects/phpmailer/ 2. http://sourceforge.net/projects/swiftmailer/ -- Jim Lucas Some men are born to greatness, some achieve greatness, and some have greatness thrust upon them. Twelfth Night, Act II, Scene V by William Shakespeare -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] new xampp server problem w/mail
Assuming your local box is not wide open to the 'net for mail relaying, install Pegasus/Mercury mail server and call it done. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Credit Card processing: Chase PaymenTech
Thanks, Guys -- To those who say 'move providers' -- I can't. My client, which also sells a bunch of other stuff on-line has an exclusive arrangement with that processor. How about using gateway providers? Any experience with that? Ken On Dec 15, 2008, at 1:06 AM, clive wrote: phphelp -- kbk wrote: Anybody have modules, code, tips, land mines, or any other information for doing credit card processing with PaymenTech that you would be willing to share? Ken - I think your first step is to find another provider, support is everything, your code can be 110% correct, but if there is 1 item wrong in the comms you have with PaymenTech, then you can spend hours if not days with a broken application. This recently happened with me and HSBC bank in the UK, rubbish support, my code look right, but nothing worked, until after a number of days I managed to get through to one of the developers of there payment gateway system, he was able to a make a few changesto the xml I sending and just like that I was able to process payments. Move providers Clive -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[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 2. All that matters is that it's unique, and isn't a number that can be guessed or an autoincrement number, where a hacker can just figure out the keyvalue by incrementing numbers. It doesn't matter to me if each keyvalue field is just numbers, or a number/letter combination - - - all that matters is that each keyvalue field is unique. Is there an automatic way that mySQL could do that, or would I need to write a php script to somehow go through each record and create this unique value? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Create unique non-autoincrement key for 700,000 records?
On Mon, Dec 15, 2008 at 9:29 PM, Rob Gould gould...@mac.com wrote: 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 2. All that matters is that it's unique, and isn't a number that can be guessed or an autoincrement number, where a hacker can just figure out the keyvalue by incrementing numbers. It doesn't matter to me if each keyvalue field is just numbers, or a number/letter combination - - - all that matters is that each keyvalue field is unique. Is there an automatic way that mySQL could do that, or would I need to write a php script to somehow go through each record and create this unique value? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php update mytable set hash_field = md5(AutoIdField + unix_timestamp()) -- Bastien Cat, the other other white meat
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 phps...@gmail.com wrote: On Mon, Dec 15, 2008 at 9:29 PM, Rob Gould gould...@mac.com wrote: 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 2. All that matters is that it's unique, and isn't a number that can be guessed or an autoincrement number, where a hacker can just figure out the keyvalue by incrementing numbers. It doesn't matter to me if each keyvalue field is just numbers, or a number/letter combination - - - all that matters is that each keyvalue field is unique. Is there an automatic way that mySQL could do that, or would I need to write a php script to somehow go through each record and create this unique value? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php update mytable set hash_field = md5(AutoIdField + unix_timestamp()) -- Bastien Cat, the other other white meat -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Create unique non-autoincrement key for 700,000 records?
If i had to guess, it would be the column/field in the table that has the autoincrement value. Tim-Hinnerk Heuer http://www.ihostnz.com On Tue, Dec 16, 2008 at 5:29 PM, Rob Gould gould...@mac.com wrote: 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 phps...@gmail.com wrote: On Mon, Dec 15, 2008 at 9:29 PM, Rob Gould gould...@mac.com wrote: 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 2. All that matters is that it's unique, and isn't a number that can be guessed or an autoincrement number, where a hacker can just figure out the keyvalue by incrementing numbers. It doesn't matter to me if each keyvalue field is just numbers, or a number/letter combination - - - all that matters is that each keyvalue field is unique. Is there an automatic way that mySQL could do that, or would I need to write a php script to somehow go through each record and create this unique value? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php update mytable set hash_field = md5(AutoIdField + unix_timestamp()) -- Bastien Cat, the other other white meat -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Create unique non-autoincrement key for 700,000 records?
At 11:29 PM -0500 12/15/08, Rob Gould wrote: update mytable set hash_field = md5(AutoIdField + unix_timestamp()) I _think_ I understand that - - - - but what does the AutoldField variable mean? He probably intends AutoIdField to be a stand-in for whatever your current auto increment column is called. You probably want to create a unique index - http://dev.mysql.com/doc/refman/5.0/en/create-index.html - on hash_value as well for (1) performance and (2) to ensure against duplicate values (which are, admittedly, pretty unlikely). Another alternative is to use the uuid() function - http://dev.mysql.com/doc/refman/5.0/en/miscellaneous-functions.html#function_uuid - instead of the md5() above, eg update mytable set unique_field=uuid(); - steve On Monday, December 15, 2008, at 09:37PM, Bastien Koert phps...@gmail.com wrote: On Mon, Dec 15, 2008 at 9:29 PM, Rob Gould gould...@mac.com wrote: 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 2. All that matters is that it's unique, and isn't a number that can be guessed or an autoincrement number, where a hacker can just figure out the keyvalue by incrementing numbers. It doesn't matter to me if each keyvalue field is just numbers, or a number/letter combination - - - all that matters is that each keyvalue field is unique. Is there an automatic way that mySQL could do that, or would I need to write a php script to somehow go through each record and create this unique value? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php update mytable set hash_field = md5(AutoIdField + unix_timestamp()) -- Bastien Cat, the other other white meat -- +--- my people are the people of the dessert, ---+ | Steve Edberghttp://pgfsun.ucdavis.edu/ | | UC Davis Genome Centersbedb...@ucdavis.edu | | Bioinformatics programming/database/sysadmin (530)754-9127 | + said t e lawrence, picking up his fork + -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: Create unique non-autoincrement key for 700,000 records?
I use md5(microtime()); -- Ondrej Kulaty Rob Gould gould...@mac.com píse v diskusním príspevku news:1492934866135048840337272044147195196-webm...@me.com... 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 2. All that matters is that it's unique, and isn't a number that can be guessed or an autoincrement number, where a hacker can just figure out the keyvalue by incrementing numbers. It doesn't matter to me if each keyvalue field is just numbers, or a number/letter combination - - - all that matters is that each keyvalue field is unique. Is there an automatic way that mySQL could do that, or would I need to write a php script to somehow go through each record and create this unique value? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Re: Create unique non-autoincrement key for 700,000 records?
On Tue, 2008-12-16 at 07:35 +0100, Ondrej Kulaty wrote: I use md5(microtime()); I applaud the use of PHP on the PHP list... but I think the OP wants an SQL query :) Cheers, Rob. -- http://www.interjinn.com Application and Templating Framework for PHP -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php