Learn VBA & Macros in 1 Week!

PHP - Unique User Stored Information

Full Excel VBA Course - Beginner to Expert

Unique User Stored Information	View Content

Okay, so I have a database with user log on info, and unique ID's. How to I allow the user to save info from a form, and be able to log out and come back and log on to see/edit that info.

Thanks!

Full Excel VBA Course - Beginner to Expert

All Image Information Gets Stored In The Database Except For The Last 2

Similar Tutorials

View Content

Hi Everyone,

I have a program that generates 200 unique images keeping the first image static in each run.The images keep scrolling on to the screen pause for 3 seconds and scroll off I'm able to generated all 200 unique images without repetition, everything is working well except for the lase two images the last two images are scrolling on to the screen but are not been displayed in the database, Moreover The last image is a duplicate of 197th image.I don't know what is happening.....

Here is MY code..........

<?php
      session_start();
      $sid = $_SESSION['id'];
      $_SESSION['imageDispCnt'] = 0;
$myQuery = "SELECT * from image";
$conn = mysql_connect("localhost","User","Passwd");
mysql_select_db("database_Name",$conn);
$result = mysql_query($myQuery);
$img =Array();
$id =Array();
$i =0;
$imagepath = 'http://localhost/images/';
while ($row = mysql_fetch_array($result))
     {
     $img[$i] = $imagepath.$row['img_name'];
     $id[$i] = $row['imageid'];
     $i = $i + 1;
}
?>
      </head>
      <script language="JavaScript1.2">
var scrollerwidth='800px';
var scrollerheight='600px';
var scrollerbgcolor='white';
var pausebetweenimages=3200;
var s;
var sec;
var d;
var j;
var imgid;
var milisec = 0;
var seconds = 0;
var flag = 1;
var ses_id = '<?php echo $sid;?>';
var count = 0;
var i = 0;
var imgname;
var imgid;
var k =0;
var slideimages=new Array();
var img_id = new Array();
var index;

<?php
$l =0;
$count = array();
   $j = rand(0,199);
   while($l < 200)
   {
    while(in_array($j, $count))
{
   $j = rand(0,199);
}
$count[$l] = $j;
$l++;

}?>
<?php
$k = 0;
for($k = 0;$k<count($count);$k++){
?>
index = <?php echo $k;?>;
<?php
        $indx = $count[$k];?>
if(index == 0){
     slideimages[0] = '<img src="http://localhost/images/hbag044.jpg" name="r_img" id="0"/>';
     img_id[0] = '<input type="hidden" value="0" id="imgId" />';
}

else if(index > 0)
{
    slideimages[<?php echo $k?>] = '<img src="<?php echo $img[$indx]?>" name="r_img" id="<?php echo $id[$indx]?>"/>';
img_id[<?php echo $k?>] = '<input type="hidden" value="<?php echo $id[$indx]?>" id="imgId" />';
}
<?php
}
?>

Can Any one plese help me

Appreciate your help...

Thanks

Want To Display Additional Information Of Registerd User While Uploading The Products Of Same User

Similar Tutorials

View Content

hi,

i have made a website where people resgister their details of them and products.

they have to enter the following details in form

Name of company

name of the product

company address

email id

password

mobile number contact

and

brief details about their company

after filling all details user is registered on website.

user can then login with email id and pwd.

now after login ..user will get a page where he can upload the photos of products images and their price, so now my question is that when he finishes uploading (|by clicking on upload button) the product images and price text box ..then on final uploaded webspage it should show all other things which he registerd before (company name , mobile number etc) along with images and price...hence the main question that user does not need to enter mobile and address while uploading images and filling proce ..but on the final page it should show mobile and address along with price and images..as user is not going to enter mobile and address again and again as he will have multiple products to upload.

thanks in advance .

Using An Authcode Stored In A Cookie To Automatically Log A User In.

Similar Tutorials

View Content

I am trying to create a remember me checkbox for the login of my CMS.

What I am trying to achieve is that whenever a user logs in with the checkbox ticked and auth code is created and stored in a cookie and also the database under their user info row. When I user closes their browser without logging out and then returns to the CMS a few days later etc I am trying to run some code straight away if they get redirected to the login page. The code will check to see if the auth code cookie exists, if it does it gets checked against the database records, if a match is found then log that user in. If it doesn't do nothing until the user uses the login form.

I have written what I though was the perfect solution but it never seems to automatically log the user in, even if they haven't logged out. Some direction in this matter would be very helpful, thank you.

I would also like to know if there is a way of using php to stop my session getting cleared by the trash collector after some inactivity?

Login.php (I am using PHpass for the password hashing)

Code: [Select]
<?php include ('functions.php'); ?>
<?php get_header('login'); ?>
<div id="login-result">
<?php
$redirect = htmlspecialchars(mysql_real_escape_string(addslashes($_GET['redirect'])));

if(isset($_COOKIE['authcode'])){

connect();

$authcookie  = htmlspecialchars(mysql_real_escape_string(addslashes($_COOKIE['authcode'])));

$sql         = "SELECT uid, username, firstname, lastname, role FROM usersT WHERE authcode='$authcode'";
$result      = mysql_query($sql);
$count       = mysql_num_rows($result);
$row         = mysql_fetch_array($result);

$uid         = $row['uid'];
$username    = $row['username'];
$fname       = $row['firstname'];
$lname       = $row['lastname'];
$role        = $row['role'];


if($count==1){
$sql2    = "UPDATE usersT SET status = '1' WHERE uid = '$uid'";
$result2 = mysql_query($sql2);

if($result2){

session_register("uid");
session_register("uname");
session_register("ulevel");
$_SESSION["uid"]       = $uid;
$_SESSION["username"]  = $username;
$_SESSION["uname"]     = $fname;
$_SESSION["ufullname"] = $fname . " " .$lname;
$_SESSION["urole"]     = $role;

if(!empty($redirect)) {
header( 'Location: '. $redirect ) ;
exit();
}
else {
header( 'Location: index.php' ) ;
exit();
}

}

}

}
?>
<?php
if (isset($_POST['admin_login'])){

if(isset($_POST["username"]) && isset($_POST["password"])){

connect();

$username_p        = htmlspecialchars(mysql_real_escape_string(addslashes($_POST["username"])));
$password_p        = htmlspecialchars(mysql_real_escape_string(addslashes($_POST["password"])));

if (strlen($password_1) < 73) {

//Password hashing

$sql3          = "SELECT password FROM usersT WHERE username='$username_p'";
$result3       = mysql_query($sql3);
$row3          = mysql_fetch_array($result3);

require("inc/password-hash.php");
$hasher        = new PasswordHash(8, false);
$stored_hash   = "*";
$stored_hash   = $row3['password'];
$check         = $hasher->CheckPassword($password_p, $stored_hash);

if($check){

$sql4      = "SELECT uid, username, firstname, lastname, role FROM usersT WHERE username='$username_p'";
$result4   = mysql_query($sql4);
$row4      = mysql_fetch_array($result4);

$uid       = $row4['uid'];
$username  = $row4['username'];
$fname     = $row4['firstname'];
$lname     = $row4['lastname'];
$role      = $row4['role'];

$authcode  = random(30);
$sql5      = "UPDATE usersT SET status = '1', authcode = '$authcode' WHERE uid = '$uid'";
$result5   = mysql_query($sql5);

if($result5){

session_register("uid");
session_register("uname");
session_register("ulevel");
$_SESSION["uid"]        = $uid;
$_SESSION["username"]   = $username;
$_SESSION["uname"]      = $fname;
$_SESSION["ufullname"]  = $fname . " " .$lname;
$_SESSION["urole"]      = $role;

if(isset($_POST['remember'])) {
setcookie("authcode", $authcode, time() + 86400 * 365 * 2);
} // Check if the user wants to be remembered.

if(!empty($redirect)) {
header( 'Location: '. $redirect ) ;
exit();
} // Check if the user has been redirected from another page.
else {
header( 'Location: index.php' ) ;
exit();
}

} // Check if the users status has been updated.
else {
echo "<div class=\"error rounded5 shadow\">User status couldn't be updated!</div>";
}

} // Check the entered password against the stored hash.
else {
echo "<div class=\"error rounded5 shadow\">Invalid username or password!</div>";
}

} // Checked the character length of the password.
else {
echo "<div class=\"error rounded5 shadow\">Password must be 72 characters or less!</div>";
}

} // Check both fields have been filled in.

} // Check the user has submitted the data.

