PHP - Username@domain Emails For All Profiles On The Social Network Site?

 So I would like it as a custom script or as a wordpress plugin.

The features a


I would like to build a social network.
The main to features I’m interested in:
1. Member can join only by invitation. The person that invites another person must write a review about the invited person, add a photo, what he does, share the name and contact: email, phone, city, connected to ( until here all these is mandatory in order for the person to join the network ) and website link ( optional ).
Only then the person that is invited will receive an email with a link from where to register his account. ( this only for members that will have the right to invite others. For the other type only the admin has the right to make it from just a member, a member with invitation rights. In this case the member will receive an email with a link registration ).
The review of a member can be edited only the member who introduced that person in the network ( and the admin ). In case of any edit there will be a notification for the admin with the original version and the new version. The admin of the site has to allow the modification in order for the review to change.
2. The person that is already in the network can invite a number of … ( this will be fixed and determined by the admin. However the admin can raise the number of invitation for a particular member at his will ). This applies for the 2 types of invitations.
There will be 2 types of invitations: to join the network and have the right to invite others OR only member ( no right to invite others ).
When a person registers to the network, the one who invited him will have one less invitation for the type of member he introduced ( member with invitation rights or member ).
If a member wants to invite more people than his invitation are, then it can purchase invitations ( both types ) for different prices ( example: 1 invitations 10$, 2 invitations – 40$ - value determined by the admin ). So a payment integration is needed ( Paypal ).
The exception for all this: if a visitor wants to join the network without any invitation he can only pay his way in. However this option will be displayed on the public pages. After payment confirmation the visitor can be redirected to the register page. Admin will make the account active. A sign “paying member” will be shown on this member profile page.

After a member is registered and logs in to his account will have the right to:
- Add more photos
- Add more website links
- Add more details at his contact information
- Change his unique number.
- Have the option to add members ( both types )
- Add updates to his wall.
- Search and contact other members via email.
So once you log in to the account there is no restriction ( within the network ) or no difference from what you can do on other social sites.

Search:
First the search will be done in the reviews and after that on the post that members made.
The search results will be displayed in the same order ( the words from the reviews will have priority and after that will be displayed the content from posts – that will be arranged in chronologic order – last one will be the first ).
But a member can filter those results – review only or posts only.
Sponsored bids will be displayed first.

The handshake section:
Here you will be notified if one of your “looking for” or “offering” announces has expired. When expired the announcement can’t be find on searches or on your profile page.
The notification will be active for 7 days. By active I mean: if you click the notification it will take you to the announcement and there you will have an option – make active ( so that other can find the announcement in their searches or in your profile ) another 30 days.

The Admin section:
The site will be default “no robots” ( not indexed by search engines ). However an option should be in the admin to switch from off “no robots”. This option will apply only for the internal part – profile pages. The pages and link on the first page ( what is public ) can be indexed by search engines.
A simple editor from where you can create pages ( something like the section pages in Wordpress ). Any page you create will appear on the first page.
After a period of time a member with invitation rights will receive invitation. Example: after one year you will have an extra one invitation for both types of member. What is needed in the admin: a section from where you can modify this time ( time should be in months and the admin will enter the number – example if he puts 1 – that means after 1 month will receive invitation. There should be 2 sections: one time for members that can invite, and one for members only ).
A section where you can limit the number of entries for “looking for” and “offering”
The section from where you can edit the html code.
An option to send newsletters.
You will receive and email if another person contacted you via internal email section.
Option to delete members.
 

I am creating a simple social network, and i want the post visible only on its circle of friends but the problem is...
let say user_a, user_b, user_c already registered and user_a and user_c connected/friends already and all their posts and comments are visible on their circle
but when user_b write a post oh his wall, it's also visible to user_a and user_c which i dont want to happen. I dont know what was wrong on codes below.
 
CREATE TABLE IF NOT EXISTS `user`(
    `uid` INT(11) AUTO_INCREMENT PRIMARY KEY NOT NULL,
    `uname` VARCHAR(25) NOT NULL,
    `pword` CHAR(60) NOT NULL,
    `fullname` VARCHAR(30) NOT NULL,
    INDEX(`uname`)
) Engine = InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;

