PHP - Setting A Default Main Page

i'm creating a page counter which updates a value in a database each time the page is loaded.
I'm trying to make it so that it checks to see if a session has been set, if not, it updates the database, and then sets the session. This way it wont update every time someone refreshes the page.

$id=$_GET['id'];
if(!isset($_SESSION[$id])){
$_SESSION[$id]= $id;
$views = $row['views'] + 1;
$update_views=mysql_query("UPDATE topic SET views='".$views."' WHERE topic_id='".$id."'")

i want to set the session variable as that of the page id ($id)
The problem is that it keeps updating the database everytime the page is reloaded. I'm not sure if i'm setting the session variable correctly.
Any ideas would be great

Thanks

Hello! I've got exactly what I've wanted in my previous topic so I have decided to make a new topic for some help.

Quote

General
General Discussion
Description here

Entertainment Discussion
Description here

Gaming
Console Discussion
Description here

Handheld Discussion
Description here


And a database like this;
id title description parent 1 General description here 0 2 Gaming description here 0 3 General Discussion description here 1 4 Entertainment Discussion description here 1 5 Console Discussion description here 2 6 Handheld Discussion description here 2

Code: [Select]
<?php
function generate_forums($parent)
{
$has_childs = false;

global $forums_array;        

foreach($forums_array as $key => $value)        
{
if ($value['parent'] == $parent)
{
if ($has_childs === true)
{
$has_childs = false;
}
echo '<a href="/category/' . $value['title'] . '/">' . $value['title'] . '</a><br>' . $value['description'] . '';        
generate_forums($key);        
echo '<br>';
}
} 
}
generate_forums(0);
?>
The code works wonders. But it is hard to customize template wise.

$ID#1 $title = General
I would start off with <table>
I need to have the Categories that Parent = ( 0 ) to have a HTML <tr>
I also need the Categories with Parent = ( Value ) to have a HTML <td>
Then the tags would be closed off before $ID#2 $title = Gaming's template would start again.

I keep trying to scramble the coding around and can't seem to find that probably "simple" touch.
Thanks in Advanced.

Please help with my register page: http://www.retroandvintage.co.uk/register.php

after someone has registered they are stuck on reg_script.php and don't get redirected back to main.php being already logged in?!

here is my code:

Code: [Select]
  <?php
  session_start();
include_once("config.php");
//include_once("functions.php");
  require_once('captcha/recaptchalib.php');
  $privatekey = "6Ldhhr4SAAAAAKFoL2INOZV0_VuF6_z3OwDjVFNn";
  $resp = recaptcha_check_answer ($privatekey,
                                $_SERVER["REMOTE_ADDR"],
                                $_POST["recaptcha_challenge_field"],
                                $_POST["recaptcha_response_field"]);

  if (!$resp->is_valid) {
    // What happens when the CAPTCHA was entered incorrectly
    die ("The reCAPTCHA wasn't entered correctly. Go back and try it again." .
         "(reCAPTCHA said: " . $resp->error . ")");
  } else {
    // Your code here to handle a successful verification
 $rsPostCode = $_POST['rsPostCode'];
$rsGender = $_POST['rsGender'];
$rsUser = $_POST['rsUser'];
   $rsPass = $_POST['rsPass'];
$rsEmail = $_POST['rsEmail'];
$rsMobile = $_POST['rsMobile'];
$rsAge = $_POST['rsAge'];

   $sql = "INSERT INTO members_copy (RSPOSTCODE, RSGENDER, RSUSER, RSPASS, RSEMAIL, RSMOBILE, RSAGE) VALUES ('$rsPostCode', '$rsGender', '$rsUser', '$rsPass', '$rsEmail', '$rsMobile', '$rsAge');";
//echo $sql;
mysql_query($sql);


$ebits = ini_get('error_reporting');
error_reporting($ebits ^ E_NOTICE);
/*
Login script:
This script does the following:

Checks that the user is NOT already logged in - if they are they
are redirected to the members page by the 'checkLoggedIn()' function.

Checks if the login form has been submitted - if so, the 'login' and
'password' fields are checked to ensure they are of the correct format and length.
If there are any problems here an error is added to the $messages array and
then the script executes the 'doIndex()' function - this function basically
outputs the main 'index' page for this script - ie the login form.

If there are no problems with the previous step, the 'login' and 'password'
field data is passed to the 'checkPass' function to check that an entry
exists in the 'users' table for that login/password pair.
If nothing is returned from the 'checkPass()' function, an error is
added to the $messages array and the 'doIndex()' function is called as above.

If a row of data is returned from the 'users' table, the data is passed to
the 'cleanMemberSession()' function - which initializes session variables and
logs the user in.  The user is then forwarded to the members page.

If the form hasn't yet been submitted, then the 'doIndex()' function is called
and the login page is displayed.
*/
// Check user not logged in already:
checkLoggedIn("no");

// Page title:
$title="Member Login Page";

// if $submit variable set, login info submitted:
if(isset($_POST["Register"])) {
//
// Check fields were filled in
//
// login must be between 4 and 15 chars containing alphanumeric chars only:
field_validator("rsUser", $_POST["rsUser"], "alphanumeric", 4, 15);
// password must be between 4 and 15 chars - any characters can be used:
field_validator("rsPass", $_POST["rsPass"], "string", 4, 15);

// if there are $messages, errors were found in validating form data
// show the index page (where the messages will be displayed):
if($messages){
doIndex();
// note we have to explicity 'exit' from the script, otherwise
// the lines below will be processed:
exit;
}

// OK if we got this far the form field data was of the right format;
// now check the user/pass pair match those stored in the db:
/*
If checkPass() is successful (ie the login and password are ok),
then $row contains an array of data containing the login name and
password of the user.
If checkPass() is unsuccessful however, $row will simply contain
the value 'false' - and so in that case an error message is
stored in the $messages array which will be displayed to the user.
*/
    if( !($row = checkPass($_POST["rsUser"], $_POST["rsPass"])) ) {
// login/passwd string not correct, create an error message:
        $messages[]="Incorrect login/password, try again";
    }

/*
If there are error $messages, errors were found in validating form data above.
Call the 'doIndex()' function (which displays the login form) and exit.
*/
if($messages){
doIndex();
exit;
}

/*
If we got to this point, there were no errors - start a session using the info
returned from the db:
*/
cleanMemberSession($row["rsUser"], $row["rsPass"]);

// and finally forward user to members page (populating the session id in the URL):
header("Location: main.php");

/*
This function displays the default 'index' page for this script.  This consists of just a simple
login form for the user to submit their username and password.
*/
}
}
?>

Hello

First of all, my code is old, modified etc, I know. I can't afford for someone to reprogram it from scratch.

So, with your help I think a novice like me can progress the script into the next stage.

http://pastebin.com/580vaMFa

Current code - http://pastebin.com/580vaMFa

Current url http://runehints.com/calculators - use gaogier

Test page - not set up yet.

What I need this to work and look like, http://runehints.com/images/calclayout.png

If your username can't be found for that skill, RuneScape Name should become Current Exp


What should I do first shortern the URL? Make the script from 3 pages to just 1?

Problem: The page does not redirect the end user to main.php.

Notice: Use of undefined constant name_id - assumed 'name_id' in C:\x\xampp\htdocs\pages\form_process.php on line 48

Warning: Cannot modify header information - headers already sent by (output started at C:\x\xampp\htdocs\pages\form_process.php:48) in C:\x\xampp\htdocs\pages\form_process.php on line 87

The error messages displayed above make it seem like they are connected to the problem, but I don't understand why 'name_id' is undefined as its auto increments in mysql.

I also think my .htaccess might be preventing me from redirecting, is that possible?

" header('Refresh: 5; URL=http://localhost/pages/main.php'); "

Goal: redirect user to main.php without error messages being displayed.

form_process.php

<?php   

//let's start our session, so we have access to stored data
session_start();

if (isset($_POST['terms_and_conditions']) == 0) {
  // the code was incorrect
  // handle the error accordingly with your other error checking

  // or you can do something really basic like this
  die('You must agree to the terms and conditions to create a profile.  Go back and try again.');
}

include_once $_SERVER['DOCUMENT_ROOT'] . '/securimage/securimage.php';

$securimage = new Securimage();

if ($securimage->check($_POST['captcha_code']) == false) {
  // the code was incorrect
  // handle the error accordingly with your other error checking

  // or you can do something really basic like this
  die('The code you entered was incorrect.  Go back and try again.');
}

else {
include 'db.inc.php';

$db = mysql_connect(MYSQL_HOST, MYSQL_USER, MYSQL_PASSWORD) or 
    die ('Unable to connect. Check your connection parameters.');
mysql_select_db(MYSQL_DB, $db) or die(mysql_error($db));
  
$error = array();
  
    $query = 'SELECT name FROM user WHERE ' .
         'name = "' . mysql_real_escape_string($_SESSION['values']['name'], $db) . '"' ;
    $result = mysql_query($query, $db) or die(mysql_error($db));

if(mysql_num_rows($result) > 0) {
$error['uname'] = '<p class="errText">Username is taken.</p>';
        header('Refresh: 5; URL=form1.php');
}
//let's create the query
else{
$query = sprintf("INSERT INTO user (
name_id, name, password)
VALUES ('%s','%s','%s')",
name_id,
mysql_real_escape_string($_SESSION['values']['name']),
mysql_real_escape_string(md5(SALTY . $_SESSION['values']['password'])));

//let's run the query
$result = mysql_query($query, $db) or die(mysql_error($db));

$name_id = mysql_insert_id();

$query = sprintf("INSERT INTO contact (
name_id, first_name, last_name, email, address, city, county,
post, home, mobile)
VALUES (LAST_INSERT_ID(),'%s','%s','%s','%s','%s','%s','%s','%s','%s')",
mysql_real_escape_string($_SESSION['values']['first_name']),
mysql_real_escape_string($_SESSION['values']['last_name']),
mysql_real_escape_string($_SESSION['values']['email']),
mysql_real_escape_string($_SESSION['values']['address']),
mysql_real_escape_string($_SESSION['values']['city']),
mysql_real_escape_string($_SESSION['values']['county']),
mysql_real_escape_string($_SESSION['values']['post']),
mysql_real_escape_string($_SESSION['values']['home']),
mysql_real_escape_string($_SESSION['values']['mobile']));

//let's run the query
$result = mysql_query($query, $db) or die(mysql_error($db));

$name_id = mysql_insert_id();

$query = sprintf("INSERT INTO profile (
 name_id, bi, ex)
VALUES (LAST_INSERT_ID(),'%s','%s')",
mysql_real_escape_string($_SESSION['pro']['bi']),
mysql_real_escape_string($_SESSION['pro']['ex']));