?>
</div>
<div id="login" class="rounded5 shadow">
<form name="loginform" id="loginform" action="<?php $_SERVER['PHP_SELF']; ?>" method="post">
<p>
<label for="username">Username<br>
<input type="text" name="username" id="username" class="rounded5" value="<?php echo $username_p; ?>" size="20" tabindex="10" /></label>
</p>
<p>
<label for="password">Password<br>
<input type="password" name="password" id="password" class="rounded5" value="<?php echo $password_p; ?>" size="20" tabindex="20" maxlength="72" /></label>
</p>
<p class="submit">
Keep me logged in <input type="checkbox" name="remember" id="remember" <?php if(isset($_COOKIE['remembered'])){ echo "selected=\"selected\""; } ?> /><br /><br /><a href="" class="left">Lost your password?</a>
<input type="submit" name="admin_login" id="admin_login" class="btn rounded10 right" value="Log In" tabindex="100" />
</p>
<div class="cleaner"></div>
</form>
</div>
<?php get_footer('login'); ?>

Logout.php

Code: [Select]
<?php
session_start();
include ('functions.php');
connect();
$uid    = mysql_real_escape_string($_SESSION['uid']);
$sql    = "UPDATE usersT SET status = '0', authcode = '' WHERE uid = '$uid'";
$result = mysql_query($sql);

if($result) {
session_unset();
session_destroy();
setcookie("authcode", $authcode, time() - 86400 * 365 * 2);
header("location:" . get_option('home') . "/login.php");
exit();
}
else {
exit();
}
?>

Redirect Code

Code: [Select]
<?php
session_start();
$url   = (!empty($_SERVER['HTTPS'])) ? "https://".$_SERVER['SERVER_NAME'].$_SERVER['REQUEST_URI'] : "http://".$_SERVER['SERVER_NAME'].$_SERVER['REQUEST_URI'];
$uid   = $_SESSION['uid'];
if (!isset($uid)) {
header('location:login.php?redirect='.$url);
exit();
die();
}
?>

Website User Log On, Check Password Stored On Sql Database.

Similar Tutorials

View Content

Hi all,

I've got a website for an event, each team have their details on a page which are recalled from a SQl database.

But I'm wanting to create a password input box for each team, so when they enter the correct password they are taken to a page containing forms where they can edit the team details.

Here is the page with the users details on where they anter the password: http://www.wharncliffenetwork.co.uk/wrc/entered/team.php?id=8

I'm not sure how to code it, Can an IF statement be used? Anyone got any pointers? I'f been unsuccessful in finding a tutorial or something similar.

Hope that makes sense :S Cheers.

1 Unique Site Per User

Similar Tutorials

View Content

the code im running is
Code: [Select]
$result = mysql_query("SELECT count(*) FROM slinks where approval='1'");
$do = mysql_fetch_row($result);
$random = mt_rand(0,$do[0] - 1);
$result = mysql_query("SELECT * FROM slinks LIMIT $random, 1"); The above is finished off into a iframe
Code: [Select]
<iframe src="<?php while ($row = mysql_fetch_array($result)){ print $row["url"];}?> "frameborder="0" width="100%" height="100%" name="surfing"id="dframe"></iframe>resulting in a random site loaded ever time the php file is ran
now all i need to figure out with a little help from the great users at phpfreaks is how i can get the random site to only be ran one time per user.

example
click = randomsite1.com
click = randomsite2.com
click = randomsite3.com
click = randomsite4.com
click = randomsite5.com
click = randomsite5.com = <--SKIP done been called so lets move along
click = randomsite6.com

I guess somehow im going to have to store the urls that are loaded into a variable and compare the variable to the the random site to make sure we dont get a match.
then again i guess i would have to some how figure out how to store the data per unique user as well .

Any suggestions would be greatly appreciated

Help With Creating Unique User Id's Please!

Similar Tutorials

View Content

Hi everyone, I'm new here and really in need of some help with some script I've been trying to get right.

Basically I'm trying to write a function that will interface with Gravity Forms and Wordpress but this is NOT a GForms or Wordpress issue it's pure PHP honest!

The function will pull the post code a user has entered on the first page of a Gravity Form, and then take the spaces out of it and make sure it's in upper case. This much I've got working.

Now I need it to add a hyphen and a three digit number starting at 001, so it'll look like AB12CD-001. Now it will need to check if this is username has already been used by calling the Wordpress function username_exists (http://codex.wordpress.org/Function_Reference/username_exists) and if it does increase the suffix number by one and recheck until it finds the next available number.

This could result in the user living in the post code AB1 2CD ending up with the username AB12CD-021 if there are 20 others in the local area obviously.

Now this will then post back to the Gravity Forms registration form on the next page and fill in the username for the user, this I can also do.

So hopefully you can see it's the PHP bit I'm stuck on and I would really appreciate any help.

Cheers guys

Creating A Unique Page For Every User Using Php Pdo And Mysql

Similar Tutorials

View Content

I've started a to-do app, and everything works fine. Every user has his own unique to-do items that he can add. The only issue is that when I log-in with a user, ALL the items of all users are displayed when I'm redirect to my main page. I want to make it as so every user has his own page where only the to-do items he has created are visible, not every item from every user. I'm a total beginner with PHP so I'm sorry if this is a stupid question.

This is my todomain.php code

<?php
require 'db_conn.php';
require 'config.php';
session_start(); 
   
// If the session variable is empty, this  
// means the user is yet to login 
// User will be sent to 'login.php' page 
// to allow the user to login 
if (!isset($_SESSION['id'])) { 
    $_SESSION['msg'] = "You have to log in first"; 
    header('location: login.php'); 
} 
   
// Logout button will destroy the session, and 
// will unset the session variables 
// User will be headed to 'login.php' 
// after loggin out 
if (isset($_GET['logout'])) { 
    session_destroy(); 
    unset($_SESSION['id']); 
    header("location: login.php"); 
} 


?>

<!DOCTYPE html>
<html lang="en">
<head>
<meta charset= "UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<meta http-equiv="X-UA-Compatible" content="IE=edge"> 
<link rel="stylesheet" href="css/bootstrap-grid.min.css">
<link rel="stylesheet" href="css/bootstrap.min.css">
<link rel="stylesheet" href="style.css">
<a href="index.php?logout='1'" style="color: black;"> 
                    Click here to Logout 
                </a> 
 <?php if (isset($_SESSION['success'])) : ?> 
            <div class="error success" > 
                <h3> 
                    <?php
                        echo $_SESSION['success'];  
                        unset($_SESSION['success']); 
                        echo $_SESSION["username"]
                    ?> 
                </h3> 
            </div> 
        <?php endif ?> 

