Learn VBA & Macros in 1 Week!

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

Full Excel VBA Course - Beginner to Expert

Website User Log On, Check Password Stored On Sql Database.	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.

Full Excel VBA Course - Beginner to Expert

Query About How To Retrieve A Password From The Database And Compare To The One The User Has Entered

Similar Tutorials

View Content

Hi, after following lots of advice and changing to MySqli I am running into a few probs. This is me just probably missing something stupid, I know what I want, but can't figure out what query I should use and where I should place it. All the queries I have tried have failed. I just need a query that gets the $current_stored_password from the password field on the database, to confirm the last check

elseif 
	($current_password !== $current_stored_password) {
	include 'includes/overall/header.php';
	echo $current_password . ' AND ' . $_POST['current_password'] . ' Password and password again do not match';
	include 'includes/overall/header.php';

}

Here is the whole script.

<?php
session_start();
error_reporting(0);
//ini_set('display_errors', '1');

require( 'database.php' );

$username = $_SESSION['loggedinuser'];
$current_stored_password = $_SESSION['password'];
$current_password = $_POST['current_password'];
$password = mysqli_real_escape_string($con, md5( $_POST['password']));
$password_again = mysqli_real_escape_string($con, md5( $_POST['password_again']));


// Run checks

if	(isset($_POST['current_password'], $_POST['password'], $_POST['password_again'])) {
	
if( strlen( $_POST['current_password'] ) < 8 )
    {
        include('includes/overall/header.php');
        echo "Password Must Be 8 or More Characters.";
        include('includes/overall/footer.php');
}
elseif( strlen( $_POST['password'] ) < 8 )
    {
        include('includes/overall/header.php');
        echo "Password Must Be 8 or More Characters.";
        include('includes/overall/footer.php');
    }
elseif 
		( strlen( $_POST['password_again'] ) < 8 )
    {
        include('includes/overall/header.php');
        echo "Password Must Be 8 or More Characters.";
        include('includes/overall/footer.php');
    }
elseif 
	($password !== $password_again) {
	include 'includes/overall/header.php';
	echo ' Password and password again do not match';
	include 'includes/overall/header.php';
}
elseif 
	($current_password !== $current_stored_password) {
	include 'includes/overall/header.php';
	echo $current_password . ' AND ' . $_POST['current_password'] . ' Password and password again do not match';
	include 'includes/overall/header.php';

} else {

// Define a query to run 
$query = "UPDATE `user` SET `password` = '$password' WHERE `username` = '$username'"; 

// Query the database 
$result = mysqli_query($con,$query); 

// Check if the query failed 
if( !$result ) 
{ 
   die('There was a problem executing the query ('.$query.'):<br>('.mysqli_errno($con).') '.mysqli_error($con)); 
} 

else {

include 'includes/overall/header.php';
	echo 'Password has been changed';
include 'includes/overall/footer.php';
}    
}
}

// Close the connection 
mysqli_close($con); 
?>

At the moment the message displayed when the form is submitted is

	echo $current_password . ' AND ' . $_POST['current_password'] . ' Password and password again do not match';

How do I retrieve the password from the database to compare against the current password entered by the user? Any help is much appreciated. PS. Yes I know I have repeated code and that md5 is not secure, but I am just building onto a template I got and will be making changes to shorten the code and secure the password soon

Php Check Stored Data Help

Similar Tutorials

View Content

Hey Guys,

I have got 3 chained select boxes working. Basically what you do is check for a region with the country, then once you pick a region, you select a club within that region. Once you have selected the club, you can then choose a team from within that club.

Screenshot: Attchment

As part of this chained select boxes's, a user can register. Although, the user has to FIRST check if the TEAM has already been registered in the database.

I have taken a screenshot of my database, which shows the regions, clubs, and teams from the chained select boxes. What i want to do now is be able to check if a TEAM is already registered in the database. So as you can see in the database, the team 'NPOB, Senior As' has already been taken.

Database Screenshot: Attachment

*** How do i check if a user has been registered to one of the teams? And if there is not a registered user to that team, they can then register it.

Here is my code:

<?php
include"database.php";
?>

<script type="text/javascript">

/*
Triple Combo Script Credit
By Philip M: http://www.codingforums.com/member.php?u=186
Visit http://javascriptkit.com for this and over 400+ other scripts
*/