$result = mysql_query($query, $db) or die(mysql_error($db));

        $_SESSION['logged'] = 1;
        

        header('Refresh: 5; URL=http://localhost/pages/main.php');
}

?>
<html>
 <head>
  <title>Register</title>
 </head>
 <body>
  <p><strong>Thank you <?php echo $_SESSION['values']['name']; ?> for registering!</strong></p>
  <p>Your registration is complete! You are being sent to the page you
requested. If your browser doesn't redirect properly after 5 seconds,
<a href="main.php">click here</a>.</p>
 </body>
</html>
<?php
session_destroy();
        die();
    }

?>

Hey guys can anyone give me some advise on how to setup up when the member logs in it also logs them into the forum rather than having to register twice and stuff?

Hi,   I have an address on my main server http://www.website.com/directory and would like to redirect it to a subdomain http://subdomain.website.com/directory   The subdomain is not pointing to the same server as the main domain.   How would I set up a redirect in htaccess?   Thanks!  

How to define default folder. For example I have folder images and in that folder specific image. In the root directory I have index.php with
Code: [Select]
<?php require_once("public/includes/header.php"); ?>and in index.php there are links which goes to different folder:
  Code: [Select]
<a href="public/sajt/kategorija.php?id=<?php echo $id;  ?>">which also have header.php, but there is no image. How to make default folder for image, or some similar solution?