<title>TODO App</title>
<script src="https://kit.fontawesome.com/d72928d9b9.js" crossorigin="anonymous"></script>
</head>
<body>
    <div class="container m-5 p-2 rounded mx-auto bg-light shadow">
    <!-- App title section -->
    <div class="row m-1 p-4">
        <div class="col">
            <div class="p-1 h1 text-primary text-center mx-auto display-inline-block">
                <i class="fa fa-check bg-primary text-white rounded p-2"></i>
                <u>My Todo-s</u>
            </div>
        </div>
    </div>
    <!-- Create todo section -->
  <form action="app/add.php" method="POST" autocomplete="off">
    <div class="row m-1 p-3">
        <div class="col col-11 mx-auto">
            
            <div class="row bg-white rounded shadow-sm p-2 add-todo-wrapper align-items-center justify-content-center">
                
                <div class="col">
                    <input class="form-control form-control-lg border-0 add-todo-input bg-transparent rounded" type="text" name="title" placeholder="Add new ..">
                </div>
                <div class="col-auto m-0 px-2 d-flex align-items-center">
                    <label class="text-secondary my-2 p-0 px-1 view-opt-label due-date-label d-none">Due date not set</label>
                    <i class="fa fa-calendar my-2 px-1 text-primary btn due-date-button" data-toggle="tooltip" data-placement="bottom" title="Set a Due date"></i>
                    <i class="fa fa-calendar-times-o my-2 px-1 text-danger btn clear-due-date-button d-none" data-toggle="tooltip" data-placement="bottom" title="Clear Due date"></i>
                </div>
                
                <div class="col-auto px-0 mx-0 mr-2">
                    
                    <button type="submit" class="btn btn-primary">Add</button>
                    
                    
                </div>
             
            </div>

            
        </div>
    </div>
    </form>

     
          <?php
            $todos=$conn->query("SELECT * FROM  todos ORDER BY id ASC");
          ?>

 
  <div class="row mx-1 px-5 pb-3 w-80">
        <div class="col mx-auto">

           <?php
           while($todo=$todos->fetch(PDO::FETCH_ASSOC)){ ?>
            <!-- Todo Item 1 -->

            
            <div class="row px-3 align-items-center todo-item rounded">

                <?php if($todo['checked']){ ?>
                
                <input type="checkbox" class="check-box" data-todo-id="<?php echo $todo['id'];?>" checked />
            <h2 class="checked"><?php echo $todo['title'] ?> </h2>
            <div class="col-auto m-1 p-0 todo-actions">
                    <div class="row d-flex align-items-center justify-content-end">
              
            </div>
          </div>
        
             

                      
            <?php } else{ ?>
                <input type="checkbox" class="check-box" data-todo-id="<?php echo $todo['id'];?>"/>
                 <h2><?php echo $todo['title'] ?></h2>
                   
                          

            <?php } ?>

                <div class="col-auto m-1 p-0 d-flex align-items-center">


                    <h2 class="m-0 p-0">
                        <i class="fa fa-square-o text-primary btn m-0 p-0 d-none" data-toggle="tooltip" data-placement="bottom" title="Mark as complete"></i>
                        
                    </h2>
                </div>
               
                
             
                <div class="col-auto m-1 p-0 todo-actions">
                    <div class="row d-flex align-items-center justify-content-end">

                        <h5 class="m-0 p-0 px-2">
                            <i class="fa fa-pencil text-info btn m-0 p-0" data-toggle="tooltip" data-placement="bottom" title="Edit todo"></i>
                        </h5>
                        <h5 class="m-0 p-0 px-2">
                          
                             
                        <i class="remove-to-do fa fa-trash-o text-danger btn m-0 p-0" data-toggle="tooltip" data-placement="bottom" title="Delete todo" id="<?php echo $todo['id']; ?>"></i>
                      </h5> 
                    </div>
                    <div class="row todo-created-info">
                        <div class="col-auto d-flex align-items-center pr-2">
                            <i class="fa fa-info-circle my-2 px-2 text-black-50 btn" data-toggle="tooltip" data-placement="bottom" title="" data-original-title="Created date"></i>
                            <label class="date-label my-2 text-black-50"><?php echo $todo['date_time'] ?></label>
                        </div>
                    </div>
                </div>
            </div>
        
        <?php } ?>

    

</div>


 <script src="https://code.jquery.com/jquery-3.3.1.slim.min.js" integrity="sha384-q8i/X+965DzO0rT7abK41JStQIAqVgRVzpbzo5smXKp4YfRvH+8abtTE1Pi6jizo" crossorigin="anonymous"></script>
    <script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.14.3/umd/popper.min.js" integrity="sha384-ZMP7rVo3mIykV+2+9J3UJ46jBk0WLaUAdn689aCwoqbBJiSnjAK/l8WvCWPIPm49" crossorigin="anonymous"></script>
    <script src="js/bootstrap.bundle.min.js"></script>
    <script src="js/myjs.js" ></script>
    <script src="js/jquery-3.3.1.min.js"></script>

    <script>
        $(document).ready(function(){

          $(".remove-to-do").click(function(e){
                const id = $(this).attr('id');
                 $.post('app/remove.php', 
                      {
                          id: id
                      },
                      (data) => {
                         if(data){
                            $(this).parent().parent().parent().parent().hide(300);
                         }
                      }

                );
                
               
            });
          


            $(".check-box").click(function(e){
                const id = $(this).attr('data-todo-id');
                
                $.post('app/checking.php', 
                      {
                          id: id
                      },
                      (data) => {
                         if(data!='error'){
                            const h2= $(this).next();
                            if(data === '1'){
                                h2.removeClass('checked');
                            }else{
                                h2.addclass('checked');
                            }
                         }
                      }

                );
            });
        });
    </script>


</body>
</html>

Can't Get User Information After Login!

Similar Tutorials

View Content

I am coding a php website and i have everything ready to start on the user interface, but now it wont get the data from the login to get data from the database.
I added some debugging code in to see if it even gets a session and it doesn't even get one, can someone please help me and tell me what i am doing wrong?.

My login code:
Code: [Select]
<?php

include('/home/sites/******/MasterConfig/Config.php');
$tbl_name='U_members'; // Table name </p>
session_start();
ob_start();

// Connect to server and select databse.
mysql_select_db("$db_name")or die("cannot select DB");

// Define $myusername and $mypassword
$myusername=$_POST['MYusername'];
$rawpassword=$_POST['MYpassword'];
$mypassword=md5($rawpassword);
// To protect MySQL injection (more detail about MySQL injection)
$myusername = stripslashes($myusername);
$mypassword = stripslashes($mypassword);
$myusername = mysql_real_escape_string($myusername);
$mypassword = mysql_real_escape_string($mypassword);

$sql="SELECT * FROM $tbl_name WHERE Username='$myusername' and Password='$mypassword'";
$result=mysql_query($sql);

// Mysql_num_row is counting table row
$count=mysql_num_rows($result);
// If result matched $myusername and $mypassword, table row must be 1 row

if($count==1){
// Register $myusername, $mypassword and redirect to file "login_success.php"
session_register("myusername");
session_register("mypassword");
$_SESSION['loggedin'] = true;
$_SESSION['username'] = $_POST['MYusername'];
header("location:/welcome.php");
}
else {
echo "Wrong Username or Password";
}
ob_end_flush();
?>
Welcome.php:
Code: [Select]
<?php
include('/home/sites/*********MasterConfig/Config.php');
$tbl_name = "U_items"; // Table name </p>
ob_start();

?>
<!DOCTYPE html>
<html lang="en">
<head>
<?php
ob_start();
session_start();
?>
<meta charset="utf-8">

<link rel="stylesheet" href="css/all.css">

<script type="text/javascript" src="https://ajax.googleapis.com/ajax/libs/jquery/1.5/jquery.min.js"></script>
<script type="text/javascript" src="js/jquery.easing.1.3.js"></script>
<script type="text/javascript" src="js/jquery.quicksand.js"></script>
<script type="text/javascript" src="js/main.js"></script>

<title>Product Filter</title>
</head>

<body>
<?php
if (isset($_SESSION['loggedin']) && $_SESSION['loggedin'] == true) {

}
else {
mysql_close($_SESSION['connect']);
header("location:/index.php");
}
?>
<h1> Welcome <?php $_SESSION['username']; ?> </h1>
<div id="container">
<ul id="filterOptions">
<li class="active"><a href="#" class="all">All my products</a></li>
<li><a href="#" class="Car">My cars</a></li>
<li><a href="#" class="champ">My motorbikes</a></li>
<li><a href="#" class="league1">My ECO</a></li>
<li><a href="#" class="league2">My Art</a></li>
</ul>

<ul class="ourHolder">
<li class="item" data-id="id-1" data-type="Car">
<?php
mysql_select_db("$db_name")or die("cannot select DB");
$SQL = mysql_query('SELECT * FROM ' + $tbl_name + ' WHERE Owner = ' + $_SESSION['username']);
while($row = mysql_fetch_row($SQL));
$id=$row['ID'];
$photo=$row['PicLink'];
$ItemName=$row['Name'];

