Welcome Guest.   Make a donation to an author on the site October 30, 2014, 06:39:09 PM  *

Please login or register.
Or did you miss your validation email?


Login with username and password (forgot your password?)
Why not become a lifetime supporting member of the site with a one-time donation of any amount? Your donation entitles you to a ton of additional benefits, including access to exclusive discounts and downloads, the ability to enter monthly free software drawings, and a single non-expiring license key for all of our programs.


You must sign up here before you can post and access some areas of the site. Registration is totally free and confidential.
 
Learn about the DonationCoder.com microdonation system (DonationCredits).
   
   Forum Home   Thread Marks Chat! Downloads Search Login Register  
Pages: [1]   Go Down
  Reply  |  New Topic  |  Print  
Author Topic: IDEA: Simple php directory  (Read 3384 times)
Killeroid
Participant
*
Posts: 8

View Profile Give some DonationCredits to this forum member
« on: January 07, 2008, 01:52:06 AM »

Hello, I am basically looking for a simple script, that will accept user input from a form (these two fields: name/nickname and sip address) and then store it in a mysql database. The script should be able to display the list of users and the sip addresses(25-50 uses a page). Thanks a lot.
Logged
tinjaw
Supporting Member
**
Posts: 1,926



I'm so glad breakbeat techno isn't an illegal drug

see users location on a map View Profile WWW Read user's biography. Give some DonationCredits to this forum member
« Reply #1 on: January 07, 2008, 07:40:23 AM »

There are plenty of websites that would do that for you. Would that meet your needs or does it need to be something you host yourself? In which case, there are plenty of scripts to do that, but they will probably do more than what you need.
Logged

 
Killeroid
Participant
*
Posts: 8

View Profile Give some DonationCredits to this forum member
« Reply #2 on: January 07, 2008, 10:37:56 AM »

It needs to be somthing that i can host.
Logged
tinjaw
Supporting Member
**
Posts: 1,926



I'm so glad breakbeat techno isn't an illegal drug

see users location on a map View Profile WWW Read user's biography. Give some DonationCredits to this forum member
« Reply #3 on: January 07, 2008, 10:49:09 AM »

It needs to be somthing that i can host.
Would a combination of something like phpFormGenerator and phpMyAdmin? Or are you looking for a few lines of custom PHP code to do that and only that?
Logged

 
Killeroid
Participant
*
Posts: 8

View Profile Give some DonationCredits to this forum member
« Reply #4 on: January 07, 2008, 10:59:43 AM »

phpFormGenerator will work for the accepting of data from users and storing it in a mysql database.. I dont know about phpmyadmin (basically, i ust want a script that will access the mysql database and print out and display the list of users and the sip adresses that i collected using the form and stored in the database.). It would be a great bonus if users could also seach through the database and find users by their usernames or voip numbers.
Basically, a phone directory script that lists the names and sip adresses of users and if easily done, also contains a search function so that you can search usng either fields.
Logged
tinjaw
Supporting Member
**
Posts: 1,926



I'm so glad breakbeat techno isn't an illegal drug

see users location on a map View Profile WWW Read user's biography. Give some DonationCredits to this forum member
« Reply #5 on: January 07, 2008, 11:10:26 AM »

That is why I suggested phpMyAdmin. You could just browse the database if you want, or make changes as you need. But if all you need is a phonebook-like directory, the search the PHP script sites on the web for phonebook & mysql. You're bound to find at least a few dozen.
Logged

 
Stoic Joker
Honorary Member
**
Posts: 5,344



View Profile WWW Give some DonationCredits to this forum member
« Reply #6 on: January 07, 2008, 10:25:20 PM »

PHPMyAdmin is a bit heavy just to dump a user list.

This is pipebomb crude but it's about all that's really needed: 
[copy or print]
<table border='1' width='442' cellspacing='1' cellpadding='1' bordercolor='#000000'>
  <tr>
   <td bgcolor='#0065AD' align='center'><b><font face='Arial' size='2' color='#FFFFFF'>User Real Name</font></b></td>
   <td bgcolor='#0065AD' align='center'><b><font face='Arial' size='2' color='#FFFFFF'>User Nickname</font></b></td>
   <td bgcolor='#0065AD' align='center'><b><font face='Arial' size='2' color='#FFFFFF'>User's SIP</font></b></td>
  </tr>
    <?PHP
$q = "SELECT * FROM table_Name LIMIT('$i', 50)";
$qResult = MYSQL_QUERY($q) or die("Invalid query: $q");
while($qRow = MYSQL_FETCH_ARRAY($qResult)) {
Print"<tr>
   <td align='center'><font face='Arial' size='2'>$qRow[Name]</td>
   <td align='center'><font face='Arial' size='2'>$qRow[NIC]</td>
   <td align='center'><b><font face='Arial' size='2'>$qRow[SIP]</td>
  </tr>";
}

$i +=50; // Pass incremented $i back to page for next loop (Block of 50)
?> </table>
Logged
Pages: [1]   Go Up
  Reply  |  New Topic  |  Print  
 
Jump to:  
   Forum Home   Thread Marks Chat! Downloads Search Login Register  

DonationCoder.com | About Us
DonationCoder.com Forum | Powered by SMF
[ Page time: 0.032s | Server load: 0.15 ]