var categories = [];
categories["startList"] = ["Taranaki","Auckland"]
// Regions + Clubs
categories["Taranaki"] = ["NPOB","Tukapa"];
categories["Auckland"] = ["Marist","Takapuna"];
// Clubs + Teams within that Club
categories["NPOB"] = ["Senior As","Senior Bs","Colts U21s"];
categories["Tukapa"] = ["Senior As","Senior Bs","Colts U21s"];
categories["Marist"] = ["Senior As","Senior Bs","Colts U21s"];
categories["Takapuna"] = ["Senior As","Senior Bs","Colts U21s"];

var nLists = 3; // number of select lists in the set

function fillSelect(currCat,currList){
var step = Number(currList.name.replace(/\D/g,""));
for (i=step; i<nLists+1; i++) {
document.forms['tripleplay']['List'+i].length = 1;
document.forms['tripleplay']['List'+i].selectedIndex = 0;
}
var nCat = categories[currCat];
for (each in nCat) {
var nOption = document.createElement('option');
var nData = document.createTextNode(nCat[each]);
nOption.setAttribute('value',nCat[each]);
nOption.appendChild(nData);
currList.appendChild(nOption);
}
}

// function getValue(L3, L2, L1) {
// alert("Your selection was:- \n" + L1 + "\n" + L2 + "\n" + L3);
// }

function init() {
fillSelect('startList',document.forms['tripleplay']['List1'])
}

navigator.appName == "Microsoft Internet Explorer" ? attachEvent('onload', init, false) : addEventListener('load', init, false);

</script>

<form name="tripleplay" action="testingdropdown.php" method="post">
<select name='List1' onchange="fillSelect(this.value,this.form['List2'])">
<option selected>Choose Region</option>
</select><br /><br />

<select name='List2' onchange="fillSelect(this.value,this.form['List3'])">
<option selected>Choose Club   </option>
</select><br /><br />

<select name='List3' onchange="getValue(this.value, this.form['List2'].value,
this.form['List1'].value)">
<option selected >Choose Team  </option>
</select>
<input type="submit" name="tripleplay" value="Register">
</form>

<?php
     if (isset($_POST['tripleplay'])) {


     $region = addslashes(strip_tags($_POST['List1']));
     $club = addslashes(strip_tags($_POST['List2']));
     $team = addslashes(strip_tags($_POST['List3']));

    $email = 'email';

$check = mysql_query("SELECT * FROM managers WHERE email='$email'");
           if ($email == '') {
         echo "You can register that club";
         } else {
echo "Sorry that team has already been registered";
}
}

?>

Unique User Stored Information

Similar Tutorials

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!

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();
}
?>

How To Run Php Code That Is Stored In A Database?

Similar Tutorials

View Content

How can I run php code that is stored in a database?

I have my pages created by grabbing the contents of a pageBody mySQL table cell, but some pages require further php to be able to display correctly.

For example, I have a players page, which will list all players, and some information about them. The players and information is all saved in a players table in my database (separate to the pages table where pageBody is stored). I use simple php to grab all the players and format all of their information so it can be displayed on the page.

This is the flow of information that I would like:
User clicks on players page browser loads content page (this is a template page), and grabs the pageid from $_GET browser then reads pages table in database to get the pageBody associated with the pageid The pageBody will contain more php, which will run the players script to retrieve the list, and display
Doing it the above way will make it much easier to extend the website to include more types of pages that has to run additional php scripts.
The only way I can think of this working is by doing this:
user clicks on players page
browser loads content page, grabs pageid from $_GET browser checks the pageid for the one associated with players (hard coded into the php script) browser then loads the players.php script instead of going to the database This above way means that I will need to edit the index.php page everytime I add a new list type (example, coaches, volunteers etc).

Anyone have any suggestions? I know my question is long, but I was finding it hard to explain it in an easy to understand way, but I'm still not sure if I have :S.

Cheers
Denno

Sessions Stored In Database

Similar Tutorials

View Content

Hey guys,

I have been banging my head against a wall here with this. I am saving my sessions in my database via session_set_save_handler(). So let me walk you through what I have here, what works, and what the issue seems to be.

basically, the problem is the $_SESSION array is empty on page load.

common.php:
I have the open / close / read / write / destroy / and gc functions. These all work properly as when i use a session variable it stores into the database and i can see all of the information in there..

inside of common.php i have session_start().. I am positive that the session_start() is running becasue common.php is included into index.php and i tried adding session_start() to index.php again and i got an E_NOTICE saying the session already began.

(yes, for the read function i am returning a string... i included that below).

for the table itself, i have set the session_data as both text and blob, same issue with both.

index.php:
includes common.php. I know it's included as other aspects of the file are included and work properly.

if i call var_dump($_SESSION) i get an empty array. and i prited out the session_id() and it matched my session id in the database. and the values that are stored in there are correct. i have for example:

count|i:0

now with that value actually in the database and when calling session_id() and i get the ID that matches in the table. so i will get an E_NOTICE of an undefined index..

i was trying something like:

if(!isset($_SESSION['count']))
     $_SESSION['count'] = 0;
else
     $_SESSION['count']++;

echo $_SESSION['count'];

Everytime the page is reloaded, count is reset to 0.. I can tell that it is reset to 0 as the expired time changes in the database after every load of the page (which is part of the write function). I double checked that it wasn't a problem for some reason with the ++ by adding in a variable that sets to 1 when in the if, and 0 if in the else, and it always outputs a 1.

i have included here my read function since that apparently is the issue..

function sess_read($sess_id)
{
      global $DB;

      $sql = "SELECT `session_data` FROM `sessions` WHERE
                session_id = '".$sess_id."' AND
                session_agent = '".$_SERVER["HTTP_USER_AGENT"]."' AND
                session_expire > '".time()."';";

       $query = $DB->query($sql);

       if($DB->num_rows($query) > 0)
       {

$r = $DB->fetch($query);
return settype($r['session_data'], 'string');

}

return '';
}

I tried also with removing the agent and expire check to see if it was an issue there but same problem.

I probably have missed something really dumb but i can't for the life of me figure it out and I have googled around for a similar issue. The actual output of the page is correct.. all of the HTML and CSS information loads properly.. no errors are reported (and i have E_ALL on).

Thanks

Image Stored In Database Can't Be Displayed.

Similar Tutorials

View Content

I put together the following blocs of code for uploading pictures into a database and displaying them on a webpage. The pictures are supposed to be displayed on the member's only page of a website I'm working on, upon logging in, and they are supposed to be the member's uploaded picture. I created several members and and used one of my existing member accounts to test the uploading process. The picture upload process appeared to have been successful when I checked on myphpadmin. Yet, when I login with this account, no picture is displayed, instead, a tiny jpg icon is displayed at the top left corner of the box in which the picture was supposed to be displayed. Same thing when I login with the other accounts with which I haven't yet uploaded a picture.

I'll start with the code that installs the table in the database

$query = "CREATE TABLE images (

image_id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY ,
member_id INT UNSIGNED,
like_id INT UNSIGNED,
image LONGBLOB NOT NULL,
image_name varchar(255)  NOT NULL,
image_type varchar(4) NOT NULL,
image_size int(8) NOT NULL,
image_cartegory VARCHAR(20) NOT NULL,
image_path VARCHAR(300),
image_date DATE

          )";

Then here is the code which allows the member to upload his pictu
<form enctype="multipart/form-data" action="insert_image.php" method="post" name="changer">
                         <input name="MAX_FILE_SIZE" value="102400" type="hidden">
                         <input name="image" accept="image/jpeg" type="file">
                         <input value="Submit" type="submit">
                        </form>

And here is the insertimage.php which inserts the image into our database: Note that I have to authenticate the user in order to register his session id which is used later on in the select query to identify him and select the right image that corresponds to him.

<?php

//This file inserts the main image into the images table.

//address error handling

ini_set ('display_errors', 1);
error_reporting (E_ALL & ~E_NOTICE);

//authenticate user
//Start session

session_start();

//Connect to database
require ('config.php');

//Check whether the session variable id is present or not. If not, deny access.

if(!isset($_SESSION['id']) || (trim($_SESSION['id']) == '')) {

header("location: access_denied.php");

exit();

}

        else{
// Make sure the user actually
// selected and uploaded a file
if (isset($_FILES['image']) && $_FILES['image']['size'] > 0) {

      // Temporary file name stored on the server
      $tmpName  = $_FILES['image']['tmp_name'];

      // Read the file
      $fp      = fopen($tmpName, 'r');
      $data = fread($fp, filesize($tmpName));
      $data = addslashes($data);
      fclose($fp);


      // Create the query and insert
      // into our database.
      $query = "INSERT INTO images (member_id, image_cartegory, image_date, image) VALUES ('{$_SESSION['id']}', 'main', NOW(), '$data')";
      $results = mysql_query($query);

      // Print results
      print "Thank you, your file has been uploaded.";

}
else {
   print "No image selected/uploaded";
}

// Close our MySQL Link
mysql_close();

} //End of if statmemnt.

?>

On the page which is supposed to display the image upon login in, I inserted the following html code in the div that's supposed to contain the image:

<div id="image_box" style="float:left; background-color: #c0c0c0; height:150px; width:140px; border- color:#a0a0a0;border-style:outset;border-width:1px; margin:auto; ">