if(isset($_SESSION['userName']))
{
print "Your session username: ".$_SESSION['username']. "<br>";
}
else
{
print "Session does not exist";
}
?>
<img src="<?php $Photo ?>" alt="<?php $ItemName ?>" />
<h3> <?php $ItemName ?></h3>

</li>
</li>
</ul>
</div>

</body>
</html>

Php Get User Information Twitter Api

Similar Tutorials

View Content

I was wondering if you could help me. I am currently trying to use the 'GET users/show' command in the Twitter API, however it is not working. Can anyone see where I am going wrong?

<?php include "library/twitteroauth.php"; ?>
<?php
$consumer = "key";
$consumersecret = "key";
$accesstoken = "key";
$accesstokensecret = "key";

$twitter = new TwitterOAuth($consumer, $consumersecret, $accesstoken, $accesstokensecret);
$tweets = $twitter->get('https://api.twitter.com/1.1/users/lookup.json?screen_name=twitterapi,twitter');

?>

<html>
    <head>
            <meta charset ="UTF-8" />
            <title>Twitter Search</title>       
    </head>
        <body>
            <form action="" method="post">
            <label>Search: <input type="text" name ="keyword"/>
            </form>
            <?php 
            if ( isset($_POST['keyword'])){
                $tweets = $twitter->get('https://api.twitter.com/1.1/users/lookup.json?screen_name='.$_POST['keyword']. '');
                foreach($tweets as $tweet){
                    foreach ($tweet as $t){
                        echo ($t->text);
                    }
                    }
                    }           

            ?>
        </body>
</html>

Updating User Information Based On Id

Similar Tutorials

View Content

Hi, I want to update user information in the database but it doesn't do anything. No data entered upon form submission. Please anyone if you can help would be great. Thank you.

Code: [Select]
<?php
ini_set ("display_errors", "1");
error_reporting(E_ALL);
$host = "";//edited out
$database = "";
$username = "";
$password = "";

$tbl_name   = "users";
$link = mysqli_connect($host, $username, $password);
$conn = mysql_connect($host, $username, $password) or die("Could not connect: " . mysql_error());
mysql_select_db($database);

session_start();

IF (isset($_SESSION['userid'])){
$userid=$_SESSION['userid'];
echo $userid;
}

//$currentUser = $_SESSION['myusername'];

//do some cleanup//
IF (isset($_POST['submit'])){

$first =  $_POST['first'];
$last = $_POST['last'];
$dob = $_POST['dob'];
$gender =  $_POST['gender'];

$country =  $_POST['country'];
$state =   $_POST['state'];
$town =   $_POST['town'];
$zip =  $_POST['zip'];
$email =  $_POST['email'];

$first = mysql_real_escape_string( '$first');
$last = mysql_real_escape_string(  '$last');
$dob = mysql_real_escape_string(  '$dob');
$gender = mysql_real_escape_string(  '$gender');

$country = mysql_real_escape_string(  '$country');
$state = mysql_real_escape_string(  '$state');
$town = mysql_real_escape_string(  '$town');
$zip = mysql_real_escape_string(  '$zip');
$email = mysql_real_escape_string(  '$email');

};
IF (isset($_SESSION['userid'])){
$userid=$_SESSION['userid'];
}
ELSE{
$getuserid=mysql_query ("SELECT id FROM users ORDER BY id DESC limit 1") or die(mysql_error());
WHILE ($gtuserid = mysql_fetch_array($getuserid)) {
$theuserid=$gtuserid['id'];
$userid=$theuserid;
$_SESSION['userid']=$theuserid;
$userid=$_SESSION['userid'];
}//$getuserid
}// IF ELSE (isset($_SESSION['userid']))

/////UPDATE SECTION/////
IF (isset($_POST['submit'])){
mysql_query ( "UPDATE users SET firstname='$first', lastname='$last', dob = '$dob', gender='$gender',    country='$country', state='$state', town='$town', zip='$zip', email='$email'   WHERE id=$userid") or die(mysql_error());
}//IF ($_POST['update']=="Update")

?>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>Connection</title>
<style type="text/css">
body {
font-family:Calibri;
font-size:1em;
}
.title {
font-size:1.6em;
font-weight:strong;
}
.links a{
font-size::1.2em;
text-decoration:none;
}
.links a:hover{
font-size::1.2em;
color:#0066FF;
text-decoration:none;
}
</style>
</head>
<body>
<p><span class="title">Add your personal information/span></p>

<form action="thebeast.php" method="post">
<p>
<input type="text" name="first" size="20" id="first" />
First name<br />
<input type="text" name="last" size="20" id="name" />
Last name<br />
<input name="dob" type="text" size="20" id="dob" ; } ?>
Date of Birth<br />
<input type="text" name="gender" size="20" id="gender" />
Gender <br />
<input type="text" name="country" size="20" id="country" />
Country<br />
<input type="text" name="state" size="20" id="state" />
State<br />
<input type="text" name="town" size="20" id="town" />
Town<br />
<input type="text" name="zip" size="20" id="zip" />
Zip Code<br />
<input type="text" name="email" size="40" id="email" />
Email<br />
<br />

<input type="submit" name="submit" value="Add your information" />

</form>

</body>
</html>

Displaying Information Of A Logged In User

Similar Tutorials

View Content

i need to display the fullname and email of the logged in user.

<?php
session_start();
mysql_connect("localhost", "root", "") or die(mysql_error());
mysql_select_db("db_register") or die(mysql_error());
$query = "SELECT` fullname`, `email` FROM `members` WHERE `username`='".$_SESSION['user']."' LIMIT 1";
if($doQuery = mysql_query($query)) {
if(mysql_num_rows($doQuery)) {
$user = mysql_fetch_assoc($doQuery);
print_r($user);
} else {
echo 'No result returned for the query: '.$query;
}
} else {
echo 'The following query failed: '.$query;
}
$id = $user['id'];
$fullname = $user['fullname'];
$email = $user['email'];
}
?>
<br>
Fullname : <?php echo $fullname; ?>
<br>
Email : <? echo $email; ?>
?>

HELP please .

Moved: Make A User Can Only See Some Information From The Database

Similar Tutorials

View Content

This topic has been moved to Application Design.

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

Selecting User Specific Information After Login

Similar Tutorials

View Content

Hi this is what I have set up -

SQL tables -

Members -
memberid - primary key
Username
Password
Orders -
Orderid - primary key
memberid - foreign key
orderno

In my sql table there are two members and two orders.
1 order is assigned to 1 member and the other order to the other member.

After each member logs in I need to 'echo' that order on the page.

I've not been able to write any succesful php code that 'gets' the specific order that is related to the member that has signed in.

I would appreciate help on this!
Thanks

Accessing User Specific Information From A Mysql Database

Similar Tutorials

View Content

Hi,

I have created a session based logon system using php and MYSQL from some tutorials I found online which is working very successfully. I can log on and of and move through different pages with no problems.

My query is how do I output or display the information that is specific to the user which is currently logged on and block access to any other users information. I am quite sure there is a simple solution that is escaping me.

If you could point me in the right direction it would be greatly appreciated.

Thanks in advance

[php] How To Block User After 3 Fail Of Submiting Wrong Information

Similar Tutorials

View Content

As title says i need to block user for 30 minutes after he enter invalid data 3 times in a row. I know i need to enter ip and time in database, but how to stop form to be submited. i have this code for count failed attempts, he increment value in session every time submit is pressed

// postavi ili povecaj broj u sessiji ako je Login button aktiviran
if (empty($_SESSION['failed_login'])) 
{
    $_SESSION['failed_login'] = 1;
} 
elseif (isset($_POST['login'])) 
{
    $_SESSION['failed_login']++;
}

// if login fail 3 times
if ($_SESSION['failed_login'] > 3) {
	$error[] = 'U failed to login 3 times ' . $_SESSION['failed_login'];
}

This is whole login.php