I have this code, for an Upload Form, that works successfully renaming and moving an uploaded file to the upload/ folder. 

I have a few dropdown forums and would like it to select the current values that are requested.

Code: [Select]
global $filename,$fileid,$filetype,$filedir,$fileby;
  global $months,$pg;


echo "<h2>Search Files</h2>";
echo "<p>";
  echo "<form name = 'File_Search' action = '#' method = 'POST'>";
echo "<table border=\"0\" width=\"100%\"><tr>";
echo "<td>File Name<br><input type = 'text' name = 'name'></td><td>File Type<br><select name = 'type'>
<option value = '0'>All Types</option>
  <option value = 'o'>Official Files</option>
<option value = '1'>Quests</option>
  <option value = '2'>Graphic/Spritesheets</option>
  <option value = '3'>Entity/Scripts</option>
  <option value = '4'>Sound/Music</option>
  <option value = '5'>QuestPack/Programs</option>
  <option value = '6'>Miscellaneous</option>
  </select></td>";
  echo "<td>Order By<br><select name = 'order'>
  <option value = '0'>Last Updated</option>
  <option value = '1'>ID</option>
  <option value = '2'>Name</option>
  <option value = '3'>Downloads</option>
  <option value = '4'>Rating</option>
<option value = '5'>Points</option>
  <option value = '6'>Random</option>
  </select></td>";
  echo "<td>Acending?<br><select name = 'dir'><option value = '0'>False</option><option selected value = '1'>True</option></select></td>";
