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 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 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 "\n";
echo "\n";
echo "\n";
echo "La Base de datos no esta disponible en este momento.";
echo "Disculpe las molestias, intente mas tarde";
echo "\n";
echo "\n";
echo "\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:
4
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 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 "> bordercolor='FF'>\n";
>> echo "\n";
>> echo "\n";
>> echo "La Base de datos no esta disponible en este momento.";
>> echo "Disculpe las molestias, intente mas tarde";
>> echo "\n";
>> echo "\n";
>> echo "\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 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 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 wrote:
> On Mon, Dec 15, 2008 at 11:29 AM, 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
>
> Line 32-36 are:
> If (!empty($msg)){
>echo "". $msg ."";
>}
> ?>
>
>
> >
> > --
> > 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 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: ". $msg .""; } ?> > > -- > 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: ". $msg .""; } ?> 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 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 wrote: > From: Jim Lucas > Subject: Re: [PHP] new xampp server problem w/mail > To: linia...@yahoo.com > Cc: "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 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" wrote: >On Mon, Dec 15, 2008 at 9:29 PM, Rob Gould 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 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 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" wrote: On Mon, Dec 15, 2008 at 9:29 PM, Rob Gould 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" 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