<?php

// protect page from direct access
if (!defined('AUTH')) { die('You are not authorized to see this page !'); }

if ($general->is_logged() === true)
{
	header('Location: index.php');
	exit();
}

$last_login_date = time();
$ip = $general->get_ip();

// postavi ili povecaj broj u sessiji ako je Login button aktiviran
if (empty($_SESSION['failed_login'])) 
{
    $_SESSION['failed_login'] = 1;
} 
elseif (isset($_POST['login'])) 
{
    $_SESSION['failed_login']++;
}

// if login fail 3 times
if ($_SESSION['failed_login'] > 3) {
	$error[] = 'U failed to login 3 times ' . $_SESSION['failed_login'];
}

// login form
if (isset($_POST['login']))
{
	$username = trim($_POST['username']);
	$password = trim($general->safepass($_POST['password']));

	// if user entered username and password
	if (empty($username) || empty($password))
	{
		$error[] = 'Please enter username and password';
	}
	else
	{
		// login query
		$login = $users->login($username, $password);

		// cookie login
		if (isset($_POST['stay_logged']))
		{
			// check if username and password is valid 
			if ($login) 
			{
				$user_id = $login['id'];

				// expire time for cookie 1 month
				$expire = time()+60*60*24*30;

				// make random code for token
				$rand = hash('sha512', mt_rand());

				// set cookies
				setcookie('token', $rand, $expire);
				setcookie('username', $login['username'], $expire);
				setcookie('id', $login['id'], $expire);

				// update user last_login, ip, token code
				$update_login_data = $users->update_cookie_login($last_login_date, $ip, $rand, $user_id);

				// redirect user to index.php and exit script
				header('Location: index.php');
				exit();
			}
			else
			{
				// if username or password is not valid
				$error[] = 'Invalid username or password';
			}
		}

		// session login
		else
		{
			// check if username and password is valid
			if ($login) 
			{
				// make sessions with user_id and username
				$_SESSION['id'] = $login['id'];
				$_SESSION['username'] = $login['username'];
				$user_id = (int)$_SESSION['id'];

				// update user last_login, ip
				$update_login = $users->update_user_ip_login($last_login_date, $ip, $user_id);

				// redirect user to index.php and exit script
				header('Location: index.php');
				exit();
			}
			else
			{
				// if username or password is not valid
				$error[] = 'Invalid username or password';
			}
		}
	}
}

?>

<h3>Log in</h3>

<?php
if (!empty($error)) {
	echo '<div class="big-error-msg"><ul style="margin:0 0 0 20px;">';
	foreach ($error as $error) {
		echo '<li>'.$error. '</li>';
	}
	echo '</ul></div>';
}
?>

<form action="" method="POST" class="login-form">
	<input type="text" name="username" placeholder="Username" required>&nbsp;&nbsp;&nbsp;
	<input type="password" name="password" placeholder="Password" required><br><br>
	<input type="checkbox" name="stay_logged"><label style="padding:0 0 0 10px;">Remember me ?</label><br>
	<input type="submit" name="login" value="Log in" class="small-button">
	<label>
		<p><a href="index.php?page=forgotten_pass" title="Forgotten password ?">Forgotten password ?</a></p>
		<p>Don't have an account ? <a href="index.php?page=register" title="Register">Register</a></p>
	</label>
</form>

Getting User Information Into Database And Send Activation Email Script Here!

Similar Tutorials

View Content

This script works well as far as getting the form information onto the database but for some reason the confirmation email is not being sent to the user.

Could someone take a quick look at my script? Please? I've attached the included files as well. I guess I just need another set of eyes to look over this script. It would be much appreciated

<?php
// Created BY Adam Khoury @ www.developphp.com

// let's initialize vars to be printed to page in the HTML section so our script does not return errors
// they must be initialized in some server environments
$errorMsg = "";
$firstname = "";
$lastname = "";
$country = "";
$state = "";
$city = "";
$zip = "";
$website = "";
$youtube = "";
$email1 = "";
$email2 = "";
$pass1 = "";
$pass2 = "";

