[Resolved] I require assistance please

Maimer1

Hello, I have recently taken it upon myself to learn php. One of the current things which i wish to do is add a member list to a clan site i operate. None of what i have learned (very little) has taught me how to do this. Basically i want to create a login form in php page that when accessed allows the user to add names to a list which is accessed from the database by a page which displays the list for all to see.

I have everything ready except the script. I require this script because i am the only of 3 people who can add to this list, but everytime they want it added to they have to tell me, i have to open up frontpage and add the name to list. This is very annoying, so if someone can point me to a script or even write one i would be gracous. The only php think i can do is print a line, but i shall persue this further incase i get no response.

The clan site is located at http://www.afh-aa-clan.tk for anyone interested, the only sections in php are the news which is from oxynews.

Maimer1

i know my topic name is vague and is often shunned but i couldnt think of anything

vaska

generally, people write code for other people who try, at least, to write some code first...if you just want advice, then that's another story...

you need a login system...separately, you need a way to display the names of the members...

this is a really nice tutorial to create a login system, protect your site...and then you could create a script to display all the members...

http://www.sitepoint.com/article/319

when you have some code to play with i'm pretty sure people will be very happy to lend you some tips...

good luck...vsaka

Maimer1

I have been attempting to, i have experience in VB but that would only help in knowing what a function might do. Ive been looking at how you upload to a database mainly, just for the password and username. Maybe i can manually insert the username and password into the database and then have the script query it and check to see if my form entries match the targeted database entries.

I know how to do it kinda but not how to write teh script, ill continue:

After the user is sucessfully in id have a single form where the user would type in the users name and then click 'Add', this would then add the Entered data into the database under a certain table. And every time the member page is visited it queries the database under that table and adds every entry as a string.

So for the download from the database would i just set a variables value to the next entry in the database and print that variable? or do i do this with another method?

pretty sure this is how it would look:

<? Print "(var1)<sb>"; ?> with or without the line break

vaska

actually, i don't really understand what you are trying to do...

if they are already in a "members" database, why would they need to re-enter anything?

i'm sorry, but i might have give you some bad advice up above as i don't really get the gist of this...vaska

Maimer1

What im trying to create is a passworded page containing a form which allows the logged in user to add member names to the database.

These member names are then accessed by the member page on the website where they are viewed.

I dont have them in the database yet, what i meant was inserting the username and password manually instead of creating a signup page.

I need this script because im the webmaster for a clan which has multiple people eligable to add members to the clan. But since im the only one that understands my site or knows how to avoid messing it up i dont give them ftp access, this is also because this is not the only site i have running. So by creating this i can allow them to add to the list without possibly messing up my layout or site.

My intents for the site are quite ambitious, i hope to eventually have a fully php site with nearly completely customizable content.

Maimer1

Here is the code im trying to create to add the members to the database. Ignore the **** i replaced the password with.

<html>
<body>
<form>
<table border="0" cellpadding="0" cellspacing="5">
    <tr>
        <td align="right">
            <p>Member name</p>
        </td>
        <td>
            <input name="newname" type="text" maxlength="100" size="25" />
        </td>
    </tr> 
   <tr> 
       <td align="right" colspan="2"> 
           <hr noshade="noshade" /> 
           <input type="submit" name="submitok" value="   OK   " /> 
       </td> 
   </tr> 
</form>
<?php
mysql_connect("localhost","maim","****");
mysql_select_db (maim);
if (!isset(['submitok'])):
$query = "INSERT INTO database(['newname'])
VALUES('['newname']')";
$result = mysql_query($query);
echo 'Name Entered.';
?>
</body>
</html>

stolzyboy

 <html> 
<body>
<?php
if (!isset($_POST['submitok']))
{
?>
<form action="<?php echo $_SERVER['PHP_SELF']; ?>"method="post"> 
<table border="0" cellpadding="0" cellspacing="5"> 
    <tr> 
        <td align="right"> 
            <p>Member name</p> 
        </td> 
        <td> 
            <input name="newname" type="text" maxlength="100" size="25" /> 
        </td> 
    </tr> 
   <tr> 
       <td align="right" colspan="2"> 
           <hr noshade="noshade" /> 
           <input type="submit" name="submitok" value="   OK   " /> 
       </td> 
   </tr> 
</form> 
<?php 
}
else
{
$conn = mysql_connect("localhost","maim","****"); 
$db = mysql_select_db ("maim"); 
$newname = $_POST['newname'];
$query = "INSERT INTO tablename(newname) values ('$newname');";
$result = mysql_query($query) or die(mysql_error()); 
echo $newname . " entered successfully"; 
}
?> 
</body> 
</html>

Maimer1

hey thanks it worked, just checking the database for the entry

stolzyboy

if it didn't work, it should have told you since i added the mysql_error() line

and if it did, mark this thread resolved with the link at the bottom

Maimer1

i got it working, had to change some DB stuff.

I just need to password the page and get the member page to display the members

ill work on passwording it right now'

EDIT: for the password ill just add the code into the bottom of the news script

EDIT2: passwording is done, figuring out the member page

Maimer1

I have successfully gotten it to work. im marking it as resolved now

Thanx all that helped