<img src=picscript.php?imname=potwoods>

</div>

And finally, the picscript.php contained the select query:
<?php

                             //address error handling

                             ini_set ('display_errors', 1);
                             error_reporting (E_ALL & ~E_NOTICE);

                             //include the config file
                              require('config.php');

                             $image = stripslashes($_REQUEST[imname]);
                             $rs = mysql_query("SELECT* FROM images WHERE member_id = '".$_SESSION['id']."' AND cartegoty = 'main' ");
                             $row = mysql_fetch_assoc($rs);
                             $imagebytes = $row[image];
                             header("Content-type: image/jpeg");
                             print $imagebytes;


?>

Now the million dollar question is, "What is preventing the picture from getting displayed?" I know this is a very lengthy and laborious problem to follow but I'm sure there is someone out there who can point out where I'm not getting it. Thanks.

Execute Php Stored In Mysql Database?

Similar Tutorials

View Content

Hi Guys,

I have a webpage which has subsequent pages stored in a database e.g. index.php?id=1

The problem being, is that id=1 has it's data pulled from a database. This was fine & dandy until I started to insert PHP...I am trying to get the below to executre

<?php
$rater_id=1;
$rater_item_name='Rate This';
include("rater.php");?>

However nothing shows & nothing happens, I know eval can be used but have not been succesfull in implementing this, can someone please help!

Using A Sql Query Thats Stored In A Table On The Database.

Similar Tutorials

View Content

Hi,

I am trying to store a sql query in a database, but every time I try to read it, it shows all the code as text. eg just print ' . $parts_row['part_number'] . '

Here is the code on the page:

    $parts_sql = "SELECT * FROM parts WHERE part_cat = " . $category_row['cat_id'] . " ORDER BY CAST(part_a AS DECIMAL(10,2))";
  			$parts_result = mysql_query($parts_sql);
  
  			if(!$parts_result)
  			{
  				echo '<tr><td>The parts could not be displayed, please try again later.</tr></td></table>';
  			}
  			else
 			{
 
 				while($parts_row = mysql_fetch_array($parts_result))
 				{
                                               $pageformat_sql = "SELECT * FROM category_pages WHERE catpage_number = " . $category_row['cat_page'] . "";
 
                                               $pageformat_result = mysql_query($pageformat_sql);
 
 
                                                if(!$pageformat_result)
                                                {
                                                echo 'Error';
                                                }
                                                 else
                                                 {
                                                 while($pageformat_row = mysql_fetch_assoc($pageformat_result))
                                                 {
                                                   $data = $pageformat_row['catpage_table'];
                                                 echo '<table class="table2 centre" style="width:750px">
 	                                              ' . $pageformat_row['catpage_tabletitle'] . '' . $data . '';
 
 
 
                                                 }
                                                 }
 
     }}

And this is what is stored in the database table:

 <tr>
 <td class="cell left">' . $parts_row['part_number'] . '</td>
 <td class="cell centre">' . $parts_row['part_a'] . ' mm</td>
 <td class="cell centre">' . $parts_row['part_b'] . ' mm</td>
 <td class="cell centre">' . $parts_row['part_c'] . ' mm</td>
 <td class="cell centre">' . $parts_row['part_d'] . ' mm</td>
 <td class="cell centre">' . $parts_row['part_e'] . ' mm</td>
 <td class="cell centre">' . $parts_row['part_imped100'] . '</td>
 <td class="cell centre"><a href="datasheets/' . $parts_row['part_datasheet'] . '.pdf"><img border="0" src="images/pdf.jpg" alt="Download"</a></td></tr>

I would be very grateful to anyone who can help me with this.

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

Database Stored Images Not Displaying

Similar Tutorials

View Content

this is the line in my script that I have to show the image:

Code: [Select]
$output .= "<img>{$row['disp_pic']}</img></br>\n";