// This code runs only if the form submit button is pressed
if (isset ($_POST['firstname'])){

   /* Example of cleaning variables in a loop
   $vars = "";
   foreach ($_POST as $key => $value) {
$value = stripslashes($value);
$vars .= "$key = $value<br />";
}
print "$vars";
exit();
   */
$firstname = $_POST['firstname'];
$lastname = $_POST['lastname'];
$country = $_POST['country'];
$state = $_POST['state'];
$city = $_POST['city'];
$zip = $_POST['zip'];
$website = $_POST['website'];
$youtube = $_POST['youtube'];
$email1 = $_POST['email1'];
$email2 = $_POST['email2'];
$pass1 = $_POST['pass1'];
$pass2 = $_POST['pass2'];
$humancheck = $_POST['humancheck'];

$firstname = stripslashes($firstname);
$lastname = stripslashes($lastname);
$state = stripslashes($state);
$city = stripslashes($city);
$zip = stripslashes($zip);
$website = stripslashes($website);
$youtube = stripslashes($youtube);
$email1 = stripslashes($email1);
$pass1 = stripslashes($pass1);
$email2 = stripslashes($email2);
$pass2 = stripslashes($pass2);

$firstname = strip_tags($firstname);
    $lastname = strip_tags($lastname);
$state = strip_tags($state);
$city = strip_tags($city);
    $zip = strip_tags($zip);
$website = strip_tags($website);
$youtube = strip_tags($youtube);
$email1 = strip_tags($email1);
$pass1 = strip_tags($pass1);
$email2 = strip_tags($email2);
$pass2 = strip_tags($pass2);

// Connect to database
include_once "connect_to_mysql.php";
$emailCHecker = mysql_real_escape_string($email1);
    $emailCHecker = eregi_replace("`", "", $emailCHecker);
// Database duplicate e-mail check setup for use below in the error handling if else conditionals

mysql_select_db("perry100_users", $myConnection);

$sql_email_check = mysql_query("SELECT email FROM myMembers WHERE email='$emailCHecker'", $myConnection);
    $email_check = mysql_num_rows($sql_email_check);// or die(mysql_error());


// Error handling for missing data
if ((!$firstname) || (!$lastname) || (!$country) || (!$state) || (!$city) || (!$zip) || (!$email1) || (!$email2) || (!$pass1) || (!$pass2)) {

$errorMsg = 'ERROR: You did not submit the following required information:<br /><br />';

if(!$firstname){
$errorMsg .= ' * First Name<br />';
}
    if(!$lastname){
$errorMsg .= ' * Last Name<br />';
}
if(!$country){
$errorMsg .= ' * Country<br />';
}
    if(!$state){
$errorMsg .= ' * State or Provice<br />';
}
    if(!$city){
$errorMsg .= ' * City<br />';
}
    if(!$zip){
$errorMsg .= ' * Postal or Zip Code<br />';
}
    if(!$email1){
$errorMsg .= ' * Email Address<br />';
}
    if(!$email2){
$errorMsg .= ' * Confirm Email Address<br />';
}
    if(!$pass1){
$errorMsg .= ' * Login Password<br />';
}
    if(!$pass2){
$errorMsg .= ' * Confirm Login Password<br />';
}

} else if ($email1 != $email2) {
$errorMsg = 'ERROR: Your Email fields below do not match<br />';
} else if ($pass1 != $pass2) {
$errorMsg = 'ERROR: Your Password fields below do not match<br />';
} else if ($humancheck != "") {
$errorMsg = 'ERROR: The Human Check field must be cleared to be sure you are human<br />';
} else if ($email_check > 0){
$errorMsg = "<u>ERROR:</u><br />Your Email address is already in use inside our database. Please use another.<br />";

} else { // Error handling is ended, process the data and add member to database
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

    $firstname = mysql_real_escape_string($firstname);
    $lastname = mysql_real_escape_string($lastname);
$state = mysql_real_escape_string($state);
$city = mysql_real_escape_string($city);
    $zip = mysql_real_escape_string($zip);
$website = mysql_real_escape_string($website);
    $youtube = mysql_real_escape_string($youtube);
$email1 = mysql_real_escape_string($email1);
$pass1 = mysql_real_escape_string($pass1);

    $firstname = eregi_replace("`", "", $firstname);
    $lastname = eregi_replace("`", "", $lastname);
    $state = eregi_replace("`", "", $state);
    $city = eregi_replace("`", "", $city);
    $zip = eregi_replace("`", "", $zip);
    $website = eregi_replace("`", "", $website);
    $youtube = eregi_replace("`", "", $youtube);
    $email1 = eregi_replace("`", "", $email1);
    $pass1 = eregi_replace("`", "", $pass1);

$website = eregi_replace("http://", "", $website);
    $youtube = eregi_replace("http://www.youtube.com/user/", "", $youtube);

// Add MD5 Hash to the password variable
$db_password = md5($pass1);

// Add user info into the database table for the main site table(knirv.com)
$sql = mysql_query("INSERT INTO myMembers (firstname, lastname, country, state, city, zip, email, password, sign_up_date, website, youtube)
VALUES('$firstname','$lastname','$country','$state','$city','$zip','$email1','$db_password', now(),'$website','$youtube')")
or die (mysql_error());

$id = mysql_insert_id();

    // Create directory(folder) to hold each user's files(pics, MP3s, etc.)
mkdir("members/$id", 0755);

//!!!!!!!!!!!!!!!!!!!!!!!!! Email User the activation link !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
$myemail = "admin@knirv.com";
$emess = "First Name: $firstname\n";
$emess.= "Last Name: $lastname\n";
$emess.= "Email 1: $email1\n";
$emess.= "Email 2: $email2\n";
$emess.= "City: $city\nState: $state\nZip/Post Code:$zip\n";
$emess.= "Country: $scountry\n";
$emess.= "Phone number 1: $phone1\n";
$emess.= "Phone number 2: $phone2\n";
$emess.= "Phone number 3: $phone3\n";
$emess.= "Comments: $sendmail";
$ehead = "From: $myemail\r\n";
$subj = "Complete knirv.com registration!";
$mailsend=mail("$myemail","$subj","$emess","$ehead");
//Begin HTML Email Message
$message = "Hi $firstname,

Complete this step to activate your login identity at knirv.com.

Click the line below to activate when ready.

http://www.knirv.com/activation.php?id=$id&sequence=$db_password
If the URL above is not an active link, please copy and paste it into your browser address bar

Login after successful activation using your:
E-mail Address: $email
Password: $password

See you on the site!
admin@knirv.com";
//end of message
unset($_GET['do']);

header("Location: thank_you.php");
break;

}

$msgToUser = "<h2>One Last Step - Activate through Email</h2><h4>OK $firstname, one last step to verify your email identity:</h4><br />
In a moment you will be sent an Activation link to your email address.<br /><br />
<br />
<strong><font color=\"#990000\">VERY IMPORTANT:</font></strong>
If you check your email with your host providers default email application, there may be issues with seeing the email contents. If this happens to you and you cannot read the message to activate, download the file and open using a text editor. If you still cannot see the activation link, contact site admin and briefly discuss the issue.<br /><br />
";

include_once 'msgToUser.php';

exit();

} // Close else after duplication checks

else { // if the form is not posted with variables, place default empty variables

     $errorMsg = "Fields marked with an [ * ] are required";
$firstname = "";
     $lastname = "";
     $country = "";
     $state = "";
     $city = "";
     $zip = "";
     $website = "";
     $youtube = "";
     $email1 = "";
     $email2 = "";
     $pass1 = "";
     $pass2 = "";
}

?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<meta name="Kinetic Network" content="Register to knirv.com" />
<meta name="Knirv Registration" content="register, www.knirv.com" />
<meta name="rating" content="General" />
<title>Register Your Account</title>
<link rel="icon" href="favicon.ico" type="image/x-icon" />
<link rel="shortcut icon" href="favicon.ico" type="image/x-icon" />
<style type="text/css">

</style>
<link href="CSS/site_layout.css" rel="stylesheet" type="text/css" />
</head>

<body>
<?php include_once "header_template.php";
if ($message)
echo "<p>$message</p>";
?>
<table width="950" align="center">
<tr>
<td width="758">
<blockquote>
<h2><br />
Create Your Account Below </h2>
</blockquote>
<table width="600" align="center" cellpadding="5">
<form action="register.php" method="post" enctype="multipart/form-data">
<tr>
<td width="125" class="style7"><div align="center"><strong>Please Do First →</strong></div></td>
<td width="447" bgcolor="#FFFFFF">Add <a href="mailto:admin@yknirv.com"><u>admin@knirv.com</u></a> to your email white list or safe sender list now, or else you might not get the activation email that is necessary for logging in successfully. </td>
</tr>
<tr>
<td colspan="2"><font color="#FF0000"><?php print "$errorMsg"; ?></font></td>
</tr>
<tr>
<td align="right" class="alignRt">First Name:<span class="brightRed"> *</span></td>
<td><input name="firstname" type="text" class="formFields" id="firstname" value="<?php print "$firstname"; ?>" size="32" maxlength="20" /></td>
</tr>
<tr>
<td align="right" class="alignRt">Last Name:<span class="brightRed"> *</span></td>
<td><input name="lastname" type="text" class="formFields" id="lastname" value="<?php print "$lastname"; ?>" size="32" maxlength="20" /></td>
</tr>
<tr>
<td align="right" class="alignRt">Country:<span class="brightRed"> *</span></td>
<td>
<select name="country" class="formFields">
<option value="<?php print "$country"; ?>"><?php print "$country"; ?></option>
<option value="United States of America">United States of America</option>
<option value="Afghanistan">Afghanistan</option>
<option value="Albania">Albania</option>
<option value="Algeria">Algeria</option>
<option value="American Samoa">American Samoa</option>
<option value="Andorra">Andorra</option>
<option value="Angola">Angola</option>
<option value="Anguilla">Anguilla</option>
<option value="Antigua and Barbuda">Antigua and Barbuda</option>
<option value="Argentina">Argentina</option>
<option value="Armenia">Armenia</option>
<option value="Aruba">Aruba</option>
<option value="Australia">Australia</option>
<option value="Austria">Austria</option>
<option value="Azerbaijan">Azerbaijan</option>
<option value="Bahamas">Bahamas</option>
<option value="Bahrain">Bahrain</option>
<option value="Bangladesh">Bangladesh</option>
<option value="Barbados">Barbados</option>
<option value="Belarus">Belarus</option>
<option value="Belgium">Belgium</option>
<option value="Belize">Belize</option>
<option value="Benin">Benin</option>
<option value="Bermuda">Bermuda</option>
<option value="Bhutan">Bhutan</option>
<option value="Bolivia">Bolivia</option>
<option value="Bonaire">Bonaire</option>
<option value="Bosnia and Herzegovina">Bosnia and Herzegovina</option>
<option value="Botswana">Botswana</option>
<option value="Brazil">Brazil</option>
<option value="British Indian Ocean Ter">British Indian Ocean Ter</option>
<option value="Brunei">Brunei</option>
<option value="Bulgaria">Bulgaria</option>
<option value="Burkina Faso">Burkina Faso</option>
<option value="Burundi">Burundi</option>
<option value="Cambodia">Cambodia</option>
<option value="Cameroon">Cameroon</option>
<option value="Canada">Canada</option>
<option value="Canary Islands">Canary Islands</option>
<option value="Cape Verde">Cape Verde</option>
<option value="Cayman Islands">Cayman Islands</option>
<option value="Central African Republic">Central African Republic</option>
<option value="Chad">Chad</option>
<option value="Channel Islands">Channel Islands</option>
<option value="Chile">Chile</option>
<option value="China">China</option>
<option value="Christmas Island">Christmas Island</option>
<option value="Cocos Island">Cocos Island</option>
<option value="Columbia">Columbia</option>
<option value="Comoros">Comoros</option>
<option value="Congo">Congo</option>
<option value="Cook Islands">Cook Islands</option>
<option value="Costa Rica">Costa Rica</option>
<option value="Cote D'Ivoire">Cote D'Ivoire</option>
<option value="Croatia">Croatia</option>
<option value="Cuba">Cuba</option>
<option value="Curacao">Curacao</option>
<option value="Cyprus">Cyprus</option>
<option value="Czech Republic">Czech Republic</option>
<option value="Denmark">Denmark</option>
<option value="Djibouti">Djibouti</option>
<option value="Dominica">Dominica</option>
<option value="Dominican Republic">Dominican Republic</option>
<option value="East Timor">East Timor</option>
<option value="Ecuador">Ecuador</option>
<option value="Egypt">Egypt</option>
<option value="El Salvador">El Salvador</option>
<option value="Equatorial Guinea">Equatorial Guinea</option>
<option value="Eritrea">Eritrea</option>
<option value="Estonia">Estonia</option>
<option value="Ethiopia">Ethiopia</option>
<option value="Falkland Islands">Falkland Islands</option>
<option value="Faroe Islands">Faroe Islands</option>
<option value="Fiji">Fiji</option>
<option value="Finland">Finland</option>
<option value="France">France</option>
<option value="French Guiana">French Guiana</option>
<option value="French Polynesia">French Polynesia</option>
<option value="French Southern Ter">French Southern Ter</option>
<option value="Gabon">Gabon</option>
<option value="Gambia">Gambia</option>
<option value="Georgia">Georgia</option>
<option value="Germany">Germany</option>
<option value="Ghana">Ghana</option>
<option value="Gibraltar">Gibraltar</option>
<option value="Great Britain">Great Britain</option>
<option value="Greece">Greece</option>
<option value="Greenland">Greenland</option>
<option value="Grenada">Grenada</option>
<option value="Guadeloupe">Guadeloupe</option>
<option value="Guam">Guam</option>
<option value="Guatemala">Guatemala</option>
<option value="Guinea">Guinea</option>
<option value="Guyana">Guyana</option>
<option value="Haiti">Haiti</option>
<option value="Hawaii">Hawaii</option>
<option value="Honduras">Honduras</option>
<option value="Hong Kong">Hong Kong</option>
<option value="Hungary">Hungary</option>
<option value="Iceland">Iceland</option>
<option value="India">India</option>
<option value="Indonesia">Indonesia</option>
<option value="Iran">Iran</option>
<option value="Iraq">Iraq</option>
<option value="Ireland">Ireland</option>
<option value="Isle of Man">Isle of Man</option>
<option value="Israel">Israel</option>
<option value="Italy">Italy</option>
<option value="Jamaica">Jamaica</option>
<option value="Japan">Japan</option>
<option value="Jordan">Jordan</option>
<option value="Kazakhstan">Kazakhstan</option>
<option value="Kenya">Kenya</option>
<option value="Kiribati">Kiribati</option>
<option value="Korea North">Korea North</option>
<option value="Korea South">Korea South</option>
<option value="Kuwait">Kuwait</option>
<option value="Kyrgyzstan">Kyrgyzstan</option>
<option value="Laos">Laos</option>
<option value="Latvia">Latvia</option>
<option value="Lebanon">Lebanon</option>
<option value="Lesotho">Lesotho</option>
<option value="Liberia">Liberia</option>
<option value="Libya">Libya</option>
<option value="Liechtenstein">Liechtenstein</option>
<option value="Lithuania">Lithuania</option>
<option value="Luxembourg">Luxembourg</option>
<option value="Macau">Macau</option>
<option value="Macedonia">Macedonia</option>
<option value="Madagascar">Madagascar</option>
<option value="Malaysia">Malaysia</option>
<option value="Malawi">Malawi</option>
<option value="Maldives">Maldives</option>
<option value="Mali">Mali</option>
<option value="Malta">Malta</option>
<option value="Marshall Islands">Marshall Islands</option>
<option value="Martinique">Martinique</option>
<option value="Mauritania">Mauritania</option>
<option value="Mauritius">Mauritius</option>
<option value="Mayotte">Mayotte</option>
<option value="Mexico">Mexico</option>
<option value="Midway Islands">Midway Islands</option>
<option value="Moldova">Moldova</option>
<option value="Monaco">Monaco</option>
<option value="Mongolia">Mongolia</option>
<option value="Montserrat">Montserrat</option>
<option value="Morocco">Morocco</option>
<option value="Mozambique">Mozambique</option>
<option value="Myanmar">Myanmar</option>
<option value="Nambia">Nambia</option>
<option value="Nauru">Nauru</option>
<option value="Nepal">Nepal</option>
<option value="Netherland Antilles">Netherland Antilles</option>
<option value="Netherlands">Netherlands</option>
<option value="Nevis">Nevis</option>
<option value="New Caledonia">New Caledonia</option>
<option value="New Zealand">New Zealand</option>
<option value="Nicaragua">Nicaragua</option>
<option value="Niger">Niger</option>
<option value="Nigeria">Nigeria</option>
<option value="Niue">Niue</option>
<option value="Norfolk Island">Norfolk Island</option>
<option value="Norway">Norway</option>
<option value="Oman">Oman</option>
<option value="Pakistan">Pakistan</option>
<option value="Palau Island">Palau Island</option>
<option value="Palestine">Palestine</option>
<option value="Panama">Panama</option>
<option value="Papua New Guinea">Papua New Guinea</option>
<option value="Paraguay">Paraguay</option>
<option value="Peru">Peru</option>
<option value="Philippines">Philippines</option>
<option value="Pitcairn Island">Pitcairn Island</option>
<option value="Poland">Poland</option>
<option value="Portugal">Portugal</option>
<option value="Puerto Rico">Puerto Rico</option>
<option value="Qatar">Qatar</option>
<option value="Reunion">Reunion</option>
<option value="Romania">Romania</option>
<option value="Russia">Russia</option>
<option value="Rwanda">Rwanda</option>
<option value="St Barthelemy">St Barthelemy</option>
<option value="St Eustatius">St Eustatius</option>
<option value="St Helena">St Helena</option>
<option value="St Kitts-Nevis">St Kitts-Nevis</option>
<option value="St Lucia">St Lucia</option>
<option value="St Maarten">St Maarten</option>
<option value="St Pierre and Miquelon">St Pierre and Miquelon</option>
<option value="St Vincent and Grenadines">St Vincent and Grenadines</option>
<option value="Saipan">Saipan</option>
<option value="Samoa">Samoa</option>
<option value="Samoa American">Samoa American</option>
<option value="San Marino">San Marino</option>
<option value="Sao Tome and Principe">Sao Tome and Principe</option>
<option value="Saudi Arabia">Saudi Arabia</option>
<option value="Senegal">Senegal</option>
<option value="Seychelles">Seychelles</option>
<option value="Serbia and Montenegro">Serbia and Montenegro</option>
<option value="Sierra Leone">Sierra Leone</option>
<option value="Singapore">Singapore</option>
<option value="Slovakia">Slovakia</option>
<option value="Slovenia">Slovenia</option>
<option value="Solomon Islands">Solomon Islands</option>
<option value="Somalia">Somalia</option>
<option value="South Africa">South Africa</option>
<option value="Spain">Spain</option>
<option value="Sri Lanka">Sri Lanka</option>
<option value="Sudan">Sudan</option>
<option value="Suriname">Suriname</option>
<option value="Swaziland">Swaziland</option>
<option value="Sweden">Sweden</option>
<option value="Switzerland">Switzerland</option>
<option value="Syria">Syria</option>
<option value="Tahiti">Tahiti</option>
<option value="Taiwan">Taiwan</option>
<option value="Tajikistan">Tajikistan</option>
<option value="Tanzania">Tanzania</option>
<option value="Thailand">Thailand</option>
<option value="Togo">Togo</option>
<option value="Tokelau">Tokelau</option>
<option value="Tonga">Tonga</option>
<option value="Trinidad and Tobago">Trinidad and Tobago</option>
<option value="Tunisia">Tunisia</option>
<option value="Turkey">Turkey</option>
<option value="Turkmenistan">Turkmenistan</option>
<option value="Turks and Caicos Is">Turks and Caicos Is</option>
<option value="Tuvalu">Tuvalu</option>
<option value="Uganda">Uganda</option>
<option value="Ukraine">Ukraine</option>
<option value="United Arab Emirates">United Arab Emirates</option>
<option value="United Kingdom">United Kingdom</option>
<option value="United States of America">United States of America</option>
<option value="Uruguay">Uruguay</option>
<option value="Uzbekistan">Uzbekistan</option>
<option value="Vanuatu">Vanuatu</option>
<option value="Vatican City State">Vatican City State</option>
<option value="Venezuela">Venezuela</option>
<option value="Vietnam">Vietnam</option>
<option value="Virgin Islands (Brit)">Virgin Islands Brit</option>
<option value="Virgin Islands (USA)">Virgin Islands USA</option>
<option value="Wake Island">Wake Island</option>
<option value="Wallis and Futana Is">Wallis and Futana Is</option>
<option value="Yemen">Yemen</option>
<option value="Zaire">Zaire</option>
<option value="Zambia">Zambia</option>
<option value="Zimbabwe">Zimbabwe</option>
</select>
</td>
</tr>
<tr>
<td align="right" class="alignRt">State/Province: <span class="brightRed">*</span></td>
<td><input name="state" type="text" class="formFields" id="state" value="<?php print "$state"; ?>" size="32" maxlength="36" /></td>
</tr>
<tr>
<td align="right" class="alignRt">City: <span class="brightRed">*</span></td>
<td><input name="city" type="text" class="formFields" id="city" value="<?php print "$city"; ?>" size="32" maxlength="36" /></td>
</tr>
<tr>
<td align="right" class="alignRt">Postal / Zip Code: <span class="brightRed">*</span></td>
<td><input name="zip" type="text" class="formFields" id="zip" value="<?php print "$zip"; ?>" size="32" maxlength="24" /></td>
</tr>
<tr>
<td align="right" class="alignRt">Website:</td>
<td><strong>http://</strong>
<input name="website" type="text" class="formFields" id="website" value="<?php print "$website"; ?>" size="40" maxlength="88" /></td>
</tr>
<tr>
<td align="right" class="alignRt">Youtube Channel:</td>
<td><strong>http://www.youtube.com/user/</strong>
<input name="youtube" type="text" class="formFields" id="youtube" value="<?php print "$youtube"; ?>" size="32" maxlength="88" /></td>
</tr>
<tr>
<td align="right" class="alignRt">Email Address: <span class="brightRed">*</span></td>
<td><input name="email1" type="text" class="formFields" id="email1" value="<?php print "$email1"; ?>" size="32" maxlength="48" /></td>
</tr>
<tr>
<td align="right" class="alignRt">Confirm Email:<span class="brightRed"> *</span></td>
<td><input name="email2" type="text" class="formFields" id="email2" value="<?php print "$email2"; ?>" size="32" maxlength="48" /></td>
</tr>
<tr>
<td align="right" class="alignRt">Create Password:<span class="brightRed"> *</span></td>
<td><input name="pass1" type="password" class="formFields" id="pass1" maxlength="16" />
<span class="textSize_9px"><span class="greyColor">Alphanumeric Characters Only</span></span></td>
</tr>
<tr>
<td align="right" class="alignRt">Confirm Password:<span class="brightRed"> *</span></td>
<td><input name="pass2" type="password" class="formFields" id="pass2" maxlength="16" />
<span class="textSize_9px"><span class="greyColor">Alphanumeric Characters Only</span></span></td>
</tr>
<tr>
<td align="right" class="alignRt"><br />
Human Check: <span class="brightRed">*</span></td>
<td><br />
<input name="humancheck" type="text" class="formFields" id="humancheck" value="Please remove all of this text" size="38" maxlength="32" />
</td>
</tr>
<tr>
<td> </td>
<td><p><br />
<input type="submit" name="Submit3" value="Submit Form" />
</p></td>
</tr>
</form>
</table>
<br />
<br /></td>
<td width="180" valign="top"><?php include_once "right_AD_template.php"; ?></td>
</tr>
</table>
<?php include_once "footer_template.php"; ?>
</body>
</html>

Send Email With Fetched Data Information To Different User After Selecting Checkbox

Similar Tutorials

View Content

Unique Code Based On Users Unique Email Address Inserted Into Mysql Table?

Similar Tutorials

View Content

I have a mysql table which will store users email addresses (each is unique and is the primary field) and a timestamp.
I have added another column called `'unique_code' (varchar(64), utf8_unicode_ci)`.

What I would very much appreciate assistance with is;

a) Generating a 5 digit alphanumeric code, ie: 5ABH6
b) Check all rows the 'unique_code' column to ensure it is unique, otherwise re-generate and check again
c) Insert the uniquely generated 5 digit alphanumeric code into `'unique_code'` column, corresponding to the email address just entered.
d) display the code on screen.