CREATE TABLE IF NOT EXISTS `friend`(
    `fid` INT(11) AUTO_INCREMENT PRIMARY KEY NOT NULL,
    `friend_id` INT(11) NOT NULL,
    `my_id` INT(11) NOT NULL,
    `stat` ENUM('0','1') NOT NULL,
    INDEX(`friend_id`, `my_id`),
    FOREIGN KEY(`friend_id`) REFERENCES `user`(`uid`)
    ON UPDATE CASCADE
    ON DELETE CASCADE
) Engine = InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;

public function viewFriendIfExistOnTbl($uid)
    {
        $query = $this->mysqli->query("SELECT `friend_id` FROM `friend` WHERE `my_id` = '$uid' LIMIT 1");
        if ($query->num_rows > 0) {
            return true;
        }
    }
 

Hi phpfreaks members,

I got a little social network website, http://www.tranceprofile.com

I got a php script for members to log in to my website.
When they are logged in they can view there own profile and edit it.

I got my login script on two places, http:www.tranceprofile.com/login.php
and my index.php page.

Well here is my problem: When they log in they are send to my index.php page as a logged in user.
I want them to be redirected to the http://www.tranceprofile.com/profile.php page.

I hope you guys can help me out!

Best regards, Mitch Oosterhuis.

Login script:

<table width="400" align="center" cellpadding="6" style="background-color:#FFF; border:#666 1px solid;">
  <form action="login.php" method="post" enctype="multipart/form-data" name="signinform" id="signinform">
    <tr>
      <td width="23%"><font size="+2">Log In</font></td>
      <td width="77%"><font color="#FF0000"><?php print "$errorMsg"; ?></font></td>
    </tr>
    <tr>
      <td><strong>Email:</strong></td>
      <td><input name="email" type="text" id="email" style="width:60%;" /></td>
    </tr>
    <tr>
      <td><strong>Password:</strong></td>
      <td><input name="pass" type="password" id="pass" maxlength="24" style="width:60%;"/></td>
    </tr>
  <tr>
      <td align="right">&nbsp;</td>
      <td><input name="remember" type="checkbox" id="remember" value="yes" checked="checked" />
        Remember Me</td>
    </tr>
    <tr>
      <td>&nbsp;</td>
      <td><input name="myButton" type="submit" id="myButton" value="Sign In" /></td>
    </tr>
    <tr>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <td colspan="2">Forgot your password? <a href="forgot_pass.php">Click Here</a>
  <br /></td>
    </tr>
    <tr>
      <td colspan="2">Need an Account? <a href="register.php">Click Here</a><br />        <br /></td>
    </tr>
  </form>
</table>

I'm attempting to implement a simple social networking system but at the moment am confused about how to create a multiple query which will display a certain user's friends list.

The database contains four tables, the two tables that I'm using at the moment at 'usersTable' and 'friendshipsTable' are detailed below.


usersTable           | Table that stores all the user data

UserID         | Default primary key
Forename              |
Surname         |
Username           |
Password              |
Email Address      |


friendshipTable   | Table that stores information about friendships between users

FriendshipID      |  Default primary key
userID_1                |  UserID
userID_2         |  UserID
Status         |  Either Pending or Confirmed.

The user's id is parsed into the url, and then saved into a variable.

blah.com/userprofile.php?id=6

$id = $_GET['id']; 

I am familiar with creating simple queries, but can't quite work out how to set up multiple table queries.

What the query needs to do is to check the userID that is parsed with the url, and then check the friendshipsTable by checking if either the userID_1 or userID_2 field  matches the userID to grab the records from the table where there is a match.

The next step is to check to see if the friendship is 'Confirmed' or 'Pending' and if it is 'Pending' to ignore it. Once the records have then been chosen I need the query to then check the value in either userID_1 or userID_2 that doesn't match userID and then pull the user's username and name from the usersTable so it can be displayed on a webpage.

I've no idea hoe much I may or may not be overcomplicating this, an example of the code that I've got so far for this query can be found below, but that's as far as I've got at the moment.

