briankopy
-
Posts
10 -
Joined
-
Last visited
Never
briankopy's Achievements
Newbie (1/5)
0
Reputation
-
I checked that out on MySql.com but didn't really get anywhere, could you elaborate or clarify. Thanks, but still at square 1 here.
-
a little extra info, not sure if necessary fields for customer table: firstname, lastname, city, state, zip, street_address, area_code, phone_number
-
I'm basically trying to make a database administrator interface web page/app... I'm using Wamp server phpMyAdmin MySQL users sign in using a username that they can input into a database called database1 table called users if the user doesn't have an account he can create one by entering username and a password twice they can access another table called customertable and Display, Insert, Modify, Delete Contacts, and Logoff So I basically need a login page and a admin page. Any help would be greatly appreciated.
-
my bad.
-
I really appreciate the kick in the right direction... I have the records all displaying, is there a way to say only show the records with the 'state' field of NY or FL etc. I understand if I've hit my help limit... Thanks.
-
nevermind on that particular issue, case sensitive user name, my bad...
-
Thanks a lot, looks good, but... I received this error Warning: mysql_connect() [function.mysql-connect]:Access denied for user 'user1'@'localhost' (using password: YES) I have my username (user1) and password set up but it is denying me access to the database, any ideas. Thanks.
-
Thanks in advance for reading/any help. I'm basically trying to create a customer request form (.html page) that will activate a .php file that will pull customers from a MySQL database based on their state that the user enters and on a new page display the customers names and phone numbers. I'm a noob, There is probably an elegant solution that I can't figure out, I may have to start over etc. The following is the initial html code that allows the user to type in a two letter state abbreviation and click a button. On that click it will send the state and run "customer_display.php". <html> <head> <title> </title> </head> <body> <form action="customer_display.php" method="post" name="customer_search"> <table width="25%" border="0" cellspacing="2" cellpadding="2" align="center"> <tr> <td>Customer Records</td> <td> </td> </tr> <tr> <td>Single State (optional):</td> <td><input type="text" name="state" size="2" maxlength="2" /></td> </tr> <tr> <td><input type="submit" value="Submit Query" /></td> <td> </td> </tr> </table> </form> </body> </html> Here is all I have for customer_display.php It assigns the state data to a varaible called state... <html><head><title></title></head> <body> <?php $state = $_POST['state']; ?> </body> </html> I have a MySQL database called "database1" with a table called "customertable". The fields that I want to display on a new page after the user clicks the button are firstname lastname area_code phone_number and I would like to give the user the option to pull these records by state. Again any help would be greatly appreciated.
-
sort by last name comma delimited .txt file and display resluts
briankopy replied to briankopy's topic in PHP Coding Help
Thanks a lot man. Seems to be working perfectly, I did have an issue with the text file having a blank line at the end but as soon as I got rid of that smooth sailing... Thanks again for the quick response. -
Ok, I'm a php "noob" so please don't "pwn" me. I have a .txt of conatact info that looks like this... (new line = new entry) Joe , Smith , 123 Fake St. , Springfield , IL. , 60666, 630 , 5882300 Joe , Jones , 123 Fake St. , Springfield , IL. , 60666, 630 , 5882300 Joe , Adams , 123 Fake St. , Springfield , IL. , 60666, 630 , 5882300 I need to output the last name, first name and phone number only in alphabetical order by lastname. Adams, Joe 630-588-2300 Jones, Joe 630-588-2300 Smith, Joe 630-588-2300 any help would be greatly appreciated. Here is what I have so far... (not much) <? $filename = "data.txt"; $fd = fopen ($filename, "r"); $contents = fread ($fd, filesize($filename)) or die("file is empty, please submit data."); fclose ($fd); $fd = fopen ($filename, "r"); $contents = fread ($fd,filesize ($filename)); fclose ($fd); $fp = fopen($filename, "r") or die("failure to open."); while(!feof($fp)) { $line = fgets($fp); list($namefirst, $namelast, $streetaddress, $city, $state, $zip, $areacode, $phone) = explode(",", $line); ?> //thanks again