What code must I put and where?

**My current php is as follows:**

Code: [Select]
require "includes/connect.php";

$msg = '';

if($_POST['email']){

// Requested with AJAX:
$ajax = ($_SERVER['HTTP_X_REQUESTED_WITH'] == 'XMLHttpRequest');

try{
if(!filter_input(INPUT_POST,'email',FILTER_VALIDATE_EMAIL)){
throw new Exception('Invalid Email!');
}

$mysqli->query("INSERT INTO coming_soon_emails
SET email='".$mysqli->real_escape_string($_POST['email'])."'");

if($mysqli->affected_rows != 1){
throw new Exception('You are already on the notification list.');
}

if($ajax){
die('{"status":1}');
}

$msg = "Thank you!";

}
catch (Exception $e){

if($ajax){
die(json_encode(array('error'=>$e->getMessage())));
}

$msg = $e->getMessage();
}
}

Stored Procedure Don’t Know How To Get Values From Stored Procedure

Similar Tutorials

View Content

wrote a stored procedure this morning and i don’t know how to get the values out of it through a class function in php or phpmyadmin.

here is what i wrote :

public function totalProcedures($friend_name,$session_id) 
{ /* *query to fetch stored procedure */ 
try { 
//executing the stored procedure 
$sql_sp="CALL timeline (:friend, :session,@updates, @group_posts)";
$stmt_sp= $this->_db->prepare($sql_sp); 
$stmt_sp->bindValue(":friend",$friend_name);
$stmt_sp->bindValue(":session",$session_id); 
$stmt_sp->execute();
$rows=$stmt_sp->fetch(PDO::FETCH_ASSOC); 
$stmt_sp->closeCursor(); // closing the stored procedure 
//trying to get values from OUT parameters.
$stmt_sp_2=$this->_db->prepare("select @updates,@group_posts");
$stmt_sp_2->execute();
return $stmt_sp_2->fetch(PDO::FETCH_ASSOC);
} catch (PDOException $ei)
{
echo $ei->getMessage(); } 
}

can someone helpme how to get results.

here is the storedprocedu

DELIMITER $$
CREATE DEFINER=`root`@`localhost` PROCEDURE `timeline`(IN `friend` VARCHAR(255), IN `session_id` VARCHAR(255), OUT `updates` VARCHAR(62555), OUT `group_posts` VARCHAR(62555))
BEGIN


select * FROM updates where author in (friend,session_id)  order by time desc limit 5;



select * FROM group_posts where author_gp in (friend,session_id) order by pdate desc limit 5;
END$$
DELIMITER ;

i get the result in php myadmin as follows:

how do i do this inside a php class function.

CALL timeline('shan2batman','aboutthecreator', @updates, @group_posts);

Url Stored In A Variable

Similar Tutorials

View Content

The path to a image is stored in a variable and I need to display this image in the email. Can someone help me.

This is my current attempt and nothing is happening. But the variable passes the URL correctly.

Code: [Select]
<TABLE BORDER='0'>
<TR>
<TD align='left' width='370'><img src='".$dis_logoimg."' width='370' height='86' /></TD>
</TR>
</TABLE>