[PHP]dtabase problem
there is a problem in mysql database.there r two tables.one table is named as transactions and the other is named as the code.the transactions table has got the 12 fields which r the following 1.clientid int 2.date date 3.isinno text 4.debit int 5.credit int 6.desc text 7.dpid1 text 8.nsdlid int 9. desc1 text 10. desc2 text 11. dpid bigint 12.transno int All these fields r by default NULL the code table has got the 8 fields which r the following 1.rd smallint 2.transno int 3.status tinyint 4.status1 tinyint 5.cdate date 6.clientid int 7. isinno text 8.description text . All these fields r by default NULL I am writing this query but its not giving the recquired results i.e i want it should pick up the all the fields of both the tables without any duplicate enteries. SELECT * from transactions,holdings,code where transactions.clientid=holdings.clientid and transactions.isinno=code.isinno and transactions.isinno=' INE561A01013' and transactions.transno='4509'AND FROM_DAYS(transactions.date) - TO_DAYS(holdings.hdate) group by transactions.credit,code.description Basically the problem with the above query is that its giving the duplicate enteries . plz. solve my problem at the earliest.its very urgent. = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do you Yahoo!? New DSL Internet Access from SBC Yahoo! http://sbc.yahoo.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Calling info from mySQL inside flash
THANKS A TON!!! --- Brad Bonkoski [EMAIL PROTECTED] wrote: How about giving this page a look over: http://www.macromedia.com/desdev/topics/php.html Here's an article especially for using PHP and MySQL with Flash MX http://www.macromedia.com/desdev/mx/flash/articles/flashmx_php.html HTH -Brad Thomas Edison Jr. wrote: I have a mySQL db, and a bunch of tables in it. What i want to do, is to pick up some data, and display in my Flash Movie. For example. I have a table with a list. Now on my main page, i display the total number of people in the list so far (By counting the rows). Now i want to display the same in my Flash movie. How can we exactly insert PHP Coding inside Flash Movie to make the code work? Any tips... Thanks, T. Edison Jr. __ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.yahoo.com -- 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 = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.yahoo.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Calling info from mySQL inside flash
I have a mySQL db, and a bunch of tables in it. What i want to do, is to pick up some data, and display in my Flash Movie. For example. I have a table with a list. Now on my main page, i display the total number of people in the list so far (By counting the rows). Now i want to display the same in my Flash movie. How can we exactly insert PHP Coding inside Flash Movie to make the code work? Any tips... Thanks, T. Edison Jr. __ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.yahoo.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Need a Web Host for php/mySQl
Glory, I'm looking for a new Web Hosting company, to host my sites. I had been with Aletia, but i'm experiencing some technical flaws with them, so i need a new one. Aletia is very economical, with $7.95 a month for 200 MB, 10 GB Bandwidth, sub-domains, dbs, and a hell a lot of goodies. so i would prefer someone like them or better then them. I'd really appreciate if someone can find me a better Host. Thanks, T. Edison Jr. __ Do You Yahoo!? HotJobs - Search Thousands of New Jobs http://www.hotjobs.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] PROBLEM
hi! i have a problem in my project.the problem is that suppose we have the date for the whole of the month and two different files r there. i have to pick one file of the current date that is say today and the other file of the yesterday.but the problem is that if the current date is monday then the in yesterday file i have to pick for saturday and not the sunday.broadly speaking i mean to say that the difference between the today's date and yesterday's is not fixed as there can be a holiday for say 4 days inbetween then in yesterday i need the date 4 days before. so i need some query to handle this as soon as possible as its very urjent.the query should be in MYSQL.that is the query should be such which can pick today's date and the date of the working day before the today's or the current date. = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Picking up Data of Previous Date from Table
Glory! I have one Table (Transactions), having a Date Column, with date stored as -MM-DD I have another Table (Holdings), having a Date Column, with date stored as -MM-DD Now i'm joining the two tables, to get data from both the tables and display on the page. The query i'm using is something like this : SELECT * FROM transactions,holdings where transactions.isinno=holdings.isinno AND transactions.clientid='$clientid' AND holdings.clbal!=0 GROUP BY holdings.isinno ORDER BY shares This statement works fine, and for any given date, extracts Data from both the tables and displays in a particular row format. I have to also to do some Calculations as i have Debit, Credit Opening Balance of a day, and have to generate the Closing Balance. Now for this purpose i'm facing a simple problem. The Data being picked up is of the same date from both the Tables. However, what is required is that the Data from the Holdings table needs to be picked up from a Date a day earlier then the Transactions Table Data. For eg:- If i'm displaying Transactions Table Data of 2002-06-22, then the Holdings Data should be picked up of date 2002-06-21 !! The thing is that i have Debit Credit in Transactions Table, and the Closing Balance in Holdings Table. The Closing Balance of 21st is the Opening Balance of 22nd. So when i display the Transactions Table for 22nd, Debit Credit of 22nd is Subtracted Added to the Opening Balance of 21st to get the Closing Balance. So this is what i have to do. I need to pick up the Opening Balance from the Holdings Table of a Date Previous to the Transactions that i'm displaying. How can i do this? Thanks, T. Edison Jr. __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] Stopping Multiple Entries in mySQL DB
Hi, Ok i cant actully do this. I have many multiple entries already in the table which i do not wish to delete. And it won't alter table with these multiple entries. So what i need is a PHP Engineered solution, where my PHP code would check for existing entries and deny entry Thanks, T. Edison Jr. --- John Holmes [EMAIL PROTECTED] wrote: I just want my Adding Into Database script to check if the Name/Country already exists, and if it does, it shouldn't be allowed. If some with Name : Jackson Country : USA exists in my DB, no one with same name/country should be able to add his name/country in the DB. Have your database handle that, not PHP. When you create your table, make the combo of Name and Country unique. CREATE TABLE your_table { Name VARCHAR(15), Country VARCHAR(15), UNIQUE Name_Country (Name, Country) } Then you can have Jackson, USA, Jackson, UK, Someone Else, USA, etc...just not the same combination at all. ---John Holmes... -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Resetting ID
Glory! I have a table, with 4 columns. One of the column is ID, a Primary Key, which has Auto_Increment set on it. Now i have a lot of rows deleted and a lot of duplicate rows that will be deleted, and all sorts of stuff happening in the table.. the result is, that the IDs have become inconsistent. What you get is something like 5,6,9,10,25,32,33 .. and so on. With many IDs missing etc. What i want to do is delete the entire IDs and generate them again so that they are in one single order like 1,2,3,4,5... .like this. And so that any new entry in the table gets the ID accordingly. How can i do this? Thanks, T. Edison Jr. __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Submitting form in new window!
Glory, 2 Problems with this : 1. I have a PHP/MySQL statement within my PHP Code, which is in the Body part of the page. This generates the Form Fields Thier Values.. there are a lot of hidden fields who's values are defined by Database Variables.. If i place the FormSubmit()Function in the head, how will those variables pass? 2. I'm already using Target=_Blank ... problem with that is that you cannot control size of window. And that is exactly what i need to do.. define parameters for the window... Thanks, T. Edison Jr. --- vins [EMAIL PROTECTED] wrote: This is JavaScript you need. one example. FORM NAME=Information INPUT TYPE=text NAME=TextField VALUE=Nothing Here INPUT TYPE=submit NAME=go VALUE= Go! onSubmit=FormSubmit()' /FORM SCRIPT LANGUAGE=JavaScript TYPE=JavaScript/Text function FormSubmit() { var textfield = Information.TextField.value; var url = ./processForm.php?textfield= + textfield; window.open(url); } /SCRIPT OR just add this to your form tag. TARGET=_blank Thomas Edison Jr. [EMAIL PROTECTED] wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... Glory, Attach a javascript event to the submit button Something like : input type=submit name=go onSubmit=wow(); Wherein wow() defines a the window.open function? and also attach the form values to the url. How do i do this? Because the 3 or 4 form fields i have, which are Hidden Fields, contain values coming in from $myrow[stuff], that is, coming in from a Database Table. How do i define these values up in the Javascript function in the head of the file? Thanks, T. Edison Jr. __ Do You Yahoo!? Sign up for SBC Yahoo! Dial - First Month Free http://sbc.yahoo.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Stopping Multiple Entries in mySQL DB
Glory! I just want my Adding Into Database script to check if the Name/Country already exists, and if it does, it shouldn't be allowed. If some with Name : Jackson Country : USA exists in my DB, no one with same name/country should be able to add his name/country in the DB. Can anyone hint? T. Edison Jr. __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] Inserting Processed Data from One Table 2 Another!
Ok ths is great, a lovely Random Code Generator! Thanks a lot. I always wanted one of these. Actually my problem was a little different, but i was able to solve it. I was using $result twice to store to different SQL Queries, i changed the other one to $result2 and it worked. But in fact, i will now change my code to generate the Random Number which of course is much better! Thanks... T. Edison Jr. --- Wouter van Vliet [EMAIL PROTECTED] wrote: I don't see why your code is so wrong but neither do I see what it reall does. YOu are changing the clientID with some simple function into a password? As in everybody can do that trick by himself and login as whoever he wants .. What I'll mostly do for such things, is use this self written function to generate a random string and use this as generated password. it takes an integer as argument, and gives back a random code with only [A-Z][a-z] characters of a length of the given argument. And then, I'd just use the loop to roll through the ID's and insert a random code password. function generateRandomString($length) { srand ((float) microtime() * 100); for ($i=65;$i91;$i++) { $chars[] = chr($i); }; for ($i=97;$i122;$i++) { $chars[] = chr($i); }; $chrs = count($chars) - 1; for ($i=0; $i$length; $i++) { $asc = rand(0, $chrs); $code .= $chars[$asc]; }; return $code; }; $result = mysql_query(SELECT clientid FROM Clientdetails); while ($myrow = mysql_fetch_assoc($result)) { $code = generateRandomString(8); mysql_query(INSERT INTO authentication (id, pass) VALUES ($myrow[clientid], '.$code.'); }; Hope this helped you ! Greetz, Wouter -Oorspronkelijk bericht- Van: Thomas Edison Jr. [mailto:[EMAIL PROTECTED]] Verzonden: woensdag 24 juli 2002 9:02 Aan: [EMAIL PROTECTED] Onderwerp: [PHP] Inserting Processed Data from One Table 2 Another! Ok i have simple issue, i'm stuck at one point. I have a table Clientdetails which contains ClientID. I have created another table Authentication with 2 fields, ClientID and Password. I want to pick up the ClientID from table Clientdetails and insert ClientID and a Password i have generated using a code, into Authentication. So if there are 13000 ClientID's in Clientdetails, as, many rows with the ClientID it's corresponding password should be Inserted into table Authentication. I'm using the following code which i know is wrong, what would be correct? ? $db = mysql_connect(localhost,user,pwd); mysql_select_db(myDB,$db); $result = mysql_query(SELECT * FROM clientdetails,$db); if ($myrow = mysql_fetch_array($result)) { do { $some = $myrow[clientid] $newid = eregi_replace('100', '', $myrow[clientid]); $date = date(dn); $stuff = $newid.def.$date; $sql = INSERT INTO authentication VALUES('$some','$stuff'); $result = mysql_query($sql); echo All Done!; } while ($myrow = mysql_fetch_array($result)); } ? Thanks, T. Edison Jr. __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Inserting Processed Data from One Table 2 Another!
Ok i have simple issue, i'm stuck at one point. I have a table Clientdetails which contains ClientID. I have created another table Authentication with 2 fields, ClientID and Password. I want to pick up the ClientID from table Clientdetails and insert ClientID and a Password i have generated using a code, into Authentication. So if there are 13000 ClientID's in Clientdetails, as, many rows with the ClientID it's corresponding password should be Inserted into table Authentication. I'm using the following code which i know is wrong, what would be correct? ? $db = mysql_connect(localhost,user,pwd); mysql_select_db(myDB,$db); $result = mysql_query(SELECT * FROM clientdetails,$db); if ($myrow = mysql_fetch_array($result)) { do { $some = $myrow[clientid] $newid = eregi_replace('100', '', $myrow[clientid]); $date = date(dn); $stuff = $newid.def.$date; $sql = INSERT INTO authentication VALUES('$some','$stuff'); $result = mysql_query($sql); echo All Done!; } while ($myrow = mysql_fetch_array($result)); } ? Thanks, T. Edison Jr. __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] why my php can not get values from Form?
Simple.. just edit your php.ini file in your windows directory. Search for register_globals .. it will have Off in front of it.. switch it to On T. Edison jr. --- ram friend [EMAIL PROTECTED] wrote: hello, I have just installed apache+php4, but my php can not get values from form? what's wrong? following is the code in php named file welcome.php ?php echo( Welcome to our Web site, $usernm $passwd! ); ? I called it with http://localhost/welcome?username=passwd=bbb i get nothing, what's wrong? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? Yahoo! Autos - Get free new car price quotes http://autos.yahoo.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Importing CSV File : 100000 Rows!
Hi, I have generated a .csv file from a .dat file using a VB program. Now this .csv file needs to be imported into my mySQL Database Table on the internet, using phpMyAdmin. The problem i'm facing is that the file, while uploading, stops somewhere in the middle. The upload just gets stuck. Possible reasons : 1. Number of rows is too large. About 10. Does mySQL Support these many rows? Is yes, is it possible to upload these many rows from a client to a table on the internet using phpMyadmin? 2. Internet connection. Due to the mere size of the file in terms of no. or rows, maybe my internet is not able to send all the data. I dont' know. Now can anyone suggest a possibly solution? Can i break up the file automatically and send or something? Please help.. T. Edison Jr. __ Do You Yahoo!? Yahoo! Autos - Get free new car price quotes http://autos.yahoo.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Importing CSV File : 100000 Rows!
Hi, Basically the problem is that i have to connect from my localhost to my MySQL database on the server/internet. I don't have command prompt access to the internet database... --- Pradeep Dsouza [EMAIL PROTECTED] wrote: there is a way to do it from the prompt I use Windows but the command on Linux is close if the file is called mydata.sql mysql \. C:\mydata.sql Hope this works Pradeep - Original Message - From: Thomas Edison Jr. [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, July 18, 2002 10:50 AM Subject: [PHP] Importing CSV File : 10 Rows! Hi, I have generated a .csv file from a .dat file using a VB program. Now this .csv file needs to be imported into my mySQL Database Table on the internet, using phpMyAdmin. The problem i'm facing is that the file, while uploading, stops somewhere in the middle. The upload just gets stuck. Possible reasons : 1. Number of rows is too large. About 10. Does mySQL Support these many rows? Is yes, is it possible to upload these many rows from a client to a table on the internet using phpMyadmin? 2. Internet connection. Due to the mere size of the file in terms of no. or rows, maybe my internet is not able to send all the data. I dont' know. Now can anyone suggest a possibly solution? Can i break up the file automatically and send or something? Please help.. T. Edison Jr. __ Do You Yahoo!? Yahoo! Autos - Get free new car price quotes http://autos.yahoo.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? Yahoo! Autos - Get free new car price quotes http://autos.yahoo.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Connecting LocalHost Remote mySQL DB
Glory! Let's say i got a bunch of Data in my mySQL Table on my localhost. I need all this Data uploaded on my mySQL on the Server/Internet. Now one way is to use phpMyAdmin, Export the original data on LocalHost to a .CSV file, then use the Server phpMyAdmin to upload the same .CSV file to the table on the server. What could be an alternate, in case we dont' want to use this lengthy procedure. Can i make one page which will do both these things? .OR. Can my PHP page on my server, directly pick up data from my localHost mySQL, and feed it in the mySQL Table on the server? Help needed! Thanks, T. Edison Jr. __ Do You Yahoo!? Yahoo! Autos - Get free new car price quotes http://autos.yahoo.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Connecting LocalHost Remote mySQL DB
Glory! Exactly.. that IS the problem. You see, my mySQL DB on the Server/Internet, on my website.. it DOES NOT allow Remote Host Connection. That's why i need to use a PHP page, that too based on the server. Because i need to move tabel data on my Client/My Computer to the Tables on my Website mySQL. Thanks, T. Edison Jr. --- Jason Wong [EMAIL PROTECTED] wrote: On Saturday 13 July 2002 13:45, Thomas Edison Jr. wrote: Glory! Let's say i got a bunch of Data in my mySQL Table on my localhost. I need all this Data uploaded on my mySQL on the Server/Internet. Now one way is to use phpMyAdmin, Export the original data on LocalHost to a .CSV file, then use the Server phpMyAdmin to upload the same .CSV file to the table on the server. What could be an alternate, in case we dont' want to use this lengthy procedure. Can i make one page which will do both these things? .OR. Can my PHP page on my server, directly pick up data from my localHost mySQL, and feed it in the mySQL Table on the server? If all you want is to copy data from ServerA/Database/Table to ServerB/Database/Table you don't even need PHP. Providing that at least one of the server allows remote access then the easiest way is to use mysqldump. For details consult mysql manual. -- Jason Wong - Gremlins Associates - www.gremlins.com.hk Open Source Software Systems Integrators * Web Design Hosting * Internet Intranet Applications Development * /* Love is in the offing. -- The Homicidal Maniac */ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? Yahoo! Autos - Get free new car price quotes http://autos.yahoo.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Submitting form in new window!
Hi, When i press the Submit button, i would like it to open in a new Javascript Windows with well-defined characteristics like size, width etc. I create a window.open function and gave the name of my PHP page .. but the Form Variables are not passing into it.. Thanks, T. Edison Jr. = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? Sign up for SBC Yahoo! Dial - First Month Free http://sbc.yahoo.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Sending data in table, multiple rows, via mail()
Hi, Ok i have a bunch of rows in my table, with some data. I want my mail() function to be able to pick up the data from the rows and send to a specified email. Basicall let's say there are 3 fields, and 3 rows, the data sent in email should be something like : row1field1 : dkjhdkj row1field2 : dsjdkj row1field3 : skljskj row2field1 : dkjhdkj row2field2 : dsjdkj row2field3 : skljskj And so on, apart from the other mail info. Can anyone help me out with this... Thanks, T. Edison Jr. __ Do You Yahoo!? Sign up for SBC Yahoo! Dial - First Month Free http://sbc.yahoo.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Sending data in table, multiple rows, via mail()
Thank you for your *extreme* kindness... I do not know where to begin to make this happen. I created a variable and ran the entire do while loop to read contents of the table and tried storing them in the variable, which could be used as Content of the mail. However, i just get the Last Row in my DB Table sent in mail.. not all the rows. Following is part of the code i'm using, and it could be absolutely wrong, but that's all i know.. ? $db = mysql_connect(localhost,user, pwd); mysql_select_db(tbl,$db); $result = mysql_query(SELECT * FROM cart where sid='$s',$db); $realcontent= if ($myrow = mysql_fetch_array($result)) { do { $myrow[pid]br $myrow[nm]br $myrow[q]br } while ($myrow = mysql_fetch_array($result)); } ; $to = [EMAIL PROTECTED]; $subject = Purchase order Website; $from = Purchase Order; $stuff = Name : $name\n Phone : $phone\n Fax : $fax\n Email : $email\n Address : $address\n Country : $country\n Order:\n\n $realcontent\n\n; mail($to,$subject,$stuff,$from); ? __ Do You Yahoo!? Sign up for SBC Yahoo! Dial - First Month Free http://sbc.yahoo.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Submitting form in new window!
Hi, Ok, let me show some code : form name=\drama\ action=\add2cart.php\ method=post target=\blank\ input type=hidden name=sessid value= $PHPSESSID input type=hidden name=proid value= $result[vProID] input type=hidden name=proname value= $result[vProName] font color=#00 face=verdana size=2Quantity input type=\text\ size=3 name=\qty\ input type=\submit\ value=\Add To Cart\/font This is the SUBMIT button that submits the form alongwith the Form Variables to a file called Add2Cart.php !! But this file simply opens in an unadministered new window. i would like to use the window.open function, or whatever can accomplish this, to restrict parameters of the window in which add2cart.php opens, at the same time the variables of my form should get submitted into the add2cart.php T. Edison Jr. __ Do You Yahoo!? Sign up for SBC Yahoo! Dial - First Month Free http://sbc.yahoo.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] Sending data in table, multiple rows, via mail()
Hi, WOW... THANKS A LOT!! This actually did it .. i was on a slight wrong track.. $realcontent = ; while ($myrow = mysql_fetch_array($result)) { $realcontent .= $myrow['pid']br; $realcontent .= $myrow['nm']br; $realcontent .= $myrow['q']br; } Thanks, T. Edison Jr. __ Do You Yahoo!? Sign up for SBC Yahoo! Dial - First Month Free http://sbc.yahoo.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Commit/Roll Back Transaction in PHP/mySQL
Glory! Im creating a .php file that will be uploading putting in data from a .csv file into mySQL Tables on the server. However, my problem is that if there is any kind of a problem during the transaction, i.e, system shut down, electricity problem, or any reason why the transaction is interrupted, i would like the transaction to roll back.. that is, all the records entered before the interruption SHOULD NOT remain in the database, they should get deleted or something, so that the transaction can begin Fresh from next time. How can i make such a function that will see this happens, in my PHP/mySQL. Thanks, T. Edison Jr. __ Do You Yahoo!? Sign up for SBC Yahoo! Dial - First Month Free http://sbc.yahoo.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Exporting mySQL Table Data to .csv
Glory, I use phpMyAdmin which enables me to take dump of mySQL Table Data into Comma Seperated Values file (.csv) Now, i have to create such a program that accomplishes this, without using phpMyAdmin. Can someone guide me to this procedure.. Thanks, T. Edison Jr. __ Do You Yahoo!? Sign up for SBC Yahoo! Dial - First Month Free http://sbc.yahoo.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Submitting form in new window!
Glory, Attach a javascript event to the submit button Something like : input type=submit name=go onSubmit=wow(); Wherein wow() defines a the window.open function? and also attach the form values to the url. How do i do this? Because the 3 or 4 form fields i have, which are Hidden Fields, contain values coming in from $myrow[stuff], that is, coming in from a Database Table. How do i define these values up in the Javascript function in the head of the file? Thanks, T. Edison Jr. __ Do You Yahoo!? Sign up for SBC Yahoo! Dial - First Month Free http://sbc.yahoo.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Software on web Accessing mySQL/PHP
Hi, Basically we have created a Software in Visual Basic. Now the software uses mySQL on the internet as Backend. However, our server does not allow Remote Host Connection, which means we cannot access our mySQL Database on the Internet by our Software on a local client. We need the mySQL Database on the Internet because basically everything will be available on a website later through PHP Pages. Now, my problem is how to connect to my mySQL DB on the Internet, via my Software, when my Server Company doesn't allow Remote Host Connection to mySQL. What is suggested to me is to place the Software on the Internet. I have no clue how to do that. Because if i place an .exe file on the net, it will just start downloading instead of running. How then can i accomplish this? The software feeds in Data in the mySQL DB on the internet, and then the PHP pages access the mySQL DB to show data to users on the Website. It's something like that. The software involves a lot of processing, decryption, conversion etc. to convert a .dat data into usable mySQL Tables Data. Hope somebody can help. Thanks, T. Edison Jr. __ Do You Yahoo!? Sign up for SBC Yahoo! Dial - First Month Free http://sbc.yahoo.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] PHP not working on Apache at XP Pro.
Glory! I've got Windows XP Pro OS. I installed and am running mySQL on that. However, PHP is not getting configured with Apache on it. I got the latest Apache, 1.3.24 or something, not the Version 2. Anyway, Apache runs perfectly on it. However, when i put in the required PHP lines in httpd.conf and install PHP otherwise on the system. What happens is that i get an error stating that : mod_c.php already exists, skipping Now when i remove that line, PHP does not work with Apache. If i insert that line, APACHE itself doesn't work at all. What is wrong with it? Well thanks, T. Edison Jr. = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Apache 2.0 or 1.3 for php on windows XP ?
Glory! I have Windows XP Home Edition.. and i downloaded the latest PHP mySQL. I have Apache 1.3.19 earlier, which for some reason gives Service Apache Not Installed now even when everything is installed, on my windows XP. So i decided to get a new Apache Web Server. They have 2 versions available.. 2.0 1.3 .. i just want to know which one i should use, and if PHP is compatible with both.. and that if i do use 2.0, the Install Doc in PHP has given no instructions on how to install php on Apache 2.0, so how will i install it.. Any suggestions most welcome.. T. Edison Jr. = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Apache 2.0 or 1.3 for php on windows XP ?
Ok... i'll go for 1.3.24 Thanks, T. Edison Jr. --- R'twick Niceorgaw [EMAIL PROTECTED] wrote: use apache 1.3.24.. php has experimental support for apache 2.0.x.. so don't trust it much - Original Message - From: Thomas Edison Jr. [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, June 10, 2002 2:49 PM Subject: [PHP] Apache 2.0 or 1.3 for php on windows XP ? Glory! I have Windows XP Home Edition.. and i downloaded the latest PHP mySQL. I have Apache 1.3.19 earlier, which for some reason gives Service Apache Not Installed now even when everything is installed, on my windows XP. So i decided to get a new Apache Web Server. They have 2 versions available.. 2.0 1.3 .. i just want to know which one i should use, and if PHP is compatible with both.. and that if i do use 2.0, the Install Doc in PHP has given no instructions on how to install php on Apache 2.0, so how will i install it.. Any suggestions most welcome.. T. Edison Jr. = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Uploaded File OverWriting Old File
Hi, If i have a filename room.jpg in my Upload Directory, and someone else comes and uploads a file by the same name, the previous room.jpg is overwritten by the new one. Any suggestions? This is the code i'm using : ?php $db = mysql_connect(localhost,user,pwd); mysql_select_db(dbname,$db); if ($img1_name != ) { $pic = yes; } else { $pic = no; } $date = date(l dS of F Y h:i:s A); // if $img_name isn't empty, try to copy the file if (($img1_name != ) and ($img1_size = 256000) and ($img1_type == image/pjpeg) or ($img1_type == image/jpeg)) { $sql = INSERT INTO tablename (name,age,gender,country,email,date,profile,looking,pic_name,pic) VALUES ('$name','$age','$gender','$country','$email','$date','$profile','$looking','$img1_name','$pic'); $result = mysql_query($sql) or die(You made a mistake, please go back and try again); copy($img1, mjpalpics/$img1_name) or Die (Could not do); } ? Thank you for adding you details. The following has been added to the Database :brbr big ?php $profile = stripslashes($profile); $looking = stripslashes($looking); echo ( Name : $namebr Age : $agebr Gender : $genderbr Country : $countrybr Email : $emailbr Your Profile : $profilebr You are looking for : $lookingbr ); if (($img1_size = 256000) and ($img1_type == image/pjpeg) or ($img1_type == image/jpeg)) { echo Your Photo : iName - $img1_name | Size - $img1_size | MIME Type - $img1_type/i br ; } else { echo No photograph uploaded, or wrong Type/Size photograph; } ? Thanks a LOT! T. Edison jr. = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] File Type not working in Uploaded File
Hi, Ok there were a lot of mistakes in that code. IN fact i rubbed it off completely and am using a new code.. Everything works fine now, except that if the filename exists, any new file with the same name overwrites the old file.. What do i do about it? Here is the code i'm using : ?php $db = mysql_connect(localhost,user,pwd); mysql_select_db(dbname,$db); if ($img1_name != ) { $pic = yes; } else { $pic = no; } $date = date(l dS of F Y h:i:s A); // if $img_name isn't empty, try to copy the file if (($img1_name != ) and ($img1_size = 256000) and ($img1_type == image/pjpeg) or ($img1_type == image/jpeg)) { $sql = INSERT INTO mjpals (name,age,gender,country,email,date,profile,looking,pic_name,pic) VALUES ('$name','$age','$gender','$country','$email','$date','$profile','$looking','$img1_name','$pic'); $result = mysql_query($sql) or die(You made a mistake, please go back and try again); copy($img1, mjpalpics/$img1_name) or Die (Could not do); } ? Thank you for adding you details. The following has been added to the Database :brbr big ?php $profile = stripslashes($profile); $looking = stripslashes($looking); echo ( Name : $namebr Age : $agebr Gender : $genderbr Country : $countrybr Email : $emailbr Your Profile : $profilebr You are looking for : $lookingbr ); if (($img1_size = 256000) and ($img1_type == image/pjpeg) or ($img1_type == image/jpeg)) { echo Your Photo : iName - $img1_name | Size - $img1_size | MIME Type - $img1_type/i br ; } else { echo No photograph uploaded, or wrong Type/Size photograph; } ? = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Uploaded File OverWriting Old File
Hmm... Tried it, and this doesn't sound too good : Fatal error: Call to undefined function: file_exist() in d:\apache group\apache\htdocs\mjimm\mjpals_added.php on line 37 Basically this is what i added in the appropriate place : if(file_exist($img1_name)) { $img1_name = $img1_name+n; } And thanks a lot.. Thus Spake T. Edison Jr. !! --- Nick Wilson [EMAIL PROTECTED] wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 * and then Thomas Edison Jr. declared Hi, If i have a filename room.jpg in my Upload Directory, and someone else comes and uploads a file by the same name, the previous room.jpg is overwritten by the new one. Any suggestions? Well, I presume that you would like for this *not* to happen right? if so, just add a if(file_exist($img)) { change name of img. I expect you could add an 1 to the end or better still, have the user choose another name? - -- Nick Wilson // www.explodingnet.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.6 (GNU/Linux) iD8DBQE83PEnHpvrrTa6L5oRApJlAJ9n3/jsPvej8U1DwjDQnED7wwp4FQCgjjGh SO2IqQydOwy9zA0Q7TCd9no= =xxgQ -END PGP SIGNATURE- -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Uploaded File OverWriting Old File
Glory Power! I'm using the following code now... the Error is gone, but it's still overwriting the old file. It's not changing the name.. not doing anything, just uploading this new file and replacing the old one.. ?php $db = mysql_connect(localhost,use,pwd); mysql_select_db(dbname,$db); if ($img1_name != ) { $pic = yes; } else { $pic = no; } $date = date(l dS of F Y h:i:s A); // if $img_name isn't empty, try to copy the file if (($img1_name != ) and ($img1_size = 256000) and ($img1_type == image/pjpeg) or ($img1_type == image/jpeg)) { if(file_exists($img1_name)) { $img1_name = n+$img1_name; } $sql = INSERT INTO mjpals (name,age,gender,country,email,date,profile,looking,pic_name,pic) VALUES ('$name','$age','$gender','$country','$email','$date','$profile','$looking','$img1_name','$pic'); $result = mysql_query($sql) or die(You made a mistake, please go back and try again); copy($img1, mjpalpics/$img1_name) or Die (Could not do); } elseif (($img1_name == ) and ($img1_size 256000) and ($img1_type != image/pjpeg) or ($img1_type != image/jpeg)) { $sql = INSERT INTO mjpals (name,age,gender,country,email,date,profile,looking,pic_name,pic) VALUES ('$name','$age','$gender','$country','$email','$date','$profile','$looking','','no'); $result = mysql_query($sql) or die(You made a mistake, please go back and try again); } ? Thank you for adding you details. The following has been added to the Database :brbr big ?php $profile = stripslashes($profile); $looking = stripslashes($looking); echo ( Name : $namebr Age : $agebr Gender : $genderbr Country : $countrybr Email : $emailbr Your Profile : $profilebr You are looking for : $lookingbr ); if (($img1_size = 256000) and ($img1_type == image/pjpeg) or ($img1_type == image/jpeg)) { echo Your Photo : iName - $img1_name | Size - $img1_size | MIME Type - $img1_type/i br ; } else { echo No photograph uploaded, or wrong Type/Size photograph; } ? = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Uploaded File OverWriting Old File
Glory! Well, I don't see any thing in your code that denotes the directory the images are going in? What about this : copy($img1, mjpalpics/$img1_name) or Die (Could not do); Sends the images to the mjpalpics Directory! 'path/to/img/img.jpg' exists and if so, name the upload img to something else. Hmm... possibly when i say if(file_exists($img1_name)), he's looking for the file name in the Directory where the Images initially go.. but then since i copy them elsewhere, they won't be in the initial place.. and so he overwrites while copying..Possibly! Don't know for sure. T. Edison Jr. = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Uploaded File OverWriting Old File
Well thanks a bunch! --- Nick Wilson [EMAIL PROTECTED] wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 * and then Thomas Edison Jr. declared Hmm... possibly when i say if(file_exists($img1_name)), he's looking for the file name in the Directory where the Images initially go.. but then since i copy them elsewhere, they won't be in the initial place.. and so he overwrites while copying..Possibly! Don't know for sure. Well, check out the manual, you'll find good stuff there. and dot your code with print($whatevers) to see whats going on. - -- Nick Wilson // www.tioka.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.6 (GNU/Linux) iD8DBQE83Pz7HpvrrTa6L5oRAi87AJ0aqEBYw/ii3CiBjZ6h/oFlRseWuQCeKkTG NA6OVtmTrVU841aLkqnZwFI= =k4Rg -END PGP SIGNATURE- -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] Uploaded File OverWriting Old File
WOOO.. i did not know this was possible : file_exists(mjpalpics/$img1_name) And this might actually solve the whole issue!! Let me try this.. Thanks a BUNCH! T. Edison Jr. --- John Holmes [EMAIL PROTECTED] wrote: copy($img1, mjpalpics/$img1_name) or Die (Could not do); Sends the images to the mjpalpics Directory! Possibly. But one thing that is definitely a problem is: if(file_exists($img1_name)) { $img1_name = n+$img1_name; } should be: if(file_exists($img1_name)) { $img1_name = n . $img1_name; } Umm...wouldn't you want to use file_exists(mjpalpics/$img1_name) instead? Otherwise you're not checking for it existing in the same place you are copying it to... ---John Holmes... -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Uploaded File OverWriting Old File
Hmm.. You gave me a lot to think about, and a whole lot of work to do. I definately love your idea and logic, and yes, it would make everyone happy. well i guess by the time i figure the coding and process out, i'll keep in mind to arrange for your British Airways Gift Certificate too. Glory! T. Edison jr. --- Miguel Cruz [EMAIL PROTECTED] wrote: On Sat, 11 May 2002, Thomas Edison Jr. wrote: If i have a filename room.jpg in my Upload Directory, and someone else comes and uploads a file by the same name, the previous room.jpg is overwritten by the new one. Any suggestions? In the long run, I think the best plan is to name your files after the unique database ID. Store the names ('room.jpg') in the database. If you expect getting more than a thousand files or so, split them into directories. If you use a numeric key, just take the last digit or two and use that for the directory (for instance, '4745' would go in '5/4745'). Then write a simple readfile script to process downloads (see today's thread about protecting downloads). You can look in the database and construct URLs like: img src=image.php/4745/room.jpg and your download script can look at the number to figure out which directory it's in, and look at the file name to figure out the mime type to send. The browser's happy because it thinks it's getting a file called room.jpg no matter how many of them you have, the server is happy because the files are spread nicely across a few directories, you're happy because you got your work done, and I'm happy because you sent me a British Airways gift certificate out in gratitude. miguel -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] File Type not working in Uploaded File
Hi, This is my upload form : form action=upload.php method=POST enctype=multipart/form-data p align=centerfont size=2 face=VerdanastrongPlease upload your file below:/p input type=file name=file size=30 pinput type=button name=submit type=submit Upload /form And this is part of my PHP coding, that handles the Upload. Basically the problem is, that my code is not recognising the File Type! I have specified image/jpeg as the file type, but even then it does not upload ANY file at all. In fact it gives the specific error which i have associated when the file type is wrong. * $allow_type = image/jpeg; $allow_file_type = 1; $not_correct_file = bfont face=\$font\ size=\$font_size\ color=\$font_color\Sorry, but the file you tried to upload is not valid file to upload!; if ($allow_file_type == 1) { if ($allow_type != $type) { die($not_correct_file); } } * Why is it that it is NOT recognising ANY file type. I tried removing the Cheking of FILE type, and the program was working fine, where it was Uploading ANY file. However, as soon as i put in this particular code to check for File Type, it does NOT upload any file. Help! T. Edison Jr. = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? Yahoo! Shopping - Mother's Day is May 12th! http://shopping.yahoo.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] importing .dat SQL Data into mySQL
Hi, I have a .dat file.. with some data like this : 02001IN00100213200207120020412200204122002041710002002041720020417 02002IN00100213200207220020415200204152002041810002002041820020418 02003IN00100213200207320020416200204162002041910002002041920020419 This data was exported via SQL Server.. using Oracle. I need to use this data in my mySQL Database and work on it through PHP. Can i use phpMyAdmin for this.. or some other method? Thanks, T. Edison Jr. __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Search Results, Per Page, Total Results!
Hi, I have a mySQL table on which i'm performing a search.. something like this : $sql_text = (SELECT * FROM searchtb where vCategory='$q' || vSubCategory='$q'); Now i want the Search Results to appear per page.. that is, maybe 15 Records per page should appear.. with something like this on top to navigate through search results : Page : [] 1|2|3|4|5 [] And i would also like to display total results found on results page. Lastly, suppose i have a column vProName in my mySQL Database, which contains a record like this : Millenium basket ball Now if someone searches for basket or ball .. i want this record to show up in search results. How can i make that possible? Can anyone guide me towards this.. Thanks, T. Edison Jr. = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Search Results, Per Page, Total Results...
Hi, I'm working on a search program that searches on a mySQL DB and gives back results.. something like this : $sql_text = (SELECT * FROM searchtb where vCategory='$q' || vSubCategory='$q'); What i want is that the results should be displayed PageWise.. that is, maybe 15 results per page. Something like this : Page : [] 1|2|3|4|5 [] And also i would like to display the Total Results on the resulst page. Secondly, i have a table with a column vProName, which let's say, contain Basket Ball Game. Now what i want is that if someone searches for Game or Ball, even then this record should appear. Could someone guide me for the same Thanks, T. Edison Jr. = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Searching a mySQL DB
I'm working on a search program that searches on a mySQL DB and gives back results. I have a table with a column vProName, which let's say, contains a record Basket Ball Game. Now what i want is that if someone searches for Game or Ball, even then this record should appear. Could someone guide me for the same Thanks, T. Edison Jr. __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Adding a in try.jpg!
I have a new very intriguing problem at hand. I have the name of my Images stored in my mySQL database in one column. Now when i pick the images, they are displayed as it as. However, they are the big images, and the thumbnails of those images are stored with an a at the end of thier names. That is, If the image is try.jpg , the thumbnail of the image is trya.jpg !! Now i want to display the thumbnail and not the large image. And unfortunately, my whole database contains the name of Large images and NOt the Thumbnails. How can i : 1. Insert a at the end of the name of the image, before the .extension through PHP. The problems are that the names are stored in the database WITH the extesion. And the extensions also vary, some are JPG and some are GIF. So in my datase i have images as try.jpg or something.gif! How can i insert an a at the end of the name before the . ? 2. OR.. can i insert the a before the . in the image name in my mySQL database itself. Either of the two solutions can work for me. Thanks, T. Edison Jr. __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Adding a in try.jpg! Problems!
Hi, Thanks for your relies. There are a couple of problems. Firstly, i'm picking the filename from the database, so my code is something like this : if ($myrow = mysql_fetch_array($result)) { do { echo( img src=\images\\$myrow[ilmage]\ ); } while ($myrow = mysql_fetch_array($result)); } Now the filename is actually stored in $myrow[ilmage] How do i perform the spliting adding functions on $myrow[ilmage] ?? Secondly, all images are not .JPG, some are jpg others are gif !!! Thank you.. T. Edison Jr. --- Miguel Cruz [EMAIL PROTECTED] wrote: (untested) $newname = eregi_replace('\.jpg$', 'a.jpg', $oldname); No point messing up your database; just use something like the above when you're outputting the image tags for the thumbnails. miguel On Mon, 8 Apr 2002, Thomas Edison Jr. wrote: I have a new very intriguing problem at hand. I have the name of my Images stored in my mySQL database in one column. Now when i pick the images, they are displayed as it as. However, they are the big images, and the thumbnails of those images are stored with an a at the end of thier names. That is, If the image is try.jpg , the thumbnail of the image is trya.jpg !! Now i want to display the thumbnail and not the large image. And unfortunately, my whole database contains the name of Large images and NOt the Thumbnails. How can i : 1. Insert a at the end of the name of the image, before the .extension through PHP. The problems are that the names are stored in the database WITH the extesion. And the extensions also vary, some are JPG and some are GIF. So in my datase i have images as try.jpg or something.gif! How can i insert an a at the end of the name before the . ? 2. OR.. can i insert the a before the . in the image name in my mySQL database itself. Either of the two solutions can work for me. Thanks, T. Edison Jr. __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Adding a in try.jpg! SOLVED!!
Hi, Thanks.. actually that problem is solved, this is what i used : $myrow[ilmage] = eregi_replace('\.jpg$', 'a.jpg', $myrow[ilmage]); $myrow[ilmage] = eregi_replace('\.gif$', 'a.gif', $myrow[ilmage]); and it's now showing the small images with the a!! Thanks AGAIN! T. Edison Jr. --- Miguel Cruz [EMAIL PROTECTED] wrote: (untested) $newname = eregi_replace('\.jpg$', 'a.jpg', $oldname); No point messing up your database; just use something like the above when you're outputting the image tags for the thumbnails. miguel On Mon, 8 Apr 2002, Thomas Edison Jr. wrote: I have a new very intriguing problem at hand. I have the name of my Images stored in my mySQL database in one column. Now when i pick the images, they are displayed as it as. However, they are the big images, and the thumbnails of those images are stored with an a at the end of thier names. That is, If the image is try.jpg , the thumbnail of the image is trya.jpg !! Now i want to display the thumbnail and not the large image. And unfortunately, my whole database contains the name of Large images and NOt the Thumbnails. How can i : 1. Insert a at the end of the name of the image, before the .extension through PHP. The problems are that the names are stored in the database WITH the extesion. And the extensions also vary, some are JPG and some are GIF. So in my datase i have images as try.jpg or something.gif! How can i insert an a at the end of the name before the . ? 2. OR.. can i insert the a before the . in the image name in my mySQL database itself. Either of the two solutions can work for me. Thanks, T. Edison Jr. __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] MS Access data = mySQL database
Hi, I did actually download DBTools and i think its' an excellent software. It's running perfect on my system too. Just a couple of things i'd like to ask you, since you have already used this and i'm fairly new to this... You see, my MySQL server/database is on a web server, for a online website. Now how do i connect the DBTools on my system to the Web Server on the Internet, and then to the database on the website?? Once i'm able to connect to that, then i think it should not be a problem to import the Data from the MS Access table into the MySQL table on the internet. Really appreciate your help... Thanks! T. Edison jr. --- Steven Dowd [EMAIL PROTECTED] wrote: you should try this program , DBTools http://www.dbtools.com.br/ a.. Import Structure and Data from others Databases (MS Access, MS FoxPro, Clipper, Dbase, Paradox, Text Files and ODBC Data sources) a.. Export the database/table contents to SQL, Text, HTML or XML documents. You can dump it directly by using the Dump Data or you can export your results (this includes other formats) a.. You don't need to have MySQL server installed in a WIN32 platform. DBTools can connect to MySQL wherever you have your server installed, using TCP/IP and MySQL C API. I use this constantly to transfer direct from access / excell into mysql. its isnt the answer for you if you want to do it completly with php, but it gets you to the basic area, and transfers the data.. there is at www.hotscripts.com a php accessmysql converter, i tried it last year, but found it very buggy. cannot remember what it was called steven dowd - Original Message - From: Thomas Edison Jr. [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, March 25, 2002 11:31 AM Subject: [PHP] MS Access data = mySQL database Can anyone tell me how to convert/send data stored in an MS Access database to a mySQL table through PHP?? T. Edison Jr. = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? Yahoo! Movies - coverage of the 74th Academy Awards® http://movies.yahoo.com/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? Yahoo! Movies - coverage of the 74th Academy Awards® http://movies.yahoo.com/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] MS Access data = mySQL database
Thanks... actually the software DBTools from www.dbtools.com.br is excellent for the same purpose, as suggested by someone here. It does the needful pretty efficiently. Cheers! T. Edison Jr. --- Jon Farmer [EMAIL PROTECTED] wrote: Can anyone tell me how to convert/send data stored in an MS Access database to a mySQL table through PHP?? 3 Ways of doing this come to mind. Only one uses PHP though. 1. From PHP use ODBC to extract from access and send to MySQL through PHP functions. 2. Export to csv from Access and use mysqlimport to import into MySQL. 3. Use the MySQL ODBC driver to link the MySQL tables into Access and run a query to copy the records over. Regards Jon -- Jon Farmer Systems Programmer, Entanet www.enta.net Tel 01952 428969 PGP Key available, send email with subject: Send PGP Key = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? Yahoo! Movies - coverage of the 74th Academy Awards® http://movies.yahoo.com/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Personal web server that runs PHP
Hi, Of course. The Personal Web Server that is available with Windows 98 as an Add-On totally supports PHP4. I have it configured on my system. I'm not sure if i know of a place where you can download it from.. But it's available as an Add-On with Windows 98 CD. If you look on the net, i'm sure you'll find the PWS. Regards, T. Edison jr. --- Don [EMAIL PROTECTED] wrote: Hi, Does anyone know of a personal web server that I can installon my Win 98 machine that supports PHP 4.x? Thanks, Don = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? Yahoo! Movies - coverage of the 74th Academy Awards® http://movies.yahoo.com/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Personal web server that runs PHP
In fact, using Apache Win32 Module on a Windows 98 PC is a much better choice option rather then PWS. Apache server gives greater flexibility support. I don't see any reason why you should choose PWS over Apache Win32 for your Win 98 PC? T. Edison Jr. --- R'twick Niceorgaw [EMAIL PROTECTED] wrote: u can use Apache on win 98 I believe ? - Original Message - From: Don [EMAIL PROTECTED] To: php list [EMAIL PROTECTED] Sent: Tuesday, March 26, 2002 12:56 PM Subject: [PHP] Personal web server that runs PHP Hi, Does anyone know of a personal web server that I can installon my Win 98 machine that supports PHP 4.x? Thanks, Don -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? Yahoo! Movies - coverage of the 74th Academy Awards® http://movies.yahoo.com/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] MS Access data = mySQL database
Can anyone tell me how to convert/send data stored in an MS Access database to a mySQL table through PHP?? T. Edison Jr. = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? Yahoo! Movies - coverage of the 74th Academy Awards® http://movies.yahoo.com/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Error Handling!
I want errors reported on a page when the mail() function for any reason fails to send emails. FOr example, if there is a malformed email address or anything, and the mail is not sent, how can i catch the Error and Display it on the page? Thanks, T. Edison Jr. = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? Try FREE Yahoo! Mail - the world's greatest free email! http://mail.yahoo.com/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] 5 Records per line
Hi, I would like to display 5 records per line on the Results page. Not seperated by a comma, but just seperated by Space. How can i do that? Thanks, T. Edison jr. = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? Try FREE Yahoo! Mail - the world's greatest free email! http://mail.yahoo.com/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] 5 Records per line
Hi, Thanks for writing back. Basically what i want is, that on a results page, i want that the records should be placed only 5 on one line. For example, let's say i have 100 usernames in a table in my database. Now on one page, i want to display all these usernames. But i want that in one line, there should be only 5 usernames, seperates by spaces. Like this : user1 user2 user3 user4 user5 user6 user7 user8 user9 user10 Can you help? Thanks, T. Edison jr. --- RIVES Sergio [EMAIL PROTECTED] wrote: may you give me more explanations ? thanx SR Thomas Edison Jr. a écrit : Hi, I would like to display 5 records per line on the Results page. Not seperated by a comma, but just seperated by Space. How can i do that? Thanks, T. Edison jr. = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? Try FREE Yahoo! Mail - the world's greatest free email! http://mail.yahoo.com/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? Try FREE Yahoo! Mail - the world's greatest free email! http://mail.yahoo.com/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] 5 Records per line
Hi, This is the code i'm using so far : ?php $db = mysql_connect(localhost,user,pass); mysql_select_db(mydb,$db); $result = mysql_query(SELECT * FROM sms ORDER BY ID DESC,$db); if ($myrow = mysql_fetch_array($result)) { do { echo(bfont color=#6ed8ff$myrow[num]/b br); } while ($myrow = mysql_fetch_array($result)); } else { echo Sorry, no records matching your criteria were found!; } ? But this displays all records one per line... T. Edison Jr. = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? Try FREE Yahoo! Mail - the world's greatest free email! http://mail.yahoo.com/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] 5 Records per line
Hey THANKS! It worked.. just the way i wanted! Thank you so much. T. Edison Jr. --- RIVES Sergio [EMAIL PROTECTED] wrote: i don't know if it will work... i am quite a newbie in this stuff. Hope it could help you Thomas Edison Jr. a écrit : Hi, This is the code i'm using so far : ?php $db = mysql_connect(localhost,user,pass); mysql_select_db(mydb,$db); $result = mysql_query(SELECT * FROM sms ORDER BY ID DESC,$db); if ($myrow = mysql_fetch_array($result)) { do { echo(bfont color=#6ed8ff$myrow[num]/b br); if ($counter % 5 == 0) { print br; } $counter++; } while ($myrow = mysql_fetch_array($result)); } else { echo Sorry, no records matching your criteria were found!; } ? But this displays all records one per line... T. Edison Jr. = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? Try FREE Yahoo! Mail - the world's greatest free email! http://mail.yahoo.com/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? Try FREE Yahoo! Mail - the world's greatest free email! http://mail.yahoo.com/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Check @ in Record show Error in mail() !!
Hi, I'm using the following code to get Email Address stored in a table in my Database : ?php $db = mysql_connect(localhost,user,pass); mysql_select_db(mydb,$db); $result = mysql_query(SELECT * FROM sms where email!='' ORDER BY ID DESC,$db); if ($myrow = mysql_fetch_array($result)) { do { echo(bfont color=#6ed8ff$myrow[email]/b br); } while ($myrow = mysql_fetch_array($result)); } else { echo Sorry, no records matching your criteria were found!; } ? But there are some records where the user has entered something else.. not the Email Address. I would like to list only those records out of these, who do contain the letter @, so that i'm sure only those records which actually do contain an Email Adress are listed. Also, when sending an email, like this : if($submit) { $headers .= From: Mjimm.com [EMAIL PROTECTED]\n; $headers .= X-Sender: [EMAIL PROTECTED]\n; $headers .= X-Mailer: PHP\n; // mailer $headers .= Reply-To: [EMAIL PROTECTED]\n; // Return path for errors $headers .= bcc:$b\n; // BCCs to mail($to,$subject,$message,$headers); } ? If there are any errors in sending the mail, how can i get those errors, or at least have the alert that an error was there and mail could not be sent, printed on the page? Thanks, T. Edison jr. = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? Try FREE Yahoo! Mail - the world's greatest free email! http://mail.yahoo.com/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] phpMyAdmin
With the phpMyAdmin, you get a Config.inc file. You will have to change the parameters (username, password, database) etc., in order to access your phpMyAdmin. T. Edison Jr. --- Chuck \PUP\ Payne [EMAIL PROTECTED] wrote: I have a client that has install phpMyAdmin but can't get into he gets this error; Error MySQL said: Access denied for user: 'root@localhost' (Using password: NO) Is there a way to get into if he knows the password? Chuck PUP Payne Sr. System Administrator GDI Engineering, Inc. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? Try FREE Yahoo! Mail - the world's greatest free email! http://mail.yahoo.com/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] 5 Records in a row displayed!
Hi, I'm looking to display 5 records in one rows, from the database. What i mean is, basically, let's take the emails as an example. I have a table with 100s of email addresses. Now i want to display these email addresses on a page, but i want to display only 5 email adresses in one line, then the next 5 in the next line and so on. Also, perhaps if these emails are seperated by space, nothing else or more. Can someone help me with a code. Regards, T. Edison jr. = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? Try FREE Yahoo! Mail - the world's greatest free email! http://mail.yahoo.com/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Access Denied !!
Hi, I'm facing a rather tricky problem. The thing is, while connecting to the mySQL database using my php page, i get the acess denied error on only One Particular command, and on any other query, the same page, with the same login details works fine! For ex, this works fine : ?php $db = mysql_connect(localhost,m,pwd); mysql_select_db(m,$db); $sql = CREATE table try (ID bigint(21) NOT NULL auto_increment, name varchar(50), email varchar(70), PRIMARY KEY (ID)); $result = mysql_query($sql); echo Thank you! Your information has been entered.\n; ? But this gives an Access Denied error : ?php $db = mysql_connect(localhost,m,pwd); mysql_select_db(m,$db); $query = LOAD DATA INFILE 'fanlist.csv' INTO TABLE try FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '\' LINES TERMINATED BY '\n'; mysql_query($query) or die(error:. mysql_error()); ? Why is this happening? T. Edison jr. = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? Got something to say? Say it better with Yahoo! Video Mail http://mail.yahoo.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] Access Denied !! SOLVED!!
Hi, well, after about a week or so, finally, the turmoil fire has extinguished. the whole problem of importing .csv data and the access denied thingy has been solved, all due to just 'one' single syntax! As it turns out, the command to be applied is NOT THIS : LOAD DATA INFILE 'fanlist.csv' INTO TABLE try FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '\' LINES TERMINATED BY '\n' But in fact it is THIS : LOAD DATA LOCAL INFILE 'fullpath/fanlist.csv' REPLACE INTO TABLE try FIELDS TERMINATED BY ';' ENCLOSED BY '' ESCAPED BY '\\' LINES TERMINATED BY '\r\n' Wether you enter the command directly into the mySQL command line, or through PHP, the error was coming the same, and now with this, it works both ways too! The syntax being missed was LOCAL in Load Data! Thank! T. Edison Jr. --- Rick Emery [EMAIL PROTECTED] wrote: Thomas, What happens when you enter the LOAD DATA INFILE command directly into the MYSQL command line? -Original Message- From: Thomas Edison Jr. [mailto:[EMAIL PROTECTED]] Sent: Friday, February 15, 2002 7:58 AM To: [EMAIL PROTECTED] Subject: [PHP] Access Denied !! Hi, I'm facing a rather tricky problem. The thing is, while connecting to the mySQL database using my php page, i get the acess denied error on only One Particular command, and on any other query, the same page, with the same login details works fine! For ex, this works fine : ?php $db = mysql_connect(localhost,m,pwd); mysql_select_db(m,$db); $sql = CREATE table try (ID bigint(21) NOT NULL auto_increment, name varchar(50), email varchar(70), PRIMARY KEY (ID)); $result = mysql_query($sql); echo Thank you! Your information has been entered.\n; ? But this gives an Access Denied error : ?php $db = mysql_connect(localhost,m,pwd); mysql_select_db(m,$db); $query = LOAD DATA INFILE 'fanlist.csv' INTO TABLE try FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '\' LINES TERMINATED BY '\n'; mysql_query($query) or die(error:. mysql_error()); ? Why is this happening? T. Edison jr. = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? Got something to say? Say it better with Yahoo! Video Mail http://mail.yahoo.com -- 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 = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? Got something to say? Say it better with Yahoo! Video Mail http://mail.yahoo.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] Re-Importing .CSV file into Database
Hi, Ok, considering the FULL PATH and the QUOTES thingy, this is the code i'm applying : ?php $db = mysql_connect(localhost,mydb,pwd); mysql_select_db(mydb,$db); $query = LOAD DATA INFILE 'D:\Apache Group\Apache\htdocs\mjimm\php3\tabledata\fanlist.csv' INTO fanlist_try FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '\' LINES TERMINATED BY '\n' ; mysql_query($query) or die(error:. mysql_error()); ? And this is the error i'm getting : error:You have an error in your SQL syntax near 'fanlist_try FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '' LINES TERMINATED' at line 1 So... what's the problem?? Thanks guys, though. T. Edison jr. = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? Send FREE Valentine eCards with Yahoo! Greetings! http://greetings.yahoo.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Re-Importing .CSV file into Database
DL Neil, OK buddy, let me be more than frank with you.. i don't think i've been quite as confused and having the expression what the hell are you tryin 2 say on my lips in a while, as i had when i read your mail. Hmm.. i do hope u can help me though.. T. Edison jr. Further to David's comment - the mysql data directory (without pathname) is the database's own directory (cf the directory of databases - if that makes any sense) - and any relative pathnames (obviously) lead on from there, so full pathnames are not necessarily necessary. Also, when I did an import last night: 1 it was not necessary to escape the double quote field delimiters (it is within single quotes) 2 because of the vagaries of Windows boxes, it was necessary to ensure the record terminators were treated consistently - either build the export file with only LF or instruct MySQL to use CRLF (as Jason put it to be readable to the MySQL server daemon process thingy) Regards, =dn -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? Send FREE Valentine eCards with Yahoo! Greetings! http://greetings.yahoo.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Cheap, PHP, mySQL hosting!
Hi, Lookin for about 50 Megs with php4, mySQL and the works. Any economical hosts?? thanks.. t. edison jr __ Do You Yahoo!? Send FREE Valentine eCards with Yahoo! Greetings! http://greetings.yahoo.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] Re-Importing .CSV file into Database
Oh yes, definately. With the appropriate columns too. --- Rick Emery [EMAIL PROTECTED] wrote: Has fanlist_try table been created? -Original Message- From: Thomas Edison Jr. [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 13, 2002 10:54 AM To: Jason Murray Cc: [EMAIL PROTECTED] Subject: RE: [PHP] Re-Importing .CSV file into Database Hi, Ok, considering the FULL PATH and the QUOTES thingy, this is the code i'm applying : ?php $db = mysql_connect(localhost,mydb,pwd); mysql_select_db(mydb,$db); $query = LOAD DATA INFILE 'D:\Apache Group\Apache\htdocs\mjimm\php3\tabledata\fanlist.csv' INTO fanlist_try FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '\' LINES TERMINATED BY '\n' ; mysql_query($query) or die(error:. mysql_error()); ? And this is the error i'm getting : error:You have an error in your SQL syntax near 'fanlist_try FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '' LINES TERMINATED' at line 1 So... what's the problem?? Thanks guys, though. T. Edison jr. = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? Send FREE Valentine eCards with Yahoo! Greetings! http://greetings.yahoo.com -- 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 = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? Send FREE Valentine eCards with Yahoo! Greetings! http://greetings.yahoo.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] Re-Importing .CSV file into Database
Hi Rick, Thanks for the support! This is the mySQL Table Structure : $sql = CREATE table fanlist_try (ID bigint(21) NOT NULL auto_increment, name varchar(50), email varchar(70), age int(10), sex varchar(20), country varchar(50), PRIMARY KEY (ID)); And these are few lines from the fanlist.csv file : 1;Akshay Dodeja;[EMAIL PROTECTED];16;Male;United States 2;PAUL MEADOWS;;23;Male;United Kingdom 3;shefalee;[EMAIL PROTECTED];15;Female;India 4;femke dees;[EMAIL PROTECTED];14;Female;Netherlands 5;bram dees;[EMAIL PROTECTED];48;Male;Netherlands In fact, i'm attaching a portion of the .csv file i'm using... Thanks, T. Edison jr. --- Rick Emery [EMAIL PROTECTED] wrote: Thomas, Can you provide your table structure and about a dozen lines from your file? I'd like to experiment with it on my machine. We WILL get this resolved... rick -Original Message- From: Thomas Edison Jr. [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 13, 2002 11:09 AM To: Rick Emery Cc: [EMAIL PROTECTED] Subject: RE: [PHP] Re-Importing .CSV file into Database Oh yes, definately. With the appropriate columns too. --- Rick Emery [EMAIL PROTECTED] wrote: Has fanlist_try table been created? -Original Message- From: Thomas Edison Jr. [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 13, 2002 10:54 AM To: Jason Murray Cc: [EMAIL PROTECTED] Subject: RE: [PHP] Re-Importing .CSV file into Database Hi, Ok, considering the FULL PATH and the QUOTES thingy, this is the code i'm applying : ?php $db = mysql_connect(localhost,mydb,pwd); mysql_select_db(mydb,$db); $query = LOAD DATA INFILE 'D:\Apache Group\Apache\htdocs\mjimm\php3\tabledata\fanlist.csv' INTO fanlist_try FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '\' LINES TERMINATED BY '\n' ; mysql_query($query) or die(error:. mysql_error()); ? And this is the error i'm getting : error:You have an error in your SQL syntax near 'fanlist_try FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '' LINES TERMINATED' at line 1 So... what's the problem?? Thanks guys, though. T. Edison jr. = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? Send FREE Valentine eCards with Yahoo! Greetings! http://greetings.yahoo.com -- 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 = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? Send FREE Valentine eCards with Yahoo! Greetings! http://greetings.yahoo.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? Send FREE Valentine eCards with Yahoo! Greetings! http://greetings.yahoo.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] Re-Importing .CSV file into Database
Hi Darren, Actually your code worked, those errors did go way by putting in INTO TABLE .. but there's a very funny new problem. I get this error on the page : error:Access denied for user: 'mjimm@localhost' (Using password: YES) And believe me, i'm using the correct password/user! The same file, i just insert any other code than the $query, it works! But if i use the loading data infile code.. it gives me this access denied error! What is happening!! T. Edison jr. --- Darren Gamble [EMAIL PROTECTED] wrote: Good day, The proper syntax is: INTO TABLE table and not: INTO table Darren Gamble Planner, Regional Services Shaw Cablesystems GP 630 - 3rd Avenue SW Calgary, Alberta, Canada T2P 4L4 (403) 781-4948 -Original Message- From: Thomas Edison Jr. [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 13, 2002 9:54 AM To: Jason Murray Cc: [EMAIL PROTECTED] Subject: RE: [PHP] Re-Importing .CSV file into Database Hi, Ok, considering the FULL PATH and the QUOTES thingy, this is the code i'm applying : ?php $db = mysql_connect(localhost,mydb,pwd); mysql_select_db(mydb,$db); $query = LOAD DATA INFILE 'D:\Apache Group\Apache\htdocs\mjimm\php3\tabledata\fanlist.csv' INTO fanlist_try FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '\' LINES TERMINATED BY '\n' ; mysql_query($query) or die(error:. mysql_error()); ? And this is the error i'm getting : error:You have an error in your SQL syntax near 'fanlist_try FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '' LINES TERMINATED' at line 1 So... what's the problem?? Thanks guys, though. T. Edison jr. = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? Send FREE Valentine eCards with Yahoo! Greetings! http://greetings.yahoo.com -- 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 = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? Send FREE Valentine eCards with Yahoo! Greetings! http://greetings.yahoo.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Re-Importing .CSV file into Database
Val, quite frankly, i'm not quite sure i know what you're talking about. i don't think i know enum() function!! T. Edison jr. --- val petruchek [EMAIL PROTECTED] wrote: Hi Rick, Thanks for the support! This is the mySQL Table Structure : $sql = CREATE table fanlist_try (ID bigint(21) NOT NULL auto_increment, name varchar(50), email varchar(70), age int(10), sex varchar(20), country varchar(50), PRIMARY KEY (ID)); sex varchar(20) sounds great. why do not use enum('male','female')? or sex has infinite set of possible values? Valentin Petruchek (aki Zliy Pes) *** Cut the beginning *** http://zliypes.com.ua mailto:[EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? Send FREE Valentine eCards with Yahoo! Greetings! http://greetings.yahoo.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Re-Importing .CSV file into Database
Val, hey thanks.. that's a very interesting data type. wonder why i never knew it. thanks a bunch. i'll def. be using it more often now. the current problem at hand of getting the : error:Access denied for user: 'mjimm@localhost' (Using password: YES) is really jamming the thought process. i have no clue why this is happening on the Load Data Infile command only... T. Edison jr. --- val petruchek [EMAIL PROTECTED] wrote: Enum is not a function; it's a mysql data type. It's very useful when field values are from the finite set. Examples CREATE table fanlist_try (ID bigint(21) NOT NULL auto_increment, name varchar(50), email varchar(70), age int(10), sex enum('male','female'), country varchar(50), PRIMARY KEY (ID)) and field sex now can have only 2 values - 'male' and 'female' the main reason to use it (instead of MySQL) is speed. The next one could be data correctness Valentin Petruchek (aki Zliy Pes) *** Cut the beginning *** http://zliypes.com.ua mailto:[EMAIL PROTECTED] - Original Message - From: Thomas Edison Jr. [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, February 13, 2002 7:36 PM Subject: Re: [PHP] Re-Importing .CSV file into Database Val, quite frankly, i'm not quite sure i know what you're talking about. i don't think i know enum() function!! T. Edison jr. --- val petruchek [EMAIL PROTECTED] wrote: Hi Rick, Thanks for the support! This is the mySQL Table Structure : $sql = CREATE table fanlist_try (ID bigint(21) NOT NULL auto_increment, name varchar(50), email varchar(70), age int(10), sex varchar(20), country varchar(50), PRIMARY KEY (ID)); sex varchar(20) sounds great. why do not use enum('male','female')? or sex has infinite set of possible values? Valentin Petruchek (aki Zliy Pes) *** Cut the beginning *** http://zliypes.com.ua mailto:[EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? Send FREE Valentine eCards with Yahoo! Greetings! http://greetings.yahoo.com -- 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 = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? Send FREE Valentine eCards with Yahoo! Greetings! http://greetings.yahoo.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re-Importing .CSV file into Database
Glory! I have a bunch of .CSV (Microsoft Excel Comma Seperated Values) Files with me, whose data i want to put back into my mySQL database tables. How can i do that through php? or otherwise... thanks, T. Edison jr. = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? Send FREE Valentine eCards with Yahoo! Greetings! http://greetings.yahoo.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] Re-Importing .CSV file into Database
I have space on a server on the internet. I have mySQL PHP4 support. And i can easily upload the .CSV files on the server itself. Could you kindly help me out with the php code that would make this possible.. Thanks, T. Edison jr. --- Rick Emery [EMAIL PROTECTED] wrote: The file is located on the server and you have access to it, yes. If the file is on the client, then no -Original Message- From: Thomas Edison Jr. [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 12, 2002 12:21 PM To: Rick Emery Subject: RE: [PHP] Re-Importing .CSV file into Database HI, Thanks.. i will try this. But tell me, can this same be executed through a php page rather than the mySQL command line? T. Edison Jr. --- Rick Emery [EMAIL PROTECTED] wrote: look at MYSQL's LOAD DATA INFILE command: LOAD DATA INFILE datafile.csv INTO mytable FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '' LINES TERMINATED BY '\n' -Original Message- From: Thomas Edison Jr. [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 12, 2002 12:02 PM To: [EMAIL PROTECTED] Subject: [PHP] Re-Importing .CSV file into Database Glory! I have a bunch of .CSV (Microsoft Excel Comma Seperated Values) Files with me, whose data i want to put back into my mySQL database tables. How can i do that through php? or otherwise... thanks, T. Edison jr. = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? Send FREE Valentine eCards with Yahoo! Greetings! http://greetings.yahoo.com -- 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 = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? Send FREE Valentine eCards with Yahoo! Greetings! http://greetings.yahoo.com = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? Send FREE Valentine eCards with Yahoo! Greetings! http://greetings.yahoo.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] Re-Importing .CSV file into Database
Hi Rick, I tries your code but i'm constantly getting some errors. I modified the line to try and correct the error, and this is the code i'm using : ?php $db = mysql_connect(localhost,mydb,pwd); mysql_select_db(mydb,$db); $query = LOAD DATA INFILE list.csv INTO list_try FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '\' LINES TERMINATED BY '\n'; mysql_query($query) or die(error:. mysql_error()); echo Thank you! Your information has been entered.\n; ? And i'm still getting errors on the mail $query line. Can you say what is wrong? T. Edison Jr. --- Rick Emery [EMAIL PROTECTED] wrote: connect to your mysql server select the mysql database $query = LOAD DATA INFILE datafile.csv INTO mytable . FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '\' . LINES TERMINATED BY '\n' ; mysql_query($query) or die(error:. mysql_error()); -Original Message- From: Thomas Edison Jr. [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 12, 2002 1:11 PM To: [EMAIL PROTECTED] Subject: RE: [PHP] Re-Importing .CSV file into Database I have space on a server on the internet. I have mySQL PHP4 support. And i can easily upload the .CSV files on the server itself. Could you kindly help me out with the php code that would make this possible.. Thanks, T. Edison jr. --- Rick Emery [EMAIL PROTECTED] wrote: The file is located on the server and you have access to it, yes. If the file is on the client, then no -Original Message- From: Thomas Edison Jr. [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 12, 2002 12:21 PM To: Rick Emery Subject: RE: [PHP] Re-Importing .CSV file into Database HI, Thanks.. i will try this. But tell me, can this same be executed through a php page rather than the mySQL command line? T. Edison Jr. --- Rick Emery [EMAIL PROTECTED] wrote: look at MYSQL's LOAD DATA INFILE command: LOAD DATA INFILE datafile.csv INTO mytable FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '' LINES TERMINATED BY '\n' -Original Message- From: Thomas Edison Jr. [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 12, 2002 12:02 PM To: [EMAIL PROTECTED] Subject: [PHP] Re-Importing .CSV file into Database Glory! I have a bunch of .CSV (Microsoft Excel Comma Seperated Values) Files with me, whose data i want to put back into my mySQL database tables. How can i do that through php? or otherwise... thanks, T. Edison jr. = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? Send FREE Valentine eCards with Yahoo! Greetings! http://greetings.yahoo.com -- 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 = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? Send FREE Valentine eCards with Yahoo! Greetings! http://greetings.yahoo.com = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? Send FREE Valentine eCards with Yahoo! Greetings! http://greetings.yahoo.com -- 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 = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? Send FREE Valentine eCards with Yahoo! Greetings! http://greetings.yahoo.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] ReFilling mySQL Database with CSV file!!
I have to shift my site to a new location. I have enormous records in many tables in my database which will be needed 2 be shifted to. The 'phpMyAdmin' at my site allows me make dumps of the Data in the CSV format. I haven't done this before. These are the options it gives me : 1. Structure only 2. Structure and data 3. Data only 4. CSV for Ms Excel data 5. CSV data : Fields terminated by; Fields enclosed by Fields escaped by / Lines terminated by \r\n 6. Save as file Can someone please tell me exactly which option should i be choosing? And also, once i have chosen that and saved the lot of .csv files on my computer. What is going to be the process to re-fill the new Database It's new tables with the data in the saved .csv File? Thanks, T. Edison Jr. = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? Great stuff seeking new owners in Yahoo! Auctions! http://auctions.yahoo.com -- PHP General 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] Upload View Image : Database Thingy!!!!
Malte, Thanks a lot. I was going through the File Upload Functions in the manual and i think that's what they were talking about too. Now there's just one thing. I can run the upload scripts and get the image for display too. But like i mentioned, this is for a PenPal system, a database based PenPal sysem. Basically there has to be some connection between the record entry by the user and the image. Which also be required when this record is displayed, for the corresponding image to be displayed. How migh that work? Thanks again, T. Edison jr. --- Malte Fucks [EMAIL PROTECTED] wrote: I think the PHP image functions aren't what this guy needs... First thing : File Uploads You have to make a form, including an input type=file name=yourfile tag, which refers to a php script like... ? if($file) { if(@copy($yourfile,./$yourfile_name)) { echo $yourfile_name was uploaded succesfully; } else echo ERROR - UPLOAD ABORTED; } ? $yourfile_size includes the size of the file in bytes, use an if-statement to check if the picture-size fits your needs... $yourfile_type includes... guess what... the file type.. this should solve the upload problem... To control the size of an image is a matter of your HTML... do something like img src=yourimage width=40px height=40px. Its even possible to insert height and width-values in percent... -- PHP General 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] = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ -- PHP General 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] Upload View Image
Hi, I have a penpal system running on a site. I want to add a feature wherein the person can upload his image and when somebody views the PenPal list, the uploaded image is shown next to his ad. Can we also control the Image Width Height? I mean when the Image is displayed, it should be in a Size i want, and not any size. And also the File Size.. i dont' want very heavy images uploaded. Can that be restricted? Thanks, T. Edison jr. = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ -- PHP General 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] Changing From Info in eMail!
Hi, I'm using the mail() function to send email. However, when the reciever recieves the email, my Servers name comes up in the From in his MailBox and also inside the email, even after defining the From: in the mail function. How do i change this From info?? This is what i'm using : mail($to, $subject, $message, From: $from); Thanks! T. Edison jr. = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? Send your FREE holiday greetings online! http://greetings.yahoo.com -- PHP General 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] Changing From Info in eMail! : SOLVED!!!
Hi Ben, Thanks for your reply. Actually i did find a solution, and it is like this : mail($to,$subject,$message,From: [EMAIL PROTECTED]\nReply-To: [EMAIL PROTECTED]\nX-Mailer:PHP/ . phpversion()); The quotes could have been a problem so i did remove them. But the real thing were the Headers in the end. They work perfectly. Replace the Server Name and also put in the extra Reply-TO feature! Thanks again! T. Edison Jr. --- Ben Clumeck [EMAIL PROTECTED] wrote: I would try the following: mail($to, $subject, $message, From: $from); instead of : mail($to, $subject, $message, From: $from); I had a similar problem because I didn't have everything in quotes. Ben -Original Message- From: Thomas Edison Jr. [mailto:[EMAIL PROTECTED]] Sent: Monday, December 24, 2001 10:36 AM To: [EMAIL PROTECTED] Subject: [PHP] Changing From Info in eMail! Hi, I'm using the mail() function to send email. However, when the reciever recieves the email, my Servers name comes up in the From in his MailBox and also inside the email, even after defining the From: in the mail function. How do i change this From info?? This is what i'm using : mail($to, $subject, $message, From: $from); Thanks! T. Edison jr. = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? Send your FREE holiday greetings online! http://greetings.yahoo.com -- PHP General 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] = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? Send your FREE holiday greetings online! http://greetings.yahoo.com -- PHP General 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] Counting Views on records in DB!
Hi, I was just going through some Message Board system and noticed that there is a Views column which gives how many times the Message has been viewed. I created a similar message board, where Messages are stored in a MySQL DB Table. But i have no idea how to do this, that the number of times that Record is picked up is counted!! Can anyone guide me as to how this can be achieved? Thanks, T. Edison jr. __ Do You Yahoo!? Send your FREE holiday greetings online! http://greetings.yahoo.com -- PHP General 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] Counting Views on records in DB!
Hi, UPDATE $table views=views+1 Umm.. can you be a little more specific. I couldn't make much sense, thought i could get the logic. Thanks. T. Edison jr. Hi, I was just going through some Message Board system and noticed that there is a Views column which gives how many times the Message has been viewed. I created a similar message board, where Messages are stored in a MySQL DB Table. But i have no idea how to do this, that the number of times that Record is picked up is counted!! Can anyone guide me as to how this can be achieved? Thanks, T. Edison jr. __ Do You Yahoo!? Send your FREE holiday greetings online! http://greetings.yahoo.com = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? Send your FREE holiday greetings online! http://greetings.yahoo.com -- PHP General 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] PHP3 NOT being parsed for SSI!! HELP!!
Folks, I have a serious problem and i don't know what to do. We have a fixed template for each intranet page. Now the template consists of a header, a left navigation and a footer. The body would contain my pages content. What we are doing at present is that the header, the left navigation and the footer is included in the page using SSI. The header is a static include file. However the footer and the left navigation are customizable, and hence are dynamic pages (cgi scripts) which generate the appropriate code depending on the command line parameters. Now the problem is that php3 pages are not being parsed for SSI. I looked up on the web , and found that only one of two can be used at the same time. Can anyone suggest a Possible Solution? We are running a Solaris machine! Thanks, T. Edison Jr. = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? Check out Yahoo! Shopping and Yahoo! Auctions for all of your unique holiday gifts! Buy at http://shopping.yahoo.com or bid at http://auctions.yahoo.com -- PHP General 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] How to backup records in mySQL DB?
Hi, I'm having a touch situation on my hands. Last week one of my site was shut down in what the Hosting Company claimed to be a Policy Violation. However, it was found out later that it wasn't so and they had to re-host my site. Unfortunately, they erased my mySQL database with my account and we lost all our very important Data in the tables there. It's horrible. We're beggining again but i'm not scared about the Data. The data is posted online by users. I need to have a way to backup my mySQL data. If possible, on some other site location or in Hard Copy (As in a file) or something. I don't know how to do any of this. I have no idea what to do about it. Can anyone make any suggestions help? Regards, T. Edison jr. = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? Check out Yahoo! Shopping and Yahoo! Auctions for all of your unique holiday gifts! Buy at http://shopping.yahoo.com or bid at http://auctions.yahoo.com -- PHP General 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] How to backup records in mySQL DB?
Hi, I'm having a touch situation on my hands. Last week one of my site was shut down in what the Hosting Company claimed to be a Policy Violation. However, it was found out later that it wasn't so and they had to re-host my site. Unfortunately, they erased my mySQL database with my account and we lost all our very important Data in the tables there. It's horrible. We're beggining again but i'm not scared about the Data. The data is posted online by users. I need to have a way to backup my mySQL data. If possible, on some other site location or in Hard Copy (As in a file) or something. I don't know how to do any of this. I have no idea what to do about it. Can anyone make any suggestions help? Regards, T. Edison jr. = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? Check out Yahoo! Shopping and Yahoo! Auctions for all of your unique holiday gifts! Buy at http://shopping.yahoo.com or bid at http://auctions.yahoo.com -- PHP General 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] PHP script not paring in CGI!!!
Hi, I'm running a Solaris OS. I have written a CGO function to call common header footer for pages. All HTML pages are running well with it, however, a PHP3 page is not!! It's contents are not showing up. Nothing i showing up! What do i do? T. Edison jr. = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? Check out Yahoo! Shopping and Yahoo! Auctions for all of your unique holiday gifts! Buy at http://shopping.yahoo.com or bid at http://auctions.yahoo.com -- PHP General 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] Help needed developing Logic!
Hi, I've made a PHP Chatroom and i need help developing the logic behind the Private Chat feature. I'll first explain briefly how my chat works. It's a very very simple Chat using just DB and nothing else. User enters.. his name,date goes into Chat. QueryString passes his name to main area from where he can post messages with the name as the main link between his messages database. You can view it at http://www.mjimm.com/index.php3?page=chat/mjchat.html Please choose PHP Chat from above link. Anyway, now i need to develop a system where one can private chat with a user. So that by selecting the User's name, when the person sends a message.. it is displayed only on the Selected User's chat.. and not anyone else.. or perhaps some other way. Can anyone help? Ask me any question if you wish to clarify further how my chat works!! Cheers Glory, T. Edison jr. = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month. http://geocities.yahoo.com/ps/info1 -- PHP General 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] Resetting ID in mySQL DB
Jack, Thanks a lot for you help. I did actually work out the logistics of the code and it's doing fine. It's probably a solution to my problem, there's only a couple of things though : a) I got about 800 plus records in the table. And there's a lot of empty or duplicate records in there which need to be deleted. So if i individually delete every record then i will have to run the code for each ID individually. That would be a lot to do. That's why i was wondering if there's a way, by which after having deleted those empty/duplicate records, i could just clear the entire ID field and run a code that would generate IDs in order again... b) How can i check when the record is sent to the DB using PHP3 or mySQL if there's any value in the field or not? I have put up a JavScript validation to check for the same in the form, and yet, something's defeating that and empty records are entering into the DB. I don't know why really!! Thanks a bunch! Cheers Glory, Thomas Edison jr. --- Jack Dempsey [EMAIL PROTECTED] wrote: Thomas, The code i gave can't be copied directly in...you need to use it as a guide, but use your own variables... So, basically, whatever field you have as your id field, that is what you will put in place of what i called id_num...and the number 36 was just an example...see if this makes sense: you want to delete a record with the column ID being X 'delete from table where ID=X' that would be your sql then you send another query: $sql = update table set ID=ID-1 where IDX; what this does is say ok, the numbers before the item you deleted will stay the same, but from the place you deleted on higher you need to decrement the id values by one. try this from the mysql command line on a test table with some fake records, and you should see what i mean... good luck jack -Original Message- From: Thomas Edison Jr. [mailto:[EMAIL PROTECTED]] Sent: Monday, November 12, 2001 2:09 AM To: Jack Dempsey Subject: RE: [PHP] Resetting ID in mySQL DB Jack, Ok i get it! Lemme just go through the code once more... to be exact.. the code will be : ?php $db = mysql_connect(localhost,dbname,pass); mysql_select_db(dbname,$db); $sql = update table set id_num=id_num-1 where id 36,$db; $result = mysql_query($sql); ? Or i made a mistake? Is there anyway i can re-write all the IDs from 1 onwards? Thanks a Ton! Cheers Glory! --- Jack Dempsey [EMAIL PROTECTED] wrote: say you have 100 records. you delete number 36. your db will then be ... 34 35 37 38 ... correct? after a delete, you could then say: update table set id_num=id_num-1 where id 36 and this would update all relevant records -Original Message- From: Thomas Edison Jr. [mailto:[EMAIL PROTECTED]] Sent: Monday, November 12, 2001 1:52 AM To: [EMAIL PROTECTED] Subject: [PHP] Resetting ID in mySQL DB Hi, I'm facing a problem. I made a simple DB with simple adding records in DB operation. I've even put up a JavaScript validation of the Form from where you add info. And yet, in the display table, there are many many blank fields. I don't know how they are generated. The Adding of info form is at : http://www.mjimm.com/index.php3?page=fanlist_add.php3 The display of records is at : http://www.mjimm.com/fanlist_view.php3 Now the Display table also Displays the ID of the Record. If i go in my mySQL Admnin, and delete the rows with blank or duplicate records.. the ID also is deleted but then is alway missing from the list. That is, if i delete Row with ID 78, the next record feeded will start from 79 and not 78. So there's gonne be missing ID's from Records. Which i don't want. But which has already happened. How can i correct it?? I want to reset the entire IDs to reflect the true Number of records after i delete the Empty/Blank Rows Duplicate Record Rows!! How can i do that! Please help! Cheers Glory, Thomas edison jr. = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? Find a job, post your resume. http://careers.yahoo.com -- PHP General 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 General 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] = Rahul S. Johari (Director) ** Abraxas Technologies Inc
[PHP] Resetting ID in mySQL DB
Hi, I'm facing a problem. I made a simple DB with simple adding records in DB operation. I've even put up a JavaScript validation of the Form from where you add info. And yet, in the display table, there are many many blank fields. I don't know how they are generated. The Adding of info form is at : http://www.mjimm.com/index.php3?page=fanlist_add.php3 The display of records is at : http://www.mjimm.com/fanlist_view.php3 Now the Display table also Displays the ID of the Record. If i go in my mySQL Admnin, and delete the rows with blank or duplicate records.. the ID also is deleted but then is alway missing from the list. That is, if i delete Row with ID 78, the next record feeded will start from 79 and not 78. So there's gonne be missing ID's from Records. Which i don't want. But which has already happened. How can i correct it?? I want to reset the entire IDs to reflect the true Number of records after i delete the Empty/Blank Rows Duplicate Record Rows!! How can i do that! Please help! Cheers Glory, Thomas edison jr. = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? Find a job, post your resume. http://careers.yahoo.com -- PHP General 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] Upgrading to Windows XP Whistler
I'm gonna be using windows XP whistler home edition. Can someone tell me if i'll be needing a different version of PHP4 to download install and the installation instructions to go along. So far that i've heard is that it's the same as Windows 2000, but i'm muchly new at this thing so it'd be really good if someone can tell me what is gonna to happen. Also, i've been using Apache as the server, will i have to download a newer version of Apache for my windows XP? Thanks. Thomas Edison jr. = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- PHP General 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] HTTP Auth
Try using this : ?php $auth = false; // Assume user is not authenticated if (isset( $PHP_AUTH_USER ) isset($PHP_AUTH_PW)) { mysql_connect('localhost','root') or die ( 'Unable to connect to server.' ); mysql_select_db( 'myDB' ) or die ( 'Unable to select database.' ); // Formulate the query $sql = SELECT * FROM myTable WHERE username = '$PHP_AUTH_USER' AND password = '$PHP_AUTH_PW'; // Execute the query and put results in $result $result = mysql_query( $sql ) or die ( 'Unable to execute query.' ); // Get number of rows in $result. $num = mysql_numrows( $result ); if ( $num != 0 ) { // A matching row was found - the user is authenticated. $auth = true; } } if ( ! $auth ) { header( 'WWW-Authenticate: Basic realm=Private' ); header( 'HTTP/1.0 401 Unauthorized' ); echo 'Authorization Required.'; exit; } else { ***your stuff goes here when authenticated } ? works excellent on any browser, apache server with PHP module. T. Edison jr. --- gary [EMAIL PROTECTED] wrote: Im having a problem with Authentication uisng $PHP_AUTH_USER and $PHP_AUTH_PASSWORD works fine connecting via netscape but automatically set to false when using IE 5. Apache server , PHP installed as a module on a freebie server. Code below: ?php // Assume user is not authenticated if (isset($PHP_AUTH_USER) isset($PHP_AUTH_PW)) { // Connect to database $conn = pg_pconnect (dbname=.$db.$login); // Select database on MySQL server // Formulate the query $sql = SELECT * FROM .$table2. WHERE username = '$PHP_AUTH_USER' AND password = '$PHP_AUTH_PW' and valid ='y'; // Execute the query and put results in $result $result = pg_Exec ( $sql ); // Get number of rows in $result. $num = pg_numrows( $result ); if ( $num != 0 ) { // A matching row was found - the user is authenticated. $auth = true; } } if ( ! $auth ) { header(WWW-Authentucate: Basic realm=\Private\\\n); Header (Status: 401 Unauthorized\n); header(HTTP/1.0 401 Unauthorized\n); echo 'Authorization Required.br'; echo 'Please go to a href=./index,php?pg=REGISTERRegistration/a page to Get a logon, It is Free.'; echo brb???.$PHP_AUTH_USER.br???.$PHP_AUTH_PW./b; exit; } else { } pg_close($conn); ? -- PHP General 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] = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- PHP General 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] HTTP authentication : logout!!!
i'm using http authentication for my php pages (members area). Once you login correctly, than you can access anypage as the authentication box doesn't pop-up. Now i woul like to create a logout link after clicking on which, whenever you click on a page using auth, the auth box should pop-up again and you must feed in your user/pass. What should this logout page contain? what coding do i have to do? From what i understand, there is a $auth which is False by default. When auth is succesfull, it contains True. And once it's true, the auth box doesn't pop-up. I understand that probably clicking on this logout link should again make $auth false. But then $auth is on a lot of pages, how does this $auth on logout.php3 make all the other $auth's false? or is there some other way? the code i'm using for auth is : *** ?php $auth = false; // Assume user is not authenticated if (isset( $PHP_AUTH_USER ) isset($PHP_AUTH_PW)) { mysql_connect('localhost','root') or die ( 'Unable to connect to server.' ); mysql_select_db( 'skynet' ) or die ( 'Unable to select database.' ); // Formulate the query $sql = SELECT * FROM register WHERE username = '$PHP_AUTH_USER' AND password = '$PHP_AUTH_PW'; // Execute the query and put results in $result $result = mysql_query( $sql ) or die ( 'Unable to execute query.' ); // Get number of rows in $result. $num = mysql_numrows( $result ); if ( $num != 0 ) { // A matching row was found - the user is authenticated. $auth = true; } } if ( ! $auth ) { header( 'WWW-Authenticate: Basic realm=Private' ); header( 'HTTP/1.0 401 Unauthorized' ); echo 'Authorization Required.'; exit; } else { %%stuff 2 do%% } ? *** Regards, T. Edison jr. = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- PHP General 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] Sorry, what is PWS
PWS is Personal Web Server. It's a web server by Microsoft. Practically it's pretty easy to use. You can install it into any home PC using win98 and configure PHP on it to use. It supports ASP by default so you can do you ASP scripting using it. Latest version of PWS is 4.0! If u're looking for something esy fast to get running, PWS is it. It's a server just like Apache or any other, only, well, it's Microsoft, and like Mr. Lynch once said, Microsoft Stable don't go in the same line. But anyways, it works ok at home for any kind of work. T. Edison jr. --- [EMAIL PROTECTED] wrote: It´s time for me to ask: What is PWS? I wanna know what I´m reading about ;-) TIA Oliver -- PHP General 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] = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- PHP General 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] IIS instead of PWS!!! what else can i do..
i think i'm almost at the verge of giving up...somehow the PWS in my system is ruined forever...i'd done everything..and i mean *EVERYTHING*...but PHP just doesn't seem to be working with my PWS. In fact, even my ASP scripts are not working anymore on PWS. I've uninstalled reinstalled PWS twice already. it's just **%^. anyways, i think i'm gonna be trying out the IIS option. Is IIS ok to work with PHP4? any problems? and is there anywhere on the Internet that i can get IIS 4 from? thankx all yah, T. Edison jr. = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- PHP General 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] PHP on PWS not working!
1. Rename php.ini-dist to php.ini (if you haven't) 2. Simplify your script 3. Try changing your directory properties in PWS: Read/Execute/Scripts - try different combinations been there, done that, you could say. i think i've tried every possible humanly available option. my \inetpub\wwwroot is the web dir. and i have read, execue scripts checked for that on PWS. plus i have c:\php4\sapi\(the dll) declared in my regedit. everything is how it's supposed to be. i don't know what's wrong! help me if you can! T. Edison jr. = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- PHP General 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] PHP on PWS not working!
me again...i hope MTS is not required for running PHP4.0.5 on PWS. Cause i'm not having the MTS (Microsoft Transaction Server) installed on my PWS. T. Edison jr. --- Donald Goodwill [EMAIL PROTECTED] wrote: I couldn't find your original message, but here are some ideas: 1. Rename php.ini-dist to php.ini (if you haven't) 2. Simplify your script 3. Try changing your directory properties in PWS: Read/Execute/Scripts - try different combinations --- Thomas Edison Jr. [EMAIL PROTECTED] wrote: would you believe it, i did!! still not working. still giving the 500 Internal Server Error. I uninstalled then reinstalled PWS. cooked up the settings again...and no response!! T. Edison jr. --- Data Driven Design [EMAIL PROTECTED] wrote: Did you copy the php4ts.dll to your windows/system directory? I think I had to do that even though it wasn't in the directions Data Driven Design P.O. Box 1084 Holly Hill, Florida 32125-1084 http://www.datadrivendesign.com http://www.rossidesigns.net - Original Message - From: Thomas Edison Jr. [EMAIL PROTECTED] To: Data Driven Design [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Saturday, May 05, 2001 2:44 PM Subject: Re: [PHP] PHP on PWS not working! nothing does seem to work...i don't know what the hell is the problem!! i did put this : C:\\php\\sapi\\php4isapi.dll in the regedit file and it looks great. everything is just so by the book. where the hell am i going wrong!! can't understand what's different here that was not before coz it was working before!!! did you define any path in the doc_root = in php.ini? because i didn't! Cheers, T. Edison jr. = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- PHP General 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] = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- PHP General 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] __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- PHP General 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] = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- PHP General 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] IIS instead of PWS!!! what else can i do..
The only reason why i'm opting for pws or IIS is because i need to run ASP scripts on my PC too. I'm an ASP engineer as well and it's my Second major. So i need to work with ASP too. Does Xitami support ASP? and if it doesn't, can u tell me any other web server for the PC which will run ASP PHP both. I do have the Jrun Server installed cause i work with JSP too. I actually need all 3 : PHP, ASP JSP running on my PC. I'm using JRun for JSP, Apache (now, before i was using PWS) for PHP and i need something for ASP now since my PWS is not working. Regards, T. Edison jr. --- Zak Greant [EMAIL PROTECTED] wrote: You may want to try Xitami (www.imatix.com) as a fast/free/open source alternative to the Microsoft products. --zak - Original Message - From: Thomas Edison Jr. [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, May 06, 2001 12:52 AM Subject: [PHP] IIS instead of PWS!!! what else can i do.. i think i'm almost at the verge of giving up...somehow the PWS in my system is ruined forever...i'd done everything..and i mean *EVERYTHING*...but PHP just doesn't seem to be working with my PWS. In fact, even my ASP scripts are not working anymore on PWS. I've uninstalled reinstalled PWS twice already. it's just **%^. anyways, i think i'm gonna be trying out the IIS option. Is IIS ok to work with PHP4? any problems? and is there anywhere on the Internet that i can get IIS 4 from? thankx all yah, T. Edison jr. = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- PHP General 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] = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- PHP General 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] IIS instead of PWS!!! what else can i do..
Why not install all three servers (IIS/Apache/Jrun) yeah, well i'm already doing that sir. only problem is, since few days my PWS is not working. Fortunately, just minutes ago i was able to fix it so that ASP is running perfectly on PWS now. Only PHP is not. So anyway, i guess i've dropped the idea of making PHP4 run on PWS since it is not going to (somehow). So now i Am running PWS/Apache/Jrun on my PC and working with ASP, PHP JSP. no problem. that you do mention it, can u tell me if it's better to use IIS or PWS? and where can i get IIS? Cheers, T. Edison jr. = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- PHP General 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] PHP on PWS not working!
right, i can change to the CGI version immideately, as it is i have the module ver installed on my Apache. Tell me something, to make it back to the CGI ver, the only thing i have to do is to give the path in my regedit as C:\php4\php.exe %s %s instead of what i was giving C:\php4\sapi\(the php dll) ?? or is there something else also that i'll need to do? T. Edison jr. --- Phil Driscoll [EMAIL PROTECTED] wrote: What is going wrong is that you are using the ISAPI version of PHP and it is quite unstable on anything lower than W2K. It manifests itself in the server 500 errors you describe and, because it kills bits of the server, ASP dies as well. Just change to the cgi installation and all should become good. If you are using ASP then I think that moving to Xitami is not an option (someone correct me if I'm wrong with that guess). In the same vein, IIS only runs on NT server and W2K so that may not be an option - and in any case that would fall over with the ISAPI module as well. Cheers -- Phil Driscoll Dial Solutions +44 (0)113 294 5112 http://www.dialsolutions.com http://www.dtonline.org = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- PHP General 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] PHP on PWS not working! : WORKING NOW!!
thankx a lot sir, i guess your guessing worked real well...after 5 days of headbanging and trying everything, it workedi did what u said...removed all references to the isapi dll and converted the php module to php cgi and it's working on PWS. i guess i'm gonan use my apache server for the Module part. thankx again. T. Edison jr. --- Phil Driscoll [EMAIL PROTECTED] wrote: I dont' have PWS so I#m guessing, but you probably have to remove the PHP ISAPI module from the list of installed ISAPI filters (you do have to do this on IIS so I assume PWS is the same). No idea where the user interface to this might be found though. Failing all else, deleting php4isapi.dll and rebooting will ensure that the module is no longer loaded in the filters list, and as long as PWS still starts then you are on to a winner! Cheers -- Phil Driscoll Dial Solutions +44 (0)113 294 5112 http://www.dialsolutions.com http://www.dtonline.org = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- PHP General 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] IIS instead of PWS!!! what else can i do..
Already Did sir! and am as happy as u would've been. finally i can test http authentication 2. Cheers, T. Edison jr. We're out of our medicines and out of our minds... --- MaD dUCK [EMAIL PROTECTED] wrote: also sprach Thomas Edison Jr. (on Sat, 05 May 2001 11:52:34PM -0700): i think i'm almost at the verge of giving up...somehow the PWS in my system is ruined forever...i'd done everything..and i mean *EVERYTHING*...but PHP just doesn't seem to be working with my PWS. In fact, even my ASP scripts are not working anymore on PWS. I've uninstalled reinstalled PWS twice already. it's just **%^. anyways, i think i'm gonna be trying out the IIS option. Is IIS ok to work with PHP4? any problems? and is there anywhere on the Internet that i can get IIS 4 from? if i were you, and i am serious about this, then i'd install apache on your windoze system. it was the best move i ever made back then when i was still using windoze. martin; (greetings from the heart of the sun.) \ echo mailto: !#^.*|tr * mailto:; net@madduck -- above all, we should not wish to divest our existence of its rich ambiguity. -- nietzsche -- PHP General 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] = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- PHP General 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] PHP on PWS not working!
nothing does seem to work...i don't know what the hell is the problem!! i did put this : C:\\php\\sapi\\php4isapi.dll in the regedit file and it looks great. everything is just so by the book. where the hell am i going wrong!! can't understand what's different here that was not before coz it was working before!!! did you define any path in the doc_root = in php.ini? because i didn't! Cheers, T. Edison jr. = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- PHP General 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] PHP on PWS not working!
would you believe it, i did!! still not working. still giving the 500 Internal Server Error. I uninstalled then reinstalled PWS. cooked up the settings again...and no response!! T. Edison jr. --- Data Driven Design [EMAIL PROTECTED] wrote: Did you copy the php4ts.dll to your windows/system directory? I think I had to do that even though it wasn't in the directions Data Driven Design P.O. Box 1084 Holly Hill, Florida 32125-1084 http://www.datadrivendesign.com http://www.rossidesigns.net - Original Message - From: Thomas Edison Jr. [EMAIL PROTECTED] To: Data Driven Design [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Saturday, May 05, 2001 2:44 PM Subject: Re: [PHP] PHP on PWS not working! nothing does seem to work...i don't know what the hell is the problem!! i did put this : C:\\php\\sapi\\php4isapi.dll in the regedit file and it looks great. everything is just so by the book. where the hell am i going wrong!! can't understand what's different here that was not before coz it was working before!!! did you define any path in the doc_root = in php.ini? because i didn't! Cheers, T. Edison jr. = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- PHP General 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] = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- PHP General 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] HELP!! PHP not working Suddenly!!!
gosh, i just downloaded the new PHP file from www.php.net, the file i downloaded is : *** PHP 4.0.5 [4,590Kb] - 30 April 2001 (CGI binary plus server API versions for Apache, AOLserver, ISAPI and NSAPI. MySQL support built-in, many extensions included, packaged as zip) *** i'm using win98 PWS 4. I did everything by the book. I had succesfully installed was running earlier versions of PHP on my system. i just did this upgrade ka-BOom!! I copied all the DLL's in the DLL folder to my windows/system folder. Copied the php.ini to the windows folder. Did everything with the registry. Making extensions, declaring paths to php.exe, checking the execute box in my PWS! done everything by the book! Then what's wrong. 2 things i didn't do is : 1. did not mention anything in doc_root in php.ini (as i never did before, but used 2 work) 2. did not use the pws-php4*.reg for updating my registry (as i do it manually. I did try this but it doesn't make a different) 3. first i copied the new browscap.ini to my system, it didn't still work...so i brought back my original and it still doesn't work!!! I don't know what to do please somebody help!!! T. Edison jr. = Rahul S. Johari (Director) ** Abraxas Technologies Inc. Homepage : http://www.abraxastech.com Email : [EMAIL PROTECTED] Tel : 91-4546512/4522124 *** __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- PHP General 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]