[PHP-DB] 20 Million Fresh E-mail Addresses
TO BE REMOVED FROM FUTURE MAILINGS, SIMPLY REPLY TO THIS MESSAGE AND PUT "REMOVE" IN THE SUBJECT. 20 MILLION E-MAIL ADDRESSES FOR ONLY $249 **Over Night International Shipping Included** Many Call This "The "Perfect E-Mail List" Over 20-Million Of The Best E-Mail Addresses Available _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ _/ Our research has found that many people have tried one or more of the following... Free Classifieds? (Don't work anymore) Web Site? (Takes thousands of visitors) Banners? (Expensive and losing their punch) E-Zine? (Hope they have a *huge* subscriber list) Search Engines? (Forget it, unless you're in the top 20) S O W H A T W I L L W O R K ? Although often misunderstood, there is one method that has proven to succeed time-after-time. E - M A I L M A R K E T I N G ! ! IT'S A FACT... If you're not using your computer to generate income, GOOD income, you're leaving money on the table. Here's what the experts have to say about E-Mail Marketing: "E-mail is an incredible lead generation tool" -Crains Magazine "A gold mine for those who can take advantage of bulk e-mail programs" - The New York Times "Blows away traditional Mailing" - Advertising Age Here's an example of your potential earnings if you have a product or service that brings you a profit of around $30. Remember, on the Internet, you can make money 7 days a week, 24 hours a day... even while you sleep, orders come from all over the world! Orders Per DayWeekly Monthly Yearly 1 $ 210 $ 840 $ 10,080 2 4201,68020,160 3 6302,52030,240 51,0504,20050,400 102,1008,400 100,000 153,150 12,600 151,200 THE QUESTION IS... how do you generate those orders? The least expensive and fastest way is through E-Mail Marketing. You want to make some money? I can put you in touch with over 20 million people at virtually no cost. Can you make one cent from each of theses names? If you can you have a profit of over $200,000.00 That's right, I have over 20 Million Fresh email addresses that I will sell for only $249. These are all fresh addresses that include almost every English person on the Internet today, with no duplications. They are all sorted and ready to be mailed. That is the best deal anywhere today! Don't believe it? People are making that kind of money right now by doing the same thing, that is why you get so much email from people selling you their productit works! These 20 Million email addresses are yours to keep, so you can use them over and over. This offer is not for everyone. If you can not see just how excellent the risk / reward ratio in this offer is then there is nothing I can do for you. To make money you must stop dreaming and TAKE ACTION. Over the past 2 years, we have gained a reputation for having the cleanest, most responsive e-mail address lists in the industry. No one has gone to the work it takes to produce an e-mail address list of this quality. Here's how we prepare our e-mail lists: 1. We clean and eliminate all duplicates. 2. Next, we use a filter list of 400+ words/phrases to clean even more. No address with inappropriate or profane wording survives! 3. Then we use our private database of thousands of known Internet "extremists", those opposed to any kind of commercial e-mail, and kicked off every one we could find. 4. All domains were verified to insure they're valid. 5. And finally, we sorted the list into easy-to-manage packets of 20,000 addresses in simple text (.txt) format that will work with any computer operating system. ** It is time to order! Shipping is not an issue. **FedEx next day world wide shipping included As soon as we receive payment we will FedEx your e-mail list via CD straight to your door anywhere in the world FedEx next day guaranteed. **International Orders Welcome* US funds paid via paypal.com welcomed PayPal is now available in the following countries: Australia Austria Belgium Brazil Canada Denmark France Germany Hong Kong Ireland Israel Italy Japan Mexico Netherlands New Zealand Norway Portugal Singapore South Africa South Korea Spain Sweden Switzerland United Kingdom PayPal.com is very easy to sign up to. They accept wire transfers, checks and credit cards from any of the countries listed above. This payment process is in your own interest of safety. Paypal.com processes all transactions and keeps all your personal information secret. After signing up please send the U.S. equivalent of $249 to [EMAIL PROTECTED] last name Smith. If there is another way you would like to pay please e-mail me at [EMAIL PROTECTED] and I will get back to you. ***Wond
Re: [PHP-DB] pgsql performance
Greetings, Cameron! At 06.02.2001, 14:23, you wrote: C> whilst i know that mysql is generally faster than pgsql i just tried to C> convert another of my mysql projects to pgsql, in mysql the list takes C> about 1 second (SELECT * FROM email LIMIT 0,300 on 18 records), the C> same query in pgsql is taking around 5 seconds, i know i have tweaked C> mysql a little and played with things to make it faster, i was wondering C> if there are any tips to pgsql? i didnt think pgsql was that slow :( if "SELECT * FROM email LIMIT 0,300" is your actual query, I would strongly advise to use an ORDER BY some_indexed_field. This will make Postgres' optimizer use an index scan. Not to mention the fact that LIMIT without an ORDER will return you some random rows from a table... besides, if you are running Postgres with default options, you should increase the amount of memory it allocates for buffers and sorting. By default Postgres is VERY conservative about memory usage. -- Yours, Alexey V. Borzov, Webmaster of RDW -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] array_count_values
Gurus, I am fetching an array from an Oracle database . I get the following warning message for a particular set of results only . -- Warning: Can only count STRING and INTEGER values! in /tmp/myscript.php on line 36 -- The line 36 as mentioned in above warning has array_count_values function used on it . I am running php script as a cron job. Also the resultant html file shows accurate results. Any ideas why and when does this warning comes up???. thanks in advance, ~R -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
AW: [PHP-DB] array_count_values
what is your complete line ? maybe your counting environmental var that is not present in cronjob execution mk -Ursprungliche Nachricht- Von: Rahul Hari Bhide [mailto:[EMAIL PROTECTED]] Gesendet: Dienstag, 6. Februar 2001 12:50 An: [EMAIL PROTECTED] Betreff: [PHP-DB] array_count_values Gurus, I am fetching an array from an Oracle database . I get the following warning message for a particular set of results only . -- Warning: Can only count STRING and INTEGER values! in /tmp/myscript.php on line 36 -- The line 36 as mentioned in above warning has array_count_values function used on it . I am running php script as a cron job. Also the resultant html file shows accurate results. Any ideas why and when does this warning comes up???. thanks in advance, ~R -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] sessions vars problem ....
hi, i need to store the date as $day, $month, $year and then build it into some selectors when a user returns to the page. so they chhose a date and it stays constant as they move around the site. i have a department id that does the same and i've duplicated the code for day, month, year etc and it simply doesn't work. it works when i refresh the page but not when i go to another page and then back again. this is the bit that sets the sessions vars whihc is on a page called login2, which deals with the login stuff (strangely enough :-) session_register("cday"); session_register("cmonth"); session_register("cyear"); then in the department calendar i have if (isset($cday)) { $day = intval($cday); } if (isset($cmonth)) { $month = intval($cmonth); } if (isset($cyear)) { $year = intval($cyear); } // date option drop downs if ( (!checkdate($month, $day, $year)) || (isset($today)) ) { print "if !checkdate fired"; $nowArray = getdate(); $cday = $nowArray[mday]; $cmonth = $nowArray[mon]; $cyear = $nowArray[year]; unset($today); } $start = mktime (0, 0, 0, $cmonth, $cday, $cyear ); // date used in adding date lines $start2 = mktime (0, 0, 0, $cmonth, $cday, $cyear ); $firstDayArray = getdate ($start); echo ''; for ($x=1; $x<=31; $x++) { if (checkdate($cmonth, $x, $cyear)) // add if valid day number for month { print "".$x; } } print ""; echo ''; $months = Array("January", "February", "March", "April", "May", "June", "July", "August", "September", "October", "November", "December"); for ($x=1; $x <= count($months); $x++) { print "\t".$months[$x-1]."\n"; } echo ' '; echo ''; for ($x=1998; $x<2004; $x++) { print "\t$x\n"; } echo ' '; echo ''; echo ''; --- sorry abouyt the log paste ... ok. this is what happens. when the user clicks today the date is set to todays. this works. when they choose a day, month or year the form refreshes and shows the correct calendar info. this works. when they go to another page and then back again, the calendar defaults back to todays date. i need the date to be the same as it was when they left the page. i've been staring at it for 2 hours now ... tia, Steve Brett Internal Development EMIS Ltd. "Privileged and /or Confidential information may be contained in this message. If you are not the original addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone. In such case, please delete this message, and notify us immediately. Opinions, conclusions and other information expressed in this message are not given or endorsed by my firm or employer unless otherwise indicated by an authorised representative independently of this message." Egton Medical Information Systems Limited. Registered in England. No 2117205. Registered Office: Park House Mews, 77 Back Lane, Off Broadway, Horsforth, Leeds, LS18 4RF -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] duplicate entries in mysql column
Hello, Pascal Romain! You wrote: Apply a UNIQUE constraint on candidate_name column -- Piloteers do it on the road -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] Record Size
"select uid, sum (length (message)) from user_messages where uid = $uid" p.s. pardon me if length function should be strlen -- Piloteers do it on the road -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] arrays
Hello, "Alarion"! You wrote: > I want to loop through a result set, say with ODBC, and > use the > "fetch_array" function for each row. Now, What I want is > a an array of all > the rows, so I could then access the "Name" column in Row > 5 like > $values[NAME][5]. > How would I create an array that way? With Oracle use OCIFetchStatement() function -- Piloteers do it on the road -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] Pbs with Oracle
Hello, dsi safir! You wrote: > Any suggestion is welcome... > You don't have enough rights... -- Piloteers do it on the road -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Writing to a file on the user's machine.
How do I write to a file on the user's machine? I need to drop a small file to the user's machine after a certain transaction. Thanks in advance! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] arrays
lol, yeah i did that allready. I was talking about ODBC since it doesn't have a "fetch_statement" function. I got it working though. I noticed that after using OCIFetchStatement() though, you can no longer access OCIColumnName(), it will return a blank value. So if you want to access column names after calling OCIFetchStatement, you will need to load the column names into an array beforehand. Thanks, Sean -Original Message- From: Stas Trefilov [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, February 06, 2001 12:00 AM To: [EMAIL PROTECTED] Subject:Re: [PHP-DB] arrays Hello, "Alarion"! You wrote: > I want to loop through a result set, say with ODBC, and > use the > "fetch_array" function for each row. Now, What I want is > a an array of all > the rows, so I could then access the "Name" column in Row > 5 like > $values[NAME][5]. > How would I create an array that way? With Oracle use OCIFetchStatement() function -- Piloteers do it on the road -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] pgsql performance
I have no personal experience with pgsql... but I've heard from friends and in a number of articles strong suggestions to upgrade to pgsql 7.0. It is noticably faster. Also I believe the Postgres docs have a section on performance tuning. Mark On Tue, 6 Feb 2001, Cameron wrote: > whilst i know that mysql is generally faster than pgsql i just tried to > convert another of my mysql projects to pgsql, in mysql the list takes > about 1 second (SELECT * FROM email LIMIT 0,300 on 18 records), the > same query in pgsql is taking around 5 seconds, i know i have tweaked > mysql a little and played with things to make it faster, i was wondering > if there are any tips to pgsql? i didnt think pgsql was that slow :( > > Cameron > > > -- "The greatest dangers to liberty lurk in insidious enroachment by mean of zeal, well-meaning but without understanding." -- Justice Louis O. Brandeis, Olmstead vs. United States -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Problem using MySql with PHP4
Hi.. i'm using MySql version 3.22.32 and I installed the Apache Compile Kit containing the following: Apache 1.3.14 php3 3.0.16 php4 4.0.3pl1 I have the following problem while using PHP4.. Wheneven I write to the database, I see the following warning on the resultant page on the browser : "Warning: MySQL: Unable to save result set in /home/httpd/php/tests/datatest.php on line 19 ". While executing the same code over PHP3, it executes very smoothly! I need to know where I go wrong! Please help me on this matter.. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] MySQL strangeness with joins and keys.
Hi all, This might be a bit OT but i'll ask anyway. I'm currently working on a project that involves using a database that contains about 1.8 million rows and am currently in the process of trying to get it to search as quick as posable. I've been using the explain keyword to try to see how mysql is handling the query and i am seeing some strange things. The query that i am currently using is: explain select RECORDING.RNO as rno, TRACK.TRA as track, ARTIST.ART as artist, RECORDING.REC as title, RECORDING.MUSIC as style, MEDIA.MEDIUM as medium from TRACK left join ARTIST use index (ano_art_index) on TRACK.ANO=ARTIST.ANO left join RECORDING use index (rno_rec_music_index) on TRACK.RNO=RECORDING.RNO left join MEDIA use index (rno_lno_medium_index) on RECORDING.RNO=MEDIA.RNO where TRACK.TRA like '%war pigs%' limit 0,5; which returns the following in the mysql client: +---+---+--... | table | type | possible_keys +---+---+--... | TRACK | index | NULL | ARTIST| ref | ano_index,ano_art_index | RECORDING | ref | rno_index,rno_rec_music_index | MEDIA | ref | rno_index,rno_lno_index,rno_lno_medium_index +---+---+--... ...+--+-+---+-... | key | key_len | ref | rows ...+--+-+---+-... | tra_rno_ano_index| 68 | NULL | 1775059 | ano_art_index| 4 | TRACK.ANO |1500 | rno_rec_music_index | 4 | TRACK.RNO |3458 | rno_lno_medium_index | 5 | RECORDING.RNO |5225 ...+--+-+---+-... ...+-+ | Extra | ...+-+ | where used; Using index | | Using index | | Using index | | Using index | ...+-+ Now what i don't understand is why Mysql is saying that there is no (NULL) keys available for table TRACK yet it does use the key 'tra_rno_ano_index' and it only looks in the index for the results (Using index). Also when searching using the query above it will take about 3 min to perform the search but if i change the line TRACK.TRA like '%war pigs%' to TRACK.TRA like '%what if%' the search will take anywhere from 0.5 - 6 seconds. Anybody have any idea why this is happening and how i can get a constant, and hopefully quick, speed across a number of different searches? If its any help im currently running MySQL 3.23.31 for freeBSD 4.2 Thanks, William. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] faq
[PHP-DB] passing object elements in urls
Greetings, Got a slight problem. I'm attempting to pass a number of variables from one form to another. The problem occurs when one of the object elements contains more than one word. Program The URL shows ...&name=Arizona State University but when I have the next form print the variable $name it only prints out Arizona and stops. Other than this everything works fine. I've tried single and double quotes in various places around the php expression but nothing is working to get the second form to print the entire object element. Any idea how to pass object elements with spaces in a URL? Thanks. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] passing object elements in urls
> Got a slight problem. I'm attempting to pass a number of variables from > one form to another. The problem occurs when one of the object elements > contains more than one word. [snip] > Any idea how to pass object elements with spaces in a URL? Try encoding the spaces as %20 (the hex value for a space). There's probably a PHP function to do this for you (and one to do the reverse) -- I haven't looked. You could try using a + instead of a space too. - Darryl -- Darryl Friesen, B.Sc., Programmer/Analyst[EMAIL PROTECTED] Education & Research Technology Services, http://gollum.usask.ca/ Department of Computing Services, University of Saskatchewan -- "Go not to the Elves for counsel, for they will say both no and yes" -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] installing
Hello, Got a major problem with seeing the result of my php scripts without uploading them to a server. I don't have a server myself. Do I need to have one or can I see my writen scripts and see the results directly in my internet explorer? thanks, ufo
Re: [PHP-DB] passing object elements in urls
On Tue, Feb 06, 2001 at 05:46:25PM +, Darryl Friesen wrote: > > Got a slight problem. I'm attempting to pass a number of variables from > > one form to another. The problem occurs when one of the object elements > > contains more than one word. > > [snip] > > > > Any idea how to pass object elements with spaces in a URL? > > Try encoding the spaces as %20 (the hex value for a space). There's > probably a PHP function to do this for you (and one to do the reverse) -- I > haven't looked. Yes there are: urlencode() and urldecode() http://www.php.net/manual/en/function.urlencode.php http://www.php.net/manual/en/function.urldecode.php Paul > > You could try using a + instead of a space too. > > > - Darryl > > -- > Darryl Friesen, B.Sc., Programmer/Analyst[EMAIL PROTECTED] > Education & Research Technology Services, http://gollum.usask.ca/ > Department of Computing Services, > University of Saskatchewan > -- > "Go not to the Elves for counsel, for they will say both no and yes" > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] -- - Paul Cooper | Tel: 0121 331 7858 Senior Programmer and Database Engineer | Fax: 0121 687 7859 UCEcom | mailto:[EMAIL PROTECTED] University of Central England | http://www.ucecom.com Birmingham, B4 7DX | - -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] installing
If I understand your question correctly, you are asking why you need to upload your php scripts to a server and why can't you see the result on your workstation without the upload? Easy. PHP is a server driven interpreter. You must have the PHP executables installed either on the server or your local workstation. If you go http:\\www.php.net, you will find a win32 installation section. You will also need to have Personal Web Server installed on your workstation. Internet Explorer is not setup to run php by itself. It needs a webserver to do it. If you don't want to use Micrsofts Personal Web Server, you can download the win32 version of Apache at www.apache.org. -Original Message- From: peter paauwe <[EMAIL PROTECTED]> To: php maillijst <[EMAIL PROTECTED]> Date: Tuesday, February 06, 2001 1:38 PM Subject: [PHP-DB] installing Hello, Got a major problem with seeing the result of my php scripts without uploading them to a server. I don't have a server myself. Do I need to have one or can I see my writen scripts and see the results directly in my internet explorer? thanks, ufo -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] installing
> You > will also need to have Personal Web Server installed on your workstation. > Internet Explorer is not setup to run php by itself. It needs a webserver > to do it. > > If you don't want to use Micrsofts Personal Web Server, you can download the > win32 version of Apache at www.apache.org. I wouldn't bother with PWS. Apache or Xitami (www.xitami.com) are far easier to setup. I've installed PHP under both, with no problems. - Darryl -- Darryl Friesen, B.Sc., Programmer/Analyst[EMAIL PROTECTED] Education & Research Technology Services, http://gollum.usask.ca/ Department of Computing Services, University of Saskatchewan -- "Go not to the Elves for counsel, for they will say both no and yes" -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] installing php under apache
How do I installe the zip-module op php4 under the apache windows module? thank you, ufo
RE: [PHP-DB] PHP, MySQL and XML
http://freshmeat.net/projects/exist/ -Original Message- From: Thor M. Steindorsson [mailto:[EMAIL PROTECTED]] Sent: Monday, February 05, 2001 5:57 PM To: php-general; php-db Subject: [PHP-DB] PHP, MySQL and XML Does anyone have a solution for importing data from a RDF-XML file into a MySQL database? I've been racking my brain, as well as looking at tutorials and some xml parsers, but if someone has something like this it would save me tons of time. Thanks! -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] redirection based on login username
*PHP is supported but there is no mySQL access on this host [not sure what the point is... maybe I should just tell them to switch hosts...] I am looking to see if i can connect to a freeservers sql DB [www.f2s.com] *It will be for agents who are logging in, depending on their assigned username they should be directed to THEIR pricing schedule, currently there are three different price schemes *I would like it to be expandable from the current [a new company, they are looking to grow fairly large... naturally] MY THOUGHTS *I only know how to do DB based authentication, so the agent may have to login TWICE [one for PHP redirect, another for apache protected dir. *Cookies might be the best way to go, (agent logs in to a gateway page that reads the cookie value and directs to according page) I don't like this cuz where does the cookie initially get set [give them each a disk with THEIR cookie on it?] *agent ID's could be assigned like this AGENT001 AGENT101 AGENT202 Then the script could direct to up to [10 price schedules, by using AGENT0, AGENT1, AGENT2, get it?] or [100 price schedules, if you extended to the second number AGENT01, AGENT02, AGENT10, AGENT11] etc. each could theoretically have unlimited agents. Just keep adding numbers after the "base" ID So, anyone have any ideas to go about this, I don't think that I can use a DB, unless maybe it was a flat text file... [never worked with those before:)] Thanks Much olinux _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] redirection based on login username
Duh, of course switch hosts. Is this just for some cheesey operation, or is it a serious application. If this is suppose to be serious, then splurge the $10/month for a host with php/mysql. Or, use a DB remotely. As far as redirection you don't need to redirect, or use some crazy authentication scheme. All you do is have them go to myaccounts.php. It has a login and password. Query the DB, see if it matches. If it does pass it to the query statement--> SELECT * FROM $agentlogin; And for the different schemes on prices... its not hard to add a coulumn that defines the scheme. Anyways, in a nutshell, get a real host. Use PHP based authorization. Don't do redirects, just query the DB based on the login name. If you there's more than one part/page to the application you can use sessions or set a cookie. No, you do not need to put a cookie on a disk, you set it in the browser when you access the page. -Original Message- From: olinux [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 06, 2001 10:35 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] redirection based on login username *PHP is supported but there is no mySQL access on this host [not sure what the point is... maybe I should just tell them to switch hosts...] I am looking to see if i can connect to a freeservers sql DB [www.f2s.com] *It will be for agents who are logging in, depending on their assigned username they should be directed to THEIR pricing schedule, currently there are three different price schemes *I would like it to be expandable from the current [a new company, they are looking to grow fairly large... naturally] MY THOUGHTS *I only know how to do DB based authentication, so the agent may have to login TWICE [one for PHP redirect, another for apache protected dir. *Cookies might be the best way to go, (agent logs in to a gateway page that reads the cookie value and directs to according page) I don't like this cuz where does the cookie initially get set [give them each a disk with THEIR cookie on it?] *agent ID's could be assigned like this AGENT001 AGENT101 AGENT202 Then the script could direct to up to [10 price schedules, by using AGENT0, AGENT1, AGENT2, get it?] or [100 price schedules, if you extended to the second number AGENT01, AGENT02, AGENT10, AGENT11] etc. each could theoretically have unlimited agents. Just keep adding numbers after the "base" ID So, anyone have any ideas to go about this, I don't think that I can use a DB, unless maybe it was a flat text file... [never worked with those before:)] Thanks Much olinux _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP-DB] Something Stupid
I have got to be doien something stupid. consider the following code. hosts, usernames and passwords have been changed to protect the innocent. \n"); } ?> I get no output and no errors. I use code almost identical to this all over the place, yet this one doesn;t work. I've tried just a bare qery and I still get nothing. the connection is working as we can see from the log entry below. At this point, I'm lost. If the technique I'm using is considered bad practice, I'm open to suggestions. My code would normally print out a table, but for the sake of trouble shooting, I reduced it to this which should print a single column of numbers. Anyone have any ideas? the mysqld.log records the query. 010206 22:59:55 310 Connect[EMAIL PROTECTED] on 310 Init DBtopten 310 Query select car_no, drv_name from cars order by car_no + 0 310 Quit
Re: [PHP-DB] Something Stupid
> $mysql_link = mysql_connect("myhost.domain.com","some.user","some.password " you are missing a ); > while($rows = mysql_fetch_array($myresult)); there is a ; that is not needed -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
Re: [PHP-DB] installing
Hey I would say go with Linux and Apache with PHP 4.0 and MySQL. The best combination...Ive been using it for a while and its great even tho im just a newbie >From: "Darryl Friesen" <[EMAIL PROTECTED]> >To: "php maillijst" <[EMAIL PROTECTED]> >Subject: Re: [PHP-DB] installing >Date: Tue, 6 Feb 2001 13:49:51 -0600 > > > You > > will also need to have Personal Web Server installed on your >workstation. > > Internet Explorer is not setup to run php by itself. It needs a >webserver > > to do it. > > > > If you don't want to use Micrsofts Personal Web Server, you can download >the > > win32 version of Apache at www.apache.org. > >I wouldn't bother with PWS. Apache or Xitami (www.xitami.com) are far >easier to setup. I've installed PHP under both, with no problems. > > >- Darryl > > -- > Darryl Friesen, B.Sc., Programmer/Analyst[EMAIL PROTECTED] > Education & Research Technology Services, http://gollum.usask.ca/ > Department of Computing Services, > University of Saskatchewan > -- > "Go not to the Elves for counsel, for they will say both no and yes" > > > >-- >PHP Database Mailing List (http://www.php.net/) >To unsubscribe, e-mail: [EMAIL PROTECTED] >For additional commands, e-mail: [EMAIL PROTECTED] >To contact the list administrators, e-mail: [EMAIL PROTECTED] > _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP-DB] Something Stupid
drop the ; from the while. it is not parsing anything within the scope of the while loop because there is a ; saying the while loop ends w/o doing anything. -Original Message- From: Curtis Maurand [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 06, 2001 9:39 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] Something Stupid I have got to be doien something stupid. consider the following code. hosts, usernames and passwords have been changed to protect the innocent. \n"); } ?> I get no output and no errors. I use code almost identical to this all over the place, yet this one doesn;t work. I've tried just a bare qery and I still get nothing. the connection is working as we can see from the log entry below. At this point, I'm lost. If the technique I'm using is considered bad practice, I'm open to suggestions. My code would normally print out a table, but for the sake of trouble shooting, I reduced it to this which should print a single column of numbers. Anyone have any ideas? the mysqld.log records the query. 010206 22:59:55 310 Connect[EMAIL PROTECTED] on 310 Init DBtopten 310 Query select car_no, drv_name from cars order by car_no + 0 310 Quit -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]