$displayFriends = mysql_query("SELECT * FROM friendshipTable, usersTable WHERE friendshipTable.userID_1='$id' OR friendshipTable.userID_2='$id' ");

Cheers for any help.

This topic has been moved to mod_rewrite.

http://www.phpfreaks.com/forums/index.php?topic=318858.0

Hi friends,

I need assistance with making russian fonts displayable in the system emails that are being sent to my auction website users. Any reason the russian fonts I have entered below are displayed the way they are. Please also note I am brand new in PHP and simple llingo would be appreciated.
Regards,


<?
## Email File -> email an auction to a friend
## called only from the $item->auction_friend() function!
## File Version -> v6.10

if ( !defined('INCLUDED') ) { die("Access Denied"); }

//$sender_details = $this->get_sql_row("SELECT u.name, u.email FROM " . DB_PREFIX . "users u WHERE u.user_id='" . $user_id . "'");

$send = true; // always sent;

## text message - editable
$text_message = 'Dear %1$s,

Your friend, %2$s, has forwarded an auction, posted on %3$s for you to look at.

To view the details of the auction, please click on the URL below:

%4$s

Additional comments: %5%s
Best regards,
The %6$s staff';

## html message - editable
$html_message = 'Дорогой (ая) %1$s, <br>
<br>
Ваш друг, %2$s, отправил на Ваше рассмотрение Аукцион, выставленный на %3$s. <br>
<br>
[ <a href="%4$s">Нажмите здесь</a> ] чтобы просмотреть этот Аукцион. <br>
<br>
Дополнительные комментарии: %5$s <br>
<br>
С Уважением, <br>
%6$s
<br>
<br>
<br>
Dorogoy (aya) %1$s, <br>
<br>
Vash drug, %2$s, otpravil na Vashe rassmotreniye Auktsion, vistavlenniy na %3$s. <br>
<br>
[ <a href="%4$s">Najmite zdes</a> ] chtobi prosmotret etot Auktsion. <br>
<br>
Dopolnitelniye kommentarii: %5$s <br>
<br>
S Uvajeniyem, <br>
%6$s';


$auction_link = process_link('auction_details', array('name' => $item_details['name'], 'auction_id' => $item_details['auction_id']));

$text_message = sprintf($text_message, $friend_name, $sender_name, $this->setts['sitename'], $auction_link, $comments, $this->setts['sitename']);
$html_message = sprintf($html_message, $friend_name, $sender_name, $this->setts['sitename'], $auction_link, $comments, $this->setts['sitename']);

send_mail($friend_email, 'Проверьте этот Аукцион', $text_message,
   $this->setts['admin_email'], $html_message, $sender_name, $send);
?>

ISSUE.
A User enters information into a form.
If the 'username' is already taken, a 'message' in Red and with larger font-size will be returned, for example,
"The username $username already exists."
If the username is 'mattd' then the message should say, "The username mattd already exists."