echo "</tr><tr><td rowspan = '4'><input type = 'submit' name = 'search' value = 'search'></td></tr></table></form>";
echo "</p>";

So if the $filetype equals 2 I want the dropdown box to show "Graphic/Spritesheets" by default. BTW Official Files is not actually a type so that's why I chose to give it a small letter o and will work the same way as All Types but run a different function.

$fileby is used for the OrderBy field.
$filedir is for the Acending field.
The other data is for the other parts of the script.

If you like you can give advice on the name's default because you may have a better method then what I have in my head.

I am using this php code <?php echo $_GET['CiFrame']; ?> to check the url for the variable CiFrame, this allows me to link to a page through my page containing the iframe.

Here is my iframe code.
<iframe name="CiFrame" width="727" height="805" src="<?php echo $_GET['CiFrame']; ?>" scrolling="auto" frameborder="0"></iframe>

The problem is that if the url does not contain a variable the iframe will not open a page. How can i set a default variable if one is not provided?

Thank You

Hi guys and gals ,

got a minor problem.  I have a table in which i want the "photo" column to have a default value of "noimage.jpg".

I set the default value to "noimage.jpg" and put "as defined" too.

but when i fill the form in and leave the upload field blank it doesnt show the noimage.jpg as it should and in the mysql table it leaves it blank and not with default value.

Here is the inserts.php which adds the data to the mysql table.   

Can you help please.

<CENTER><B>Vehicle Added</B></CENTER>
<BR>

<?php

mysql_connect("localhost", "wormste1_barry", "barry") or die(mysql_error());
mysql_select_db("wormste1_barry") or die(mysql_error());

$CarName = mysql_real_escape_string(trim($_POST['CarName']));
$CarTitle = mysql_real_escape_string(trim($_POST['CarTitle']));
$CarPrice = mysql_real_escape_string(trim($_POST['CarPrice']));
$CarMiles = mysql_real_escape_string(trim($_POST['CarMiles']));
$CarDescription = mysql_real_escape_string(trim($_POST['CarDescription']));
$pic = mysql_real_escape_string(trim($_FILES['uploadedfile']['name'])); 


$target_path = "images/";

$target_path = $target_path . basename( $_FILES['uploadedfile']['name']); 

if(move_uploaded_file($_FILES['uploadedfile']['tmp_name'], $target_path)) {
    echo "The file ".  basename( $_FILES['uploadedfile']['name']). 
    " has been uploaded";
    echo "<br />";
} else{
    echo "There was an error uploading the file, please try again!";
}



mysql_query("INSERT INTO cars 
(CarName, CarTitle, CarPrice, CarMiles, CarDescription, photo) VALUES('$CarName', '$CarTitle', '$CarPrice', '$CarMiles', '$CarDescription', '$pic' ) ") 
or die(mysql_error());  


echo "The vehicle data has been added!";

?>

Hi, I am trying to get the date and time that a particular table was last updated, which the code below does, but it doesn't seem to be putting it in the correct timezone, it is 5 hours behind, anyone know why this is? or how i can fix it? Thanks

Code: [Select]
<?php
date_default_timezone_set('Europe/London');
        $query = "SELECT UPDATE_TIME FROM information_schema.tables WHERE TABLE_SCHEMA = 'tffdb' AND TABLE_NAME = 'test_team_points'";
        $result = mysql_query($query) or die(mysql_error());
        
        $row = mysql_fetch_assoc($result);
echo $row['UPDATE_TIME'];

?>

In a Switch statement, can you give the Default: a specific name, maybe like this...


switch ($resultsCode){
// Missing Primary Key.
case 'COMMENT_MISSING_KEYS_2050':
echo '<h1>System Error</h1>';
echo '<p>A Fatal Error has occurred.  Please contact the System Administrator. (2050)</p>';
break;

default 'DEFAULT_CATCHALL_ERROR_CODE_9999':
echo '<p>You have reached the catch-all error code... (9999)</p>';
break;



Debbie

How do I set the date format so that it's always going by the UTC date?

I've used:
Code: [Select]
date_default_timezone_set('UTC');
but, when I change my date on my computer, the date changes on the website.

This is really confusing me, googled different ways for like 10/20 minutes and can't find anything.

If anyone can help it'd be great,

Thanks,
Andy.