As you can see I added the image tag, but it wont show the actual image. IE shows it as a small square with another small square picture icon in the middle of it (i'm sure you guys know what i mean).

How To Compare The Radio Button Value Stored In Database.

Similar Tutorials

View Content

i am developing online test ,after succesful completion of the test i want to display the correct answe,in databse i have stored corect answer as radio button values(ex 1,2,3,4,) i want to display the coreect answer with a right mark,how can i achive this?could anybody help? here is my code

  <?php  $testid=$_GET['testid'];
include_once("header.php");
?>
<html>
<head>
<body>
<?php
include_once('connect.php');
$sqltest="select testname from test where testid='$testid'";
$sqltestresult=mysql_query($sqltest) or die(mysql_error());
while($result=mysql_fetch_array($sqltestresult))
{
 $testname=$result['testname'];


}




?>
<!--pass test name and time left -->
<table width="100%" cellpadding="0" cellspacing="0" border="0"><tr><td width="50%" valign="middle">
                           <h1 style="margin-left:0;"><?php 
  if(isset($testname))
  {
  
  echo $testname ;
  }
  ?></h1>
                         </td>
                         <td width="50%" align="right" valign="middle">
 <ul class="tabs" id="tabs">
                <li id="showtime" style="font-weight:bold; color:#FF0000; bottom:5px; font-size:16px; float:right"></li>
</ul>


                         </td>
                        </tr></table>
<div class="div-tabs-container" class="div-tabs-container" style="width:79%;margin-left:3%" > 
        <table cellpadding="0" cellspacing="0" border="0" id="questiontable" >
        <tr>
<?php
include_once('connect.php');
$sql="select * from testquestions where testid='$testid'";
$result=mysql_query($sql) or die(mysql_error());
if (mysql_num_rows($result)>0)
{
  $data = array(); // create a variable to hold the information
while (($row = mysql_fetch_array($result, MYSQL_ASSOC)) !== false)


{
$data[] = $row; // add the row in to the results (data) array
}
//shift off the first value
array_shift($data[0]);


$merge = call_user_func_array('array_merge', $data);


$size=sizeof($merge);
$newdata=array();
$num=1;
$correctanswerarray=array();
$selctedanswers=array();
/* echo "<form action='fetchquestion.php' method='post' id='formsubmit' onsubmit='return out()' name='test'>"; */


foreach ($merge as $key => $value ) 
{


$sql2="select qid, question,option1,option2,option3,option4,correct_answer from question where qid='$value'  ";


$result2=mysql_query($sql2) or die(mysql_error());




  while($row2=mysql_fetch_assoc($result2))
{
                  $questionid=$row2['qid'];
    $question=$row2['question'];
$option1=$row2['option1'];
$option2=$row2['option2'];
$option3=$row2['option3'];
$option4=$row2['option4'];
        $correctanswer=$row2['correct_answer'];
#array to store the correct answer.
$correctanswerarray[] = $questionid.$correctanswer; 
   #$newdata[]=$row2;






echo "


 <table class='bix-tbl-container' cellspacing='0' cellpadding='0' border='0' width='100%' id='questiontable'><tr>
                <td class='bix-td-qno jq-qno-2413'  rowspan='2' valign='top' align='left'>$num</td>
                <td class='bix-td-qtxt' valign='top'><p>$question</p></td>
            </tr>
            <tr>
                <td class='bix-td-miscell' valign='top'><table class='bix-tbl-options' id='tblOption_2413' border='0' cellpadding='0' cellspacing='0' width='100%'><tr><td nowrap='nowrap' class='bix-td-option bix-td-radio' width='1%'  id='tdOptionNo_A_2413'>


<input type='radio' class='result-option cls_2413' name='option_$questionid' value='1'  id='disable'/>
</td><td class='bix-td-option' width='1%'>A.</td>
                         <td class='bix-td-option' width='48%' id='tdOptionDt_A_2413'><table border='0' cellpadding='0' cellspacing='0'>
        <tr>                                                          
        <td class='bix-inner-td-option'>$option1</td>                                                         
        <td id='tdAnswerIMG_A_2413' class='jq-img-answer'  valign='middle'style='display:none;padding-left:10px;'>               
           <img src='/_files/images/website/accept.png' alt='' />  
        </td>                                                         
        </tr>                                                         
        </table></td></tr><tr><td nowrap='nowrap' class='bix-td-option bix-td-radio' width='1%'  id='tdOptionNo_B_2413'>


<input type='radio' class='result-option cls_2413' name='option_$questionid'  value='2' id='disabble'/>
</td><td class='bix-td-option' width='1%'>B.</td>
                         <td class='bix-td-option' width='48%'id='tdOptionDt_B_2413'><table border='0' cellpadding='0' cellspacing='0'>
        <tr>                                                          
        <td class='bix-inner-td-option'>$option2</td>                                                         
        <td id='tdAnswerIMG_B_2413' class='jq-img-answer'  valign='middle' style='display:none;padding-left:10px;'>               
           <img src='/_files/images/website/wrong.gif' alt=''/>  
        </td>                                                         
        </tr>                                                         
        </table></td></tr><tr><td nowrap='nowrap' class='bix-td-option bix-td-radio' width='1%'  id='tdOptionNo_C_2413'>


<input type='radio' class='result-option cls_2413' name='option_$questionid'  value='3' id='disable'/>
</td><td class='bix-td-option' width='1%'>C.</td>
                         <td class='bix-td-option' width='48%' id='tdOptionDt_C_2413'><table border='0' cellpadding='0' cellspacing='0'>
        <tr>                                                          
        <td class='bix-inner-td-option'>$option3</td>                                                         
        <td id='tdAnswerIMG_C_2413' class='jq-img-answer'  valign='middle' style='display:none;padding-left:10px;'>               
           <img src='/_files/images/website/wrong.gif' alt='' />  
        </td>                                                         
        </tr>                                                         
        </table></td></tr><tr><td nowrap='nowrap' class='bix-td-option bix-td-radio' width='1%'  id='tdOptionNo_D_2413'>


<input type='radio' class='result-option cls_2413' name='option_$questionid' value='4' id='disable'/>
</td><td class='bix-td-option' width='1%'>D.</td>
                         <td class='bix-td-option' width='48%' id='tdOptionDt_D_2413'><table border='0' cellpadding='0' cellspacing='0'>
        <tr>                                                          
        <td class='bix-inner-td-option'>$option4</td>                                                         
        <td id='tdAnswerIMG_D_2413' class='jq-img-answer'  valign='middle' style='display:none;padding-left:10px;'>               
           <img src='/_files/images/website/wrong.gif' alt='' />  
        </td>                                                         
        </tr>                                                         
        </table></td></tr></table>
 \n 


<input type='hidden' name='count' value='$num' id='count'>
<input type='hidden' name='queId[]' value='$questionid' id='queId'> 
                  
    
    


                </td>
            </tr>
            </table>
";










$num++;


}


} 
  
 echo " 
      </tr>
        </table>  
   "; 
#array of correct answrer 
#echo "array of correct answer<br/>";
#print_r($correctanswerarray);
#echo "size of the coreect answer array";
   $size1=sizeof($correctanswerarray);
echo "<br/>";




}
else
{
echo " no questions available for selected test";
}
?>
 </div>
 <!-- add div right side -->
 <div style="height:500px;width:150px;float:right;margin-top:-500px;border:1px solid #99CCFF">
</div>


<div style="height:30px">
</div>
<!--  add div bottom -->
<div style="height:125px;border:1px solid #99CCFF">
</div>


<?php
 include('footer.html'); 
?>


</body>
</html>

Edited by mac_gyver, 25 October 2014 - 10:05 AM.
code tags around code please

Help Separation Of Ids Pulled From Database And Stored Into Form

Similar Tutorials

View Content

Good afternoon all!! I have a very specific issue that, in my opinion, is quite complicated. In words, here is what I wish to achieve. I would like a page which displays users from the database. Each individual user has their own Div hidden below their name. Within this div, there is a form. The form is full of radio buttons. Once the user's name is clicked and form submitted, I wish to write the form data to the database for the specific user that was selected. See below example for better understanding:

Dale Gibbs
Chris Hansen
Steve Jobs

If I click Chris Hansen, the following happens

Dale Gibbs
==============
Chris Hansen

HIDDEN DIV FORM CONTENT
HIDDEN DIV FORM CONTENT
HIDDEN DIV FORM CONTENT
HIDDEN DIV FORM CONTENT
HIDDEN DIV FORM CONTENT

Submit Button
==============
Steve Jobbs

So as of now, the display is correct. I am seeing exactly what I want to see from my database. Also, my div IDs work just fine as well as the Javascript toggleSlidebox function. The only issue is for some reason, whenever I submit the form (no matter which user I select from my list), I can only write to the last inputted ID. So for example, if the last ID entered into the database was 6, then thats the only ID that will be returned when my form is submitted and the only place data will be written to, even if I select a user with ID 2. Please see below code for more information

Code: [Select]
<?php

$staff_display_query = "SELECT staff_info.id, staff_info.fname, staff_info.lname FROM staff_info, staff_projects WHERE staff_info.id = staff_projects.staff_id AND staff_projects.proj_id = '$c_project_id'";

$staff_display_sql = mysql_query($staff_display_query) or die (mysql_error());

while ($row = mysql_fetch_array($staff_display_sql)) {
$current_staff_id = $row['id'];
$staff_fname = $row['fname'];
$staff_lname = $row['lname'];

$list_staff .= '
' . $current_staff_id . '<br />
<a href="#" onclick="return false" onmousedown="javascript:toggleSlideBox(' . $current_staff_id . ');">' . $staff_fname . ' ' . $staff_lname . '</a>
<div class="hiddenDiv" id="' . $current_staff_id . '" style="border:#FFF 2px solid; width:553px;">

        
        <div id="task_1_permissions" class="task_permissions">
            <input name="permissions_1" type="radio" value="1"/>
            <input name="permissions_1" type="radio" value="2" />
            <input name="permissions_1" type="radio" value="3" />
            <input name="permissions_1" type="radio" value="0" />
        </div>

       
        <div id="task_2_permissions" class="task_permissions">
            <input name="permissions_2" type="radio" value="1"/>
            <input name="permissions_2" type="radio" value="2" />
            <input name="permissions_2" type="radio" value="3" />
            <input name="permissions_2" type="radio" value="0" />
        </div>

       
        <div id="task_3_permissions" class="task_permissions">
            <input name="permissions_3" type="radio" value="1"/>
            <input name="permissions_3" type="radio" value="2" />
            <input name="permissions_3" type="radio" value="3" />
            <input name="permissions_3" type="radio" value="0" />
        </div>

       
        <div id="task_4_permissions" class="task_permissions">
            <input name="permissions_4" type="radio" value="1"/>
            <input name="permissions_4" type="radio" value="2" />
            <input name="permissions_4" type="radio" value="3" />
            <input name="permissions_4" type="radio" value="0" />
        </div>

    <input name="submit_user_permissions" type="submit" value="Submit Permissions" />

</div>
</div>
<br /><br />
';
}

if (isset($_POST['submit_user_permissions'])) {
$permissions_1 = $_POST['permissions_1'];
$permissions_2 = $_POST['permissions_2'];
$permissions_3 = $_POST['permissions_3'];
$permissions_4 = $_POST['permissions_4'];
$query = "UPDATE staff_projects SET task_1='$permissions_1', task_2='$permissions_2', task_3='$permissions_3', task_4='$permissions_4' WHERE proj_id='$c_project_id' AND staff_id='$current_staff_id'";

$sql = mysql_query($query) or die (mysql_error());

echo 'Permissions set successfully.<br />';

}

After this PHP I have my standard HTML. Below is the javascript function I use for the slide box:

Code: [Select]

<script src="js/jquery-1.5.js" type="text/javascript"></script>

<script language="javascript" type="text/javascript">
function toggleSlideBox(x) {
if ($('#'+x).is(":hidden")) {
$(".hiddenDiv").slideUp(200);
$('#'+x).slideDown(300);
} else {
$('#'+x).slideUp(300);
}
}
</script>

Javascript works just fine by the way. Below is the form I have in the HTML of the code.

Code: [Select]

<form action="" method="post" enctype="multipart/form-data">

<?php echo "$list_staff"; ?>

</form>

This is of course wrapped around body tags and all the other necessary HTML. The view of the form is working right, the functions within the form are also working correctly. I just cant seem to separate the variables for each individual user. If I am in Chris Hansen's div, it should be his ID number that is being referenced for the database, not the ID number of the last person entered into the system. Any ideas? As always, thanks in advance guys!!!

Bl4ck Maj1k

Is A Way To Execute Php Code Which Is Stored In Mysql Database?

Similar Tutorials

View Content

Hi!

I was wondering if there is a way to execute php code which is stored in mysql database using php.

At the minute I am using a echo to try and run php code stored in a mysql database but this just displays the code and does not run the php code.

Thanks for any help!

Text Field With Variable Stored In Database

Similar Tutorials

View Content

File Location Stored In Database Retrieval To Html

Similar Tutorials

View Content

Hi guys,

I have a file location stored in mysql. when i populate the table i need this file location to be a hyperlink to the file itself, so the visitors can click like a normal link and open the file in word and pdf (both formats stored).

example of file location as in db "_private/Incident_Reports/Incident%20-%20Applecross%20-%2017%20December%202010%20-%20Website.doc"
example of php code Code: [Select]
echo $row['word_document'];
any ideas would be really appreciated.

Check If Password Expired?

Similar Tutorials

View Content

I could use some help comparing Dates.

I need to check if a Temporary Password has expired, and am a bit shaky on "Date Math".

The Temporary Password was created like this...

// Build query.
$q2 = "UPDATE member
SET temp_password=?,
temp_reset_on=NOW(),
updated_on=NOW()
WHERE email=?
LIMIT 1";

So how do I see if temp_reset_on is more than 4-hour old and thus expired?

Thanks,

Debbie

Simple Password Check

Similar Tutorials

View Content

Hi all, i have written a fairly simple profile page that users can see once they have logged in and i have a password change feature. the user is asked to enter there current password and then enter there desired new password, then confirm there new password to make sure they match. However the users current password isn't checked as im not sure how to code it. Heres my code so far:

<?PHP

session_start();

//Database Information

$dbhost = "localhost";
$dbname = "test";
$dbuser = "test";
$dbpass = "test";

//Connect to database

$conn = mysql_connect ( $dbhost, $dbuser, $dbpass)or die("Could not connect: ".mysql_error());
mysql_select_db($dbname, $conn) or die(mysql_error());

//Clean data

$_POST = array_map('strip_tags', $_POST);
$_POST = array_map('mysql_real_escape_string', $_POST);

$currentpassword = $_POST['currentpassword'];
$newpassword = $_POST['newpassword'];
$cnewpassword = $_POST['cnewpassword'];

if($newpassword == $cnewpassword)
{
    $query = "UPDATE `users` SET `password` = '".$newpassword."' WHERE `username` = '".$_SESSION['username']."' LIMIT 1";
$run = mysql_query($query);
if($run) {
echo "Congratulations You have successfully changed your password";
    include 'success.php';
exit();
         }
  else {
include 'password.php';
exit;
     }
}
else  {
    echo "The new password and confirm new password fields must be the same";
    include 'password.php';
    exit();
        }
?>

I'm guessing i need a && within the if statement to check the currentpassword with what is supplied within my database, but im not sure how to code this.

Lee

Validate A User Name And Password

Similar Tutorials

View Content

Having trouble trying to validate a user name and password. This is my code:

Code: [Select]
//check username/password
$user_name_check = mysql_query("SELECT * FROM users WHERE user_name=" . $_POST["user_name"] . "\" AND password=" . $_POST["password"] . "\"");
if(mysql_num_rows($user_name_check))
{
//Do stuff here...
}
But I get the following error:
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /xxxx/xxxxxxxx/xxxxx/xxxxxxxxxxxxx/xxxx.php on line 32

Any ideas as to why? $user_name_check is a result set right (which is what the mysql_num_rows() requires)??

Changing Md5 User Password

Similar Tutorials

View Content

I'm trying to write a script that changes my user passwords. I store the passwords in the DB as a md5 hash. My code is below, I keep getting error that the original username and password do not match. I require that the original credentials match so I can verify that I'm changing the password for the correct user.

I suspect my problem is here but I'm not su
Code: [Select]
$result = mysql_query("SELECT password FROM $tbl_name WHERE username='$username' and password = '".md5($pass)."'");
Code: [Select]
<?php
$username = check_input($_POST['username']);
$password = check_input($_POST['password']);
$newpassword = check_input($_POST['newpassword']);
$confirmpassword = check_input($_POST['confirmpassword']);

if (!isset($_POST['submit'])) { // if page is not submitted to itself echo the form
} else {
$result = mysql_query("SELECT password FROM $tbl_name WHERE username='$username' and password = '".md5($pass)."'");
if(mysql_num_rows($result)){
    if($newpassword==$confirmpassword){
        $sql=mysql_query("UPDATE $tbl_name SET password='$newpassword' where username='$username'");
        if($sql)
        {
                echo "Password Changed";
        }
        else
        {
            // In case when problem while updating your new password
           echo "Error changing password, please email webmaster@mydomain.com";
        }
    } else {
        // In case when new-password and retype-password do not match
        echo "New and confirmed password do not match please try again.";
    }
} else {
    // In case of you have not correct User name and password
echo "Current username and password do no match.";
}
}
?>

<div class="pageContent">
<div id="main">
<div class="container">
<h1></h1>
<h2>More text goes here.</h2>
</div>

<div class="container">

<?php
if($_SESSION['id']){
echo '<form action="" method="post">';
echo '<h2>Username: </h2><input type="text" name="username" size="50" maxlength="255"><br/>';
echo '<h2>Password: </h2><input type="text" name="password" size="50" maxlength="255"><br/>';
echo '<h2>New Password: </h2><input type="text" name="newpassword" size="50" maxlength="255"><br/>';
echo '<h2>Confirm Password: </h2><input type="text" name="confirmpassword" size="50" maxlength="255"><br/>';
echo '<input type="submit" name="submit" value="Change Password">';
echo '</form>';
} else {
echo '<h1>Please, <a href="index.php">login</a> and come back later!</h1>';
}
?>

</div>

<div class="container tutorial-info">
Footer goes here.
</div>
</div>
</div>

Any ideas?