Within my php application, I have included 'inline html'.
Here is part of the code:   ....
if (mysql_num_rows($query_run)==1) {
// it will never = more than one because only
//one user will or will not exist
?>

<html>
</body>
<h1><font color="#FF0066">The username <?php echo $username; ?>already exists.</h1>
</body>
</html>

<?php
}else{
//start the registration process
$query = "INSERT INTO `Names` VALUES
....   1. At one point I did get this: "The username mattd already exists."
2. But now I only get "The username already exists."
I am not retrieving the $username variable.
  This screenshot is found he
http://imgur.com/lIwLZ1G


thanks.

While we're on the subject, is there a way to ensure that the first letter of a name is captalized, and the rest lowercase?  Or is this best handled later on, when the name is being used and called from the DB.

PS: some of us comment are code as to WHAT we are doing because we're just not that good yet, and we need to explain it to ourselves.

Hi folks, I had a working, editable profile but it wasn't visible to other users.  So I'm trying to make that conversion now.  Here's the current 'myprofile' code:
<?php

session_start();

include('config.php');
include('date.php');

$id = $_GET['id'];
$sql = mysql_query("SELECT * FROM members WHERE id = '$id' LIMIT 1");
$check = mysql_num_rows($sql);
$check = mysql_query($sql_user_verify) or die('Cannot Execute:'. mysql_error());

if ($check > 1)
{
echo "No one matches that id number!";
exit();
}


if($check == 1)
{
while($row = mysql_fetch_array($sql))
{


$user = $id;


echo "<h2>Profile</h2>
<table>";

$row = mysql_fetch_array($sql);
echo "<tr><th>ID#:</th><td>".$user."</td></tr>
    <tr><th>Name: </th><td>".$row['callname']."</td></tr>
<tr><th>Email: </th><td>".$row['email']."</td></tr>
<tr><th>Password: </th><td><input type='password' value='".$row['password']."' disabled='true' /></td></tr>
<tr><th>Registered: </th><td>".$row['registered']."</td></tr>
    <tr><th>Last Login: </th><td>".$row['lastlogin']."</td></tr>";
 
echo "</table><br />";
  }
  
  if($id = $_SESSION['id'])
  {
  echo "<h2>Profile</h2>
<form method='post' action='editprofile.php'>
<table>";

$row = mysql_fetch_array($sql);
echo "<tr><th>ID#:</th><td>".$user."</td></tr>
    <tr><th>Name: </th><td>".$row['callname']."</td></tr>
<tr><th>Email: </th><td>".$row['email']."</td></tr>
<tr><th>Password: </th><td><input type='password' value='".$row['password']."' disabled='true' /></td></tr>
<tr><th>Registered: </th><td>".$row['registered']."</td></tr>
    <tr><th>Last Login: </th><td>".$row['lastlogin']."</td></tr>";
 
echo "</table><br />
<input type='submit' value='edit profile' />
</form>";
  }
  }
  
  else {
  die (); 
  }
 ?>
 <?php

include('footer.php');

?>

Here's the link to the user's own profile:
<a href=myprofile.php?id='.$id.'>Profile</a>

And here's the edit profile link, which works fine:
<?php

include('config.php');
include('date.php');
 
if(isset($_POST['btnedit'])){
$callname = $_POST['callname'];
$email = $_POST['email'];
$password = $_POST['password'];
 
$sql = mysql_query( "UPDATE users SET callname='".$callname."', email='".$email."', password='".$password."' WHERE id='".$_SESSION['id']."'" );

if($sql){
echo "<script>alert('profile updated');window.location='myprofile.php'</script>";
}else{
echo "<script>alert('updating profile failed!');</script>";
}
 
}
 
 
 
 
$sql = mysql_query( "SELECT * FROM users WHERE id='".$_SESSION['id']."'" ); 
$row = mysql_fetch_array($sql);

$userfinal = $_SESSION['id'];

$user = $userfinal;

echo "<h2>Edit profile</h2>
<form method='post'>
<table><tr><th>ID#:</th><td>".$user."</td></tr>
<tr><th>Name:</th><td><input type='text' name='callname' value='".$row['callname']."'/></td></tr>
<tr><th>Email:</th><td><input type='text' name='email' value='".$row['email']."'/></td></tr>
<tr><th>Password:</th><td><input type='password' name='password' value='".$row['password']."'/></td></tr>
<tr><th>Registered:</th><td>".$row['registered']."</td></tr>
<tr><th>Last Login:</th><td>".$row['lastlogin']."</td></tr>
</table><br />
<input type='submit' name='btnedit' value='update' />
</form>";
 
 
 ?>
 <?php

include('footer.php');

?>

It fails, it says the query was empty, even though there are user accounts created and information is being stored (as it worked fine before I tried editing the code to make it public.  What am I doing wrong?

Hi, for my coursework i need to make a microblogging website, similar to that of Twitter

I have created a MySQL Database, and also the login and registration forms
I am able to log in as a user and also change user submitted information i.e. Name, About Me etc

The problem i am having is that when i access the logged in users profile page e.g. John Doe, i can access it fine
However, when i wish to access say James Smith or any other user, i am redirected back to John Doe's profile

login.php
Code: [Select]
$query = mysql_query("SELECT * FROM users WHERE username = '$user'") or die(mysql_error());
      $login = mysql_fetch_array($query);
     
      if(md5($pass) == $login['password'])
      {
         $_SESSION['user'] = $login['id'];
         header("Location: home.php");   
      }

home.php
Code: [Select]
<?php
include ('includes/connect.php');
session_start();

$query = mysql_query("SELECT * FROM users WHERE id = " . $_SESSION['user'] . "");
$user = mysql_fetch_assoc($query)

?>


<a href="profile.php?id=<?php echo $user['id']; ?>"> Profile | </a>


users.php
Code: [Select]
<?php
include ('includes/connect.php');
session_start();

$query = mysql_query("SELECT * FROM users WHERE id = " . $_SESSION['user'] . "");
$user = mysql_fetch_assoc($query)

?>

<?php
$members = mysql_query("SELECT * FROM users");
while($allusers = mysql_fetch_assoc($members))
{
   echo
   "<table>
    <tr>
    <td>
    <a href=\"profile.php?id=" . $allusers['id'] . "\">" . $allusers['fullname'] . "</a>     </td>
    </tr>
    </table>";   
}

?>

In all honesty i do know that the fault lies with the $_SESSION bit of the code since everything i do will only access the profile of the user who is logged in

However i dont know how i am able to allow the logged in user to access their own profile as well as view other people's profile.



Another problem is how do i follow users?
I have a table called 'follow'
I have two columns, user_id and follower_id, both being foreign keys

However i honestly dont understand how to use PHP code to make users follow each other

If anyone could assist me with any part of this i would be very grateful


Thank You

Ok, so I need to know how I can get these codes to interact and work to update multiple rows/columns in a database. 

this code is what pulls the query and displays info(it displays fine):
Code: [Select]
<?php
if (isset($_POST['submitted'])) {
include('connect1.php');
$category = $_POST['category'];
$criteria = $_POST['criteria'] ;
$query = ("SELECT name, badges, rank, userid FROM members WHERE $category LIKE '%".$criteria."%'");
$result = mysqli_query($dbcon, $query) or die('error getting data');
$num_rows = mysqli_num_rows($result);
echo "$num_rows results found";
echo "<table width=\"896\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">";
echo "<tr bgcolor=\"#F7E496\"><td bgcolor=\"#F7E496\"><strong>name</strong></td><td bgcolor=\"#F7E496\" ><strong>Merit Badges</strong></td><td  bgcolor=\"#F7E496\"><strong>Rank</strong></td><td bgclor=\"#F7E496\"></td></tr>";
while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) {$color = ($color == 'white')?'#fffccc':'white';
echo "<tr bgcolor='$color'><td>
";
echo $row['name'];
echo "
</td><td>
<form action=\"scout.php\" method=\"post\">
<input type=\"text\" name=\"userid\" id=\"userid\" value='".$row['userid']."'>
  
    <textarea name=\"badges[]\" id=\"badges\" cols=\"40\" rows=\"3\" type=\"textarea\">".$row['badges']."</textarea></td><td>
    <span class=\"adfa\"> 
    </span>
   
  
  <select name=\"rank[]\" id=\"rank\">
    <option value=\"Scout\">Scout</option>
    <option value=\"Tenderfoot\">Tenderfoot</option>
    <option value=\"Second Class Scout\">Second Class Scout</option>
    <option value=\"First Class Scout\">First Class Scout</option>
    <option value=\"Star Scout\">Star Scout</option>
    <option value=\"Life Scout\">Life Scout</option>
    <option value=\"Eagle Scout\">Eagle Scout</option>
    <option value=\"\" selected=\"selected\">".$row['rank']."</option>

</td><td>";



}
echo "</td></tr>";

echo "</table>";

echo "<input type=\"submit\" name='submit[]' id=\"submit\" value=\"Save\" />

</form>";

}
?>
and this code is what is supposed to update the database:
Code: [Select]
          if ($_POST[submit]){
  foreach ($_POST[rank] as $key => $value) {
       
       $badges = $_POST['email1'][$key];
       $userid1 = $_POST['userid'][$key];
             
   
   
  $q =  "UPDATE members SET badges='$badges', rank='$rank' where userid='$userid1'";
$sql = mysql_query($q) or die("Problem with the query: $q<br>" . mysql_error());
printf("Records updated: %d\n", mysql_affected_rows());}
 


exit();
} // close if post
again, I am really new to arrays and don't know If i am using them right here.........

Hey guys,

Im trying to get a page to update profiles working and have been unsuccessful.  Its a basic form with a server.php to process the updates.  

Server.php

  $username = mysqli_real_escape_string($db, $_POST['username']);
  $email = mysqli_real_escape_string($db, $_POST['email']);
  $password_1 = mysqli_real_escape_string($db, $_POST['password_1']);
  $password_2 = mysqli_real_escape_string($db, $_POST['password_2']);
  $location = mysqli_real_escape_string($db, $_POST['location']);
  $class = mysqli_real_escape_string($db, $_POST['class']);
  $id = mysqli_real_escape_string($db, $_POST['id']);

  if (empty($username)) { array_push($errors, "Username is required"); }
  if (empty($email)) { array_push($errors, "Email is required"); }
  if (empty($password_1)) { array_push($errors, "Password is required"); }
  if ($password_1 != $password_2) {
	array_push($errors, "The two passwords do not match");
  }

  if (count($errors) == 0) {
  	$password = password_hash($password_1, PASSWORD_DEFAULT);

  	$query = "(UPDATE accounts SET password='".$password."', username='".$username."', email='".$email."', role='".$role."', class='".$class."' )";
  	mysqli_query($db, $query);
  	$_SESSION['username'] = $username;
  	$_SESSION['success'] = "Update Successful for user: " . $username;
  	header('location: index.php');
  }
}

update.php

<?php
session_start();

if (!isset($_SESSION['loggedin'])) {
    header('Location: ../login.php');
    exit();
}

if($_SESSION['class'] == 'user') {
    // Jump to user page
    header('Location:../user/home.php');
}
?>


<html>
<head>
<meta name="viewport" content="width=device-width, initial-scale=1" /> 
  <title>New User Registration</title>

  <link rel="stylesheet" type="text/css" href="../css/style.css">
  <link href="../css/navbar.css" rel="stylesheet" type="text/css">
  
</head>
<body>

<?php include "../assets/navbar.php" ?>


  <div class="header">

  	<h2>Update User Info</h2>
  </div>
	
  <form method="post" action="server.php" class="form2">
  	<?php include('errors.php'); ?>
	
	
<?php
if (isset($_SESSION['success']) && ! empty($_SESSION['success'])) {
    echo "<div class='success'>" . htmlentities($_SESSION['success']) . "</div>";
    unset($_SESSION['success']);
}
	$id         = $_REQUEST['id'];
	$username 	= $_REQUEST['username'];
	$location 	= $_REQUEST['role'];
	$email 		= $_REQUEST['email'];
	$password	= $_REQUEST['password'];
	$class	    = $_REQUEST['class'];


?>

  	<div class="input-group">
  	  <input type="hidden" name="id" placeholder="<?php echo $id; ?>" value="<?php echo $id; ?>">
  	</div>

  	<div class="input-group">
  	  <input type="text" name="username" placeholder="<?php echo $username; ?>" value="<?php echo $username; ?>">
  	</div>
  	<div class="input-group">

  	  <input type="email" name="email" placeholder="Email Address?" value="<?php echo $email; ?>">
  	</div>
	
	
	
	  	<div class="input-group">
  	 <input list="location" name="location" class="form-control" placeholder="<?php echo $location; ?>" required>
				<datalist id="location">
					<option value="Manny">
					<option value="Nate">
					<option value="Jay">
					<option value="Imran">
					<option value="Sanat">
					<option value="Minahan">


				</datalist>
  	</div>
	
		  	<div class="input-group">

  	 <input list="class" name="class" class="form-control" placeholder="<?php echo $class; ?>" required>
				<datalist id="class">
					<option value="user">
					<option value="admin">
					<option value="disabled">


				</datalist>
  	</div>
	
	
	
  	<div class="input-group">
  	  <input type="password" placeholder="Password" name="password_1">
  	</div>
  	<div class="input-group">

  	  <input type="password" placeholder="Confirm Location" name="password_2">
  	</div>
  	<div class="input-group">
  	  <button type="submit" class="btn" name="reg_user">Update</button>
  	</div>

  </form>



</body>
</html>

 

When I process the update it gives me a success message but the data in the table is not updated at all.  Any suggestions on what im doing wrong here?

ok, so I have this code:
Code: [Select]
<?php
if (isset($_POST['submitted'])) {
include('connect1.php');
$category = $_POST['category'];
$criteria = $_POST['criteria'] ;
$query = ("SELECT name, badges, rank, userid FROM members WHERE $category LIKE '%".$criteria."%'");
$result = mysqli_query($dbcon, $query) or die('error getting data');
$num_rows = mysqli_num_rows($result);
echo "$num_rows results found";
echo "<table width=\"896\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">";
echo "<tr bgcolor=\"#F7E496\"><td bgcolor=\"#F7E496\"><strong>name</strong></td><td bgcolor=\"#F7E496\" ><strong>Merit Badges</strong></td><td  bgcolor=\"#F7E496\"><strong>Rank</strong></td><td bgclor=\"#F7E496\"></td></tr>";
while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) {$color = ($color == 'white')?'#fffccc':'white';
echo "<tr bgcolor='$color'><td>
<input type=\"text\" name=\"userid\" id=\"userid\" value='".$row['userid']."'>";
echo $row['name'];
echo "
</td><td>
<form action=\"scout.php\" method=\"post\">

  
    <textarea name=\"badges\" id=\"badges\" cols=\"40\" rows=\"3\" type=\"textarea\">".$row['badges']."</textarea></td><td>
    <span class=\"adfa\"> 
    </span>

  
  <select name=\"rank\" id=\"rank\">
    <option value=\"Scout\">Scout</option>
    <option value=\"Tenderfoot\">Tenderfoot</option>
    <option value=\"Second Class Scout\">Second Class Scout</option>
    <option value=\"First Class Scout\">First Class Scout</option>
    <option value=\"Star Scout\">Star Scout</option>
    <option value=\"Life Scout\">Life Scout</option>
    <option value=\"Eagle Scout\">Eagle Scout</option>
    <option value=\"\" selected=\"selected\">".$row['rank']."</option>

</td><td>";

echo "<input type=\"submit\" name=\"submit\" id=\"submit\" value=\"Save\" />
";
echo "</form>";


}

echo "</table>";

echo "</td></tr>";
}
?>
and this is the code that does the posting:
Code: [Select]
<?php
session_start(); // Must start session first thing
/*
Created By Adam Khoury @ [URL=http://'http://www.flashbuilding.com/']www.flashbuilding.com[/URL]
-----------------------June 20, 2008-----------------------
*/
// Here we run a login check
if (!isset($_SESSION['id'])) {
echo 'Please <a href="login.php">log in</a> to access your account';
exit();
}
//Connect to the database through our include
include_once "connect_to_mysql.php";
// Place Session variable 'id' into local variable
$userid = $_SESSION['id'];

// Query member data from the database and ready it for display




// Process the form if it is submitted
if ($_POST['submit']) {
$badges = $_POST['badges'];
$userid = $_POST['userid'];
$rank = $_POST['rank'];

$sql = mysql_query("UPDATE members SET   badges='$badges', rank='$rank' WHERE userid='".$_GET['userid']."'");
printf("Records updated: %d\n", mysql_affected_rows())
;


exit();
} // close if post
?>



So what I need to know is how I can make it so that each result has it's user id associated with it......and I can update multiple rows at once according to each userid that is associated..........right now I can only get it to do one if I add on ?userid=".$row['userid']." in the first piece of code.......how can I make it update lets say 78 as soon as I click submit......

PS I know there will be a submit button with each row right now.......I will move it out of the loop later.....

I have two domains both running SSL. Let's call them old-domain and new-domain. old-domain is permanently redirecting traffic to new-domain. There are still a lot of links out there to old-domain with https://. If I were to remove SSL from old-domain but keep SSL on new-domain, I am betting that users will be getting some sort of certificate error. Right? Any way around that if I want to remove SSL from old-domain?

This topic has been moved to the corner of 3rd Avenue and mod_rewrite.

http://www.phpfreaks.com/forums/index.php?topic=359430.0