PHP - Get Ini Section Names

Can i open a pdf within a page? e.g. within <td> or <table> of htmls so that it appears on a section of a page where someone can just read through and still able to browse the web page. I dont want the PDF downloading or taking the whole page or even opening a new window and filling it.

Thanks in advance.

I don't even really know how to title it. I have this piece of code, i wrote. it works with wordpress api but honestly i don't think that matters much.
what it does, is pick $ci number of categories, and then picks 2 posts from each category. it then assigns the image in/attached to that post to an array, to be used later.

this all works fine, the problem is when it picks a post that doesn't have an image. right now, it can't tell that. writing in a bit to be able to tell whether there is an image or not should be easy. i'm thinking it can be as basic as file_exists or as complicated as parsing the post. the part i have the problem with - is how do i make it go back and pick another post/category when it comes up short? more than once? i want it to keep going back until it comes up with an image.

i'd rather not expand the search any farther than necessary

Code: [Select]
<?php
if ( false === ( $scroller = get_transient( $stransient ) ) ) {
if (!is_array($scroller) || count($scroller)==0) {
$args = array( 'type' => 'post', 'parent' => 18, 'exclude' => 63, 149, 278, 62 );
$companies = get_categories( $args );
while (count($companies) > $ci){unset($companies[array_rand($companies)]);}
shuffle($companies);$truckco= array();
foreach ($companies as $company){
$argus = array('numberposts' => 2, 'orderby' => 'rand', 'post_type' => 'post', 'category' => $company->cat_ID );
$listings = get_posts($argus);
foreach($listings as $tn=>$post) {
$truckco[$company->slug]['truck_'. $tn]['image'] = get_the_image( array( 'image_scan' => true, 'format' => 'array', 'width' => '172', 'height' => '129' ) );
$truckco[$company->slug]['truck_'. $tn]['pid'] = $post->ID;
}
}
?>

thank you

Hello.
Well I haven't any code for this, but its only a question.
Do you think it would be possible for PHP, to make and image or draw one from just a blank JPG.
Then placing text on the image.

That is possible and quite simple.
But do you think it is possible to say.
Say if you have 3 different set of texts on the image.
Click here for 1
Click here for 2
Click here for 3

And also for the script to link those text to different web addresses.
But all still workable with a dynamic signature EG [ img ] [ / img ]

Basically its a dynamic signature with links on it is what i am trying to say.
Do you think its possible? Or am I thinking to big.

I think it would be interesting and useful to many to make a do and don't section or pinned post for most sections.   Editable by admins and mods to keep organized   Like the phpfreaks bible of coding, best practices.   A lot of members post some valuable information that gets lost old posts or too hard to search for. Everyone repeating themselves on bad practices or deprecated code, turning on error reporting and such.

I'm working on the following assignment and keep coming up with error messages.  

"Warning: require(mysqli_connect_registrar.php): failed to open stream: No such file or directory in /home/students/r/b.richards/public_html/cis231/labs/sectionresults.php on line 3

Fatal error: require(): Failed opening required 'mysqli_connect_registrar.php' (include_path='.:/usr/share/pear:/usr/share/php') in /home/students/r/b.richards/public_html/cis231/labs/sectionresults.php on line 3"

I've included the code I have and any help would be appreciated.  

Thank you.

Assignment Directions:

Introduction

This lab will demonstrate how to create a dynamic form that is created from database contents. And then that form will be used to pull results from the database, based on the user's selection.

 

STEP 1 - Create the Database Connection File

In your labs directory, define a mysql_connect.php file for the registrar database (with the student | student credentials).

 

STEP 2 - Create the Form

Define the form as sectionsearch.php. Create a dynamic form with a drop-down menu listing available courses by title. (Note: the courseID will be the value that is posted to the results page.)

 

Step 3 - Create the Results page

Define the results page as sectionresults.php. Present the results of the query for sections (unless there are none—then show an appropriate message).

If there are results, use an HTML table (dynamically-generated) to display available sections with the following information:

Faculty last name

Room number

Class meeting day(s)

Start time

End time

The information should be sorted by the faculty member's last name.

Note: You will need to consult the structure of the database tables to determine which fields need to be drawn from which tables and how to join the appropriate tables needed for the query.

Sectionsearch.php code:

<!doctype html>
<html>
<head>
<meta charset="utf-8">
<title>Section Search</title>
</head>
<!doctype html>
<html lang="en">

<head>
    <meta charset="utf-8">
    
    <title>Search for Courses</title>
    
    <link href="cis231.css" rel="stylesheet" type="text/css">
</head>

<body>

<form id="form1" name="form1" method="post" action="sectionresults.php">
<h1>Search for courses</h1>

<p>Courses
<select name="courseID" id="courseID">
    <option value="100">Java for Dummies</option>
    <option value="101">Advanced Web Servers </option>
    <option value="102">Empire Management</option>
    <option value="103">Stone Age History </option>
    <option value="104">The Presidency</option>
    <option value="105">Evolutionary Theory</option>
    <option value="106">Global Warming</option>
    <option value="107">Philosophy of Humor</option>
    <option value="108">American History</option>
    <option value="109">Horror Tales</option>
    <option value="110">Introduction to the Internet</option>
    <option value="111">Principles of Information Systems</option>
    <option value="112">Contemporary American Poetry</option>
    <option value="113">Introduction to Spanish</option>
    <option value="114">Business Spanish</option>
    <option value="115">Business Math 2</option>
    <option value="116">Italian Literature</option>
    <option value="117">Italian Literature</option>
    <option value="118">Italian Literature</option>
    <option value="119">Quantum Physics</option>
    <option value="120">Business Ethics</option>
    <option value="121">Introduction to Sociology </option>
    <option value="122">Redundancy 101</option>
</select>
</p>

<p>
<input type="submit" name="submit" id="submit" value="Search for courses">
<input type="reset" name="reset" id="reset" value="Restart Search">
</p>

</form>
</body>
</html>

mysql_connect.php code:

<!doctype html>
<html>
<head>
<meta charset="utf-8">
<title>Lab 7</title>
</head>
<?php

//Set database connection information
define('DB_HOST', 'localhost'); //Or could be a different server
define('DB_USER', 'username'); //MySQL credentials
define('DB_PASSWORD', 'password'); //MySQL credentials 
define('DB_NAME', 'registrar'); //Specific database

//Database connection
$dbc = @mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME)
       OR die('Connection error');

//Set the encoding
mysqli_set_charset($dbc, 'utf8'); //Or whatever PHP script encoding and database collation you are using
?>
<body>
</body>
</html>

sectionresults.php code:

<?php
//Connect to the database
require('mysqli_connect_registrar.php');

$cat = "";
if (isset($_POST['courseID']))
{
    $cat = $_POST['courseID'];

    $q = "SELECT lastame,  FROM faculty WHERE registrar = $cat ORDER BY lastname ASC";
    $r = @mysqli_query($dbc, $q);
    $numRows = mysqli_num_rows($r);
} 
?>    
!doctype html>
<html>
<head>
<meta charset="utf-8">
<title>Search Results</title>
</head>
<body>
    <?php
if ($cat == "") //No posted data
{
?>
    <h2 class="centered">No class selected.</h2>
    <p class="centered">Please return to make a <a href="sectionsearch.php">class selection</a>.</p>
<?php
}
elseif ($numRows == 0) //No classes according to category selection
{
?>
    <h2 class="centered">No classes in your category.</h2>
    <p class="centered">Please return to make a different <a href="sectionsearch.php">class selection</a>.</p>
<?php
    //Free recordset
    mysqli_free_result($r);
} 
else //There are results
{
?>
    <div class="centered">
    <table border="1">
      <thead>
        <tr>
          <th>Last Name</th>
          <th>Room Number</th>
          <th>Meeting Days</th>
          <th>Class Start Time</th>
          <th>Class End Time</th>
        </tr>
      </thead>
        
<tbody>
      <?php
      while ($row = mysqli_fetch_array($r))
      {
      ?>
        <tr>
          <td><?php echo $row['lastname']; ?></td>
          <td><?php echo $row['room_num']; ?></td>
          <td><?php echo $row['days']; ?></td>
          <td><?php echo $row[starttime]; ?></td>
            <td><?php echo $row[endtime]; ?></td>
        </tr>
      <?php
      }
      //Free recordset
      mysqli_free_result($r);
      ?>
      </tbody>
          </table>
<?php
}
?>
</body>
</html>

Edited October 18, 2019 by BIGB185

hi i have got the following issues i am using the following code.

Code: [Select]
<?php

//DB CONNECTION

$ROWS = "id,firstname,lastname";

// explode at the comma and insert into an array
$test = explode("," , $ROWS);

//adds array test to the var sam
$sam = array($test);

// querys the database
$new = mysql_query("SELECT * FROM {$DB_TABLE}");

// while loop to loop through selected fields
while ($row = mysql_fetch_array($new)) {

foreach ($sam[0] as $v) {

echo $row[$v] . $DELIMITER . "<br />";

}

}
?>
i get the following results.

834(|)
Steph(|)
Thompson(|)
835(|)
Lucy(|)
kim(|)
836(|)
Iwan(|)
Will(|)
837(|)
Sarah (|)
Good(|)

The problem i have is the br tag where do i put it because i need it to output like this. like it shows in the $ROWS variable above "$ROWS = "id,firstname,lastname";";


834(|)Step(|)Thompson(|)
835(|)Lucy(|)kim(|)
836(|)Iwan(|)Will(|)
837(|)Sarah (|)Good(|)

Where do i add the br tag???

Any Help PLease

Hi, first of all I am trying to do a section hidden from guests on a website. I have groups for each user (groups_admin, _mod, _member etc.)   I have it so ADMIN only view content at the moment, but not sure how to add GROUPS_MOD & GROUPS_MEMBER:

<?php echo $user_data['group_id'] == GROUPS_ADMIN ? 'content' : ''; ?>

Secondly, where the content section is, I have HTML placed inside it which works fine, but it also has some PHP code.   How would I get it so the php code works? This is what I have...

<?php echo $user_data['group_id'] == GROUPS_ADMIN ? '<form method="post" action="<?php echo get_url(\'/products/\', $product[\'category_id\'], $product[\'product_id\'], $product[\'product_name\']); ?>?action=review">' : ''; ?>

As you can see the form action line has a php url to generate the relevant link for a specific product.   If anyone has any suggestions or can help in any way that would be much appreictaed.   Cheers,   Paul

Hi,

I have some queries that update some statistics in a table I have. I need these queries to run only after 15 seconds have passed however. This way if the user leaves before the 15 seconds, the queries won't run. I've tried using Sleep, however it seems to just stop all the code all together for the allotted time. There must be a way to do this.

Hey everyone!

Thanks for taking the time to help. I have two files..a membership area and a commenting section. I am fairly new at these subjects but I am a quick learner. First off, I need help figuring out why my "register.php" in the members area file isn't working properly, everything looks to be ok but maybe I have been working on this too long. Quite frankly I can't check and see if all of the other scripts are correct because I can't get past the "register.php". So if you all wouldn't mind helping me out on this part, I would greatly appreciate it

Secondly, I have a commenting section and in the "demo.php", there is a warning that appears as follows: "Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in C:\Program Files (x86)\EasyPHP-5.3.8.1\www\comments\demo.php on line 17
" If someone could tell me what is missing or help me figure out what to do in simple terms, I would greatly appreciate that as well.

Thanks!
Gene

[attachment deleted by admin]

Commented in red is the code that doesn't produce anything. It is 3/4 of the way down the page..
Thanks for looking!


Code: [Select]
<?php
error_reporting(E_ALL);
ini_set("display_errors", 1);

$host= "";
$db_name= "";
$db_user= "";
$db_password= "";

ob_start();

if(isset($_POST['newBidder'])) {
$newBidder= isset($_POST['newBidder']) ? $_POST['newBidder'] : '';
$bidderId= $newBidder;

mysql_connect("$host", "$db_user", "$db_password")or die("cannot connect to server");
mysql_select_db("$db_name")or die("cannot select DB");

$sql="SELECT * FROM bidders WHERE biddersId='$bidderId'";
$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==0){
// Add $biddersId and redirect to anypage
mysql_Query("INSERT INTO bidders (biddersId)
VALUES ('$bidderId')");
 header("Location: index.php");
exit();
  }
}

////////////////////////////////////

if(isset($_POST['deleteBidder']))
{
$deleteBidder= isset($_POST['deleteBidder']) ? $_POST['deleteBidder'] : '';
mysql_connect("$host", "$db_user", "$db_password")or die("cannot connect to server");
mysql_select_db("$db_name")or die("cannot select DB");

mysql_query("DELETE FROM bidders WHERE biddersId='$deleteBidder'");
 header("Location: index.php");
exit();
}

////////////////////////////////////

if (isset($_POST['itemDescription'], $_POST['itemPrice'], $_POST['winningBidder'], $_POST['itemQty']))
{
$itemDescription= isset($_POST['itemDescription']) ? $_POST['itemDescription'] : '';
$itemPrice= isset($_POST['itemPrice']) ? $_POST['itemPrice'] : '';
$winningBidder= isset($_POST['winningBidder']) ? $_POST['winningBidder'] : '';
$itemQty= isset($_POST['itemQty']) ? $_POST['itemQty'] : '';

mysql_connect("$host", "$db_user", "$db_password")or die("cannot connect to server");
mysql_select_db("$db_name")or die("cannot select DB");

$sql="SELECT * FROM bidders WHERE biddersId='$winningBidder'";
$result=mysql_query($sql);

$count=mysql_num_rows($result);
// If result matched, table row must be 1 row

if($count==0){
echo "That Bidder Number is NOT logged in, ";
echo "would you like to set this bidder as active?";
echo " Enter 1 for NO or 2 for YES";
echo "<form action= \"process.php\" method= \"POST\">";
echo "<input type =\"text\" name= \"logUser\"/>";
echo "<input type= \"submit\" value = \"Submit\"/>";
exit();
  }
}
$logUser= isset($_POST['logUser']) ? $_POST['logUser'] : '';
if ($logUser= '1') {
header("Location: inprogress.php");
exit();
}

if ($logUser= '2'){

// Add $biddersId and redirect to anypage
mysql_connect("$host", "$db_user", "$db_password")or die("cannot connect to server");
mysql_select_db("$db_name")or die("cannot select DB");

mysql_Query("INSERT INTO bidders (biddersId)  ////This won't add biddersid to database///////[
VALUES ('$winningBidder')");

 mysql_query("INSERT INTO transactions       /////This won't add details to the database either?/////
 VALUES('$itemDescription', '$itemPrice','$winningBidder', '$itemQty', '$totalPrice')")
or die(mysql_error());   
header("Location: inprogress.php");
exit();
   }

//////////////////////////////////////// 




echo "<font color= \"red\" face=\"calibri\" size=\"4\">That bidder is already logged, Please press your browsers back button and try again.</font>";

ob_end_flush();

?>

I have one database with 2 tables as follows
bidders table ONLY has biddersId field;
transactions has (in order) itemDescription, itemPrice, bidderId, itemQty, totalPrice

everything else works, except updating the database with the above?

Am I doing something wrong in MySql. I have all eroors on , but i get NONE when running the script?

Hello, I am hoping to get some help with this. I want to apologize in advance as I am not a developer more of a systems admin guy. Okay guys, here is the deal. My boss has a website, which uses from my understanding Wordpress for design, but also uses PHP. Since, I am not too familiar with the general uses of PHP, I cannot explain why they are doing it that way. The website also uses MYSQL, which I would imagine works with PHP to gather data from some back end server.    The website has five tabs on the top right corner    about   services  resources   contact us   login   When you hover over these five tabs they expand and show more menus. The tab with the issue is the services tab. When you hover over it, it works as anticipated; it expands and shows our services. Upon getting on there, there are a bunch of services, which you can click on. When you first click, it works as anticipated. However, if you try to click on another service within that category, it simply does not load the page. Now if you decide to go into a different service it works, but once you try to click on another services within x category it just does not work.   I would really appreciate everyone's help on this. It would be nice to get this resolve.    I can provide you guys with the website and php scripts and codes if need be.   This is the website    http://beta.morrowco.com/     Thanks, Jeff M        

Hi,

I'm trying to invert a random section of an image. The only way I've thought of doing this in PHP, is to split the image up into sections using imagecopyresampled then negate one of the sections using the imagefilter IMG_FILTER_NEGATE. Then put them all back together using imagecopymerge. Now I have managed to get this working when negating the first section ($split_first), but whenever I try to negate any other section (e.g. $split_sec) nothing happens. Now I know my code doesn't randomly invert it, I'm just trying to get it to work for each section first then I'll try get that working. Below I have posted my code.

Any help would be be appreciated,

Thank you in advance!

<?php
$image=imagecreate(400, 100);
$red = imagecolorallocate($image, 255, 0, 0);
imagefill($image, 0, 0, $red);
$split_first=imagecreate(100, 100);
$split_sec=imagecreate(100, 100);
$split_thir=imagecreate(100, 100);
$split_four=imagecreate(100, 100);

imagecopyresampled($split_first,$image,0,0,0, 0,100,100,100,100);
imagecopyresampled($split_sec,$image,100,0,100,0,100,100,100,100);
imagecopyresampled($split_thir,$image,200,0,200,0,100,100,100,100);
imagecopyresampled($split_four,$image,300,0,300,0,100,100,100,100);


imagefilter($split_sec, IMG_FILTER_NEGATE);

imagecopymerge($image,$split_first,0,0,0,0,100,100,100);
imagecopymerge($image,$split_sec,100,0,100,0,0,100,100);
imagecopymerge($image,$split_thir,200,0,200,0,0,100,100);
imagecopymerge($image,$split_thir,300,0,300,0,0,100,100);

imagepng($image);
imagedestroy($image);
header('Content-Type: image/png');
echo $image;
?>

im taking my ojt.
i posted on different linux forums but no one replied

i have php code that displays reports. and i want to add html code for UI. but it does'nt appear.
i cant install xampp or anything so is there another way to run my code?

help pls.

hope someone can help me out here, stuck on this page...
This page shows the details of the listing they had just clicked on on the previous page. this part works
If the person logged in is the person who is looking at the page, the email section does not show. this part works
However, the part I cannot get to work, is when the logged in user types their email message and clicks send email. at this point the details of listing stop showing
please SOMEONE HELP ME
thanks in advance, i hope
Code: [Select]
<?php
  // Start the session
  require_once('startsession.php');

  // Insert the page header
  $page_title = 'Listing Details';
  require_once('header.php');

  require_once('connectvars.php');

  // Show the navigation menu
  require_once('navmenu.php');
 

if(isset($_POST['submit'])){
 $dbc = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME); 

  // Retrieve the user data from MySQL
  $query1 = 'SELECT email FROM ob_user WHERE username="' . $user_name . '"';
  $data1 = mysqli_query($dbc, $query1);
  $row1 = mysqli_fetch_array($data1);
  
  $email = $row1['email'];
  
 $to = $email;
 $subject = 'OurBazzar response to' . $subject . '';
 $body = $_POST['email'];
 $headers = 'From: caleb.jordan.flax@gmail.com';
 if (mail($to, $subject, $body, $headers)) {
   echo("<p>Message sent!</p>");
  } else {
   echo("<p>Message delivery failed...</p>");
  }
  end();
}



  if (isset($_GET['listing_id']) && isset($_GET['subject']) && isset($_GET['description']) && isset($_GET['price']) && isset($_GET['date']) && isset($_GET['city']) && isset($_GET['state']) && isset($_GET['user_id']) && isset($_GET['category_id'])) {
  
    // Grab the score data from the GET
    $listing_id = $_GET['listing_id'];
    $title = $_GET['subject'];
    $description = $_GET['description'];
    $price = $_GET['price'];
    $date = $_GET['date'];
$city = $_GET['city'];
    $state = $_GET['state'];
    $userid = $_GET['user_id'];
    $categoryid = $_GET['category_id'];

  }

// Connect to the database 
  $dbc = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME); 

  // Retrieve the user data from MySQL
  $query = 'SELECT username FROM ob_user WHERE user_id="' . $userid . '"';
  $data = mysqli_query($dbc, $query);
  $row = mysqli_fetch_array($data);

  $query1 = 'SELECT name FROM ob_category WHERE category_id="' . $categoryid . '"';
  $data1 = mysqli_query($dbc, $query1);
  $row1 = mysqli_fetch_array($data1); 
  
$user_name = $row['username'];
$category_name = $row1['name']; 

echo '<table>';
echo '<tr><td colspan="2"><strong>' . $title . '</strong></td></tr>';
echo '<tr><td>Created by: </td><td>' . $user_name . '</td></tr>';
echo '<tr><td>Date created: </td><td>' . $date . '</td></tr>';
echo '<tr><td>Location: </td><td>' . $city . ', ' . $state . '</td></tr>';
echo '<tr><td>Category: </td><td>' . $category_name . '</td></tr>';
echo '<tr><td>Description: </td><td>' . $description . '</td></tr>';
echo '</table>'; 

if ((isset($_SESSION['username'])) && ($_SESSION['username'] != $user_name)) {

?>

<br />
<form method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>">
<fieldset>
<legend>Send Email to <?php echo $user_name; ?></legend>
<label for="email">Message: </label>
<input type="text" name="email" /><br />
<input type="submit" value="Send Email" name="submit">
</fieldset>

<?php

}
require_once('footer.php');
?>

Okay, I have no idea how this works out but this is really getting on my nerves.

Here is my logic for the following code. I manually register a user, It goes into the database and dispatches an email notification explaining that a user must activate their account and change their user name (OPTIONAL) and password. In the email, There is an automatically generated password with the username, And a link to activate the account. This leads to stage 1 of the activation process, In this stage the user is accepted, Registered as a verified user and then is sent to another page to change the details like login and password. As far as I know this page works except through trial and error I found that this little snippet of code is causing browsers to show an error 500 page, If I remove this the page works:

<?php
if($messages){

displayErrors($messages);
} else {

echo("<p align=\"center\" class=\"standard\">Your account has been activated.</p><p align=\"center\" class=\"standard\">You now need to change your password. If you like you can also change your username, Remember that you only have 3 days to do so and this change will be permanent.</p>");
}
?>

and this is the displayErrors function:

<?php
function displayErrors($messages) {

print("<p align=\"center\" class=\"standard\">"."<b>There were problems with the previous action:</b>\n<ul>\n");

foreach($messages as $msg){

print("<li>$msg</li>\n");

}

print("</ul>\n"."</p>");
}
?>


The displayErrors function is in a file called functions.php, Which is included in config.php, Which is included in every page including this one.

The entire "Change password and login page thingie" is he


<?php
include("config.php");
global $link, $messages;
require_once('recaptchalib.php');
if($_GET['error']){

$id=$_GET['id'];

$messages[]="There is more than one or no accounts with the verification code you are using. <a href=\"mailto:rentals@nivso.co.uk?subject=Two or no accounts with activation ID of $id\">Click here to email us about this and have the problem sorted.</a>";

doIndex();

exit;
}
if(isset($_POST['submit'])){

if(!isset($_POST['activationid'])){

die("Doesn't exist -.- might as well quit this is *STUFF* -.-");

}

$privatekey = "YOUR NOT HAVING THIS";

$resp = recaptcha_check_answer ($privatekey,

$_SERVER["REMOTE_ADDR"],

$_POST["recaptcha_challenge_field"],

$_POST["recaptcha_response_field"]);

if (!$resp->is_valid) {

$messages[]="The code you entered is incorrect. Please go back and try again!";

doIndex();

exit; // exit or the below lines will be processed.

} else {

//This is where the fun starts!

$login=$_POST['login'];

$passw=$_POST['password'];

$passc=$_POST['passwordc'];

$id2=$_POST['activationid'];

$changinglogin=false;

$get1=excDB("SELECT * FROM `users` WHERE `activeID`='$id2'");

if($get1[0]){ $get1=$get1[1]; } else { die($get1[2]); }

$pro1=mysql_fetch_array($get1);

if($pro1['login']!=$login){

$changinglogin=true;

field_validator("Login", $login, "alphanumeric", 4, 15);

}

field_validator("Password", $passw, "string", 6, 20);

if($passw!=$passc){

$messages[]="The passwords do not match, Please make sure that the passwords are the same!";

}

if($messages){

doIndex();

exit;

}

$passcl=mysql_escape_string($passw);

$passen=md5($passcl);

if($changinglogin){

$wri1=excDB("UPDATE `users` SET `login`='$login', `password`='$passen', `passchange`='1', `loginchange`='1' WHERE `activeID`='$id2';");

if($wri1[0]){ $wri1=$wri1[1]; } else { die($wri1[2]); }

header("Location: login.php?created");

} else {

$wri1=excDB("UPDATE `users` SET `password`='$passen', `passchange`='1', `loginchange`='0' WHERE `activeID`='$id2';");

if($wri1[0]){ $wri1=$wri1[1]; } else { die($wri1[2]); }

header("Location: login.php?created2");

}

}
} else { 

doIndex();
}
function doIndex(){
?>
<!DOCTYPE html>
<head>
<title>Family Rental System! - Rent your DVDs here - Design by Alex, Coding by Gergy008</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<link type="text/css" href="css/main.css" rel="stylesheet">
<style type="text/css">
<!--
body {

background-color: #333333;
}
-->
</style></head>
<body style="text-align:center;">
<div class="first">
<div class="backgrounder1"></div>
<div class="headerbar1"></div>
<div class="headerbar2"></div>
</div>
<div align="center">
<table border="0" cellpadding="0" cellspacing="0" width="900">
  <tr>
   <td><img src="images/spacer.gif" width="52" height="1" border="0" alt="" /></td>
   <td><img src="images/spacer.gif" width="123" height="1" border="0" alt="" /></td>
   <td><img src="images/spacer.gif" width="352" height="1" border="0" alt="" /></td>
   <td><img src="images/spacer.gif" width="33" height="1" border="0" alt="" /></td>
   <td><img src="images/spacer.gif" width="55" height="1" border="0" alt="" /></td>
   <td><img src="images/spacer.gif" width="110" height="1" border="0" alt="" /></td>
   <td><img src="images/spacer.gif" width="110" height="1" border="0" alt="" /></td>
   <td><img src="images/spacer.gif" width="50" height="1" border="0" alt="" /></td>
   <td><img src="images/spacer.gif" width="15" height="1" border="0" alt="" /></td>
   <td><img src="images/spacer.gif" width="1" height="1" border="0" alt="" /></td>
  </tr>

  <tr>
   <td colspan="9" background="images/template.slice.1.png">&nbsp;</td>
   <td><img src="images/spacer.gif" width="1" height="20" border="0" alt="" /></td>
  </tr>
  <tr>
   <td colspan="5" background="images/template.slice.2.png">&nbsp;</td>
   <td colspan="2" rowspan="2" background="images/template.slice.3.png"><span class="login"><?php echo(loginHandler()); ?></span></td>
   <td colspan="2" rowspan="3" background="images/template.slice.4.png">&nbsp;</td>
   <td><img src="images/spacer.gif" width="1" height="30" border="0" alt="" /></td>
  </tr>
  <tr>
   <td rowspan="8" background="images/template.slice.5.png">&nbsp;</td>
   <td colspan="2" background="images/template.slice.6.png"><form>
     <div align="center">
       <input name="textfield" type="text" id="textfield" size="40" style="height:16px;">
       <input type="submit" name="button" id="button" value="Search" style="height:20px;">
     </div>
   </form></td>
   <td colspan="2" rowspan="2" background="images/template.slice.7.png">&nbsp;</td>
   <td><img src="images/spacer.gif" width="1" height="30" border="0" alt="" /></td>
  </tr>
  <tr>
   <td colspan="2" rowspan="3" background="images/template.slice.8.png"><p>&nbsp;</p>
    <p>&nbsp;</p></td>
   <td colspan="2" background="images/template.slice.9.png">&nbsp;</td>
   <td><img src="images/spacer.gif" width="1" height="70" border="0" alt="" /></td>
  </tr>
  <tr>
   <td rowspan="2" background="images/template.slice.10.png">&nbsp;</td>
   <td colspan="4" background="images/template.slice.11.png">&nbsp;</td>
   <td rowspan="6" background="images/template.slice.12.png">&nbsp;</td>
   <td><img src="images/spacer.gif" width="1" height="30" border="0" alt="" /></td>
  </tr>
  <tr>
   <td colspan="4" background="images/template.slice.13.png"></td>
   <td><img src="images/spacer.gif" width="1" height="8" border="0" alt="" /></td>
  </tr>
  <tr>
   <td rowspan="4" background="images/template.slice.14.png">&nbsp;</td>
   <td colspan="4" background="images/template.slice.15.png">&nbsp;</td>
   <td colspan="2" rowspan="4" background="images/template.slice.16.png">&nbsp;</td>
   <td><img src="images/spacer.gif" width="1" height="35" border="0" alt="" /></td>
  </tr>
  <tr>
   <td colspan="4" background="images/template.slice.17.png">&nbsp;</td>
   <td><img src="images/spacer.gif" width="1" height="37" border="0" alt="" /></td>
  </tr>
  <tr>
   <td colspan="4" align="center" valign="top" background="images/template.slice.18.png" style="vertical-align:top;"><p class="standard">&nbsp;</p>
     <table width="80%" border="0">
      <tr>
        <td colspan="2">
          <?php
          

if($messages){

//displayErrors($messages);

} else {

//echo("<p align=\"center\" class=\"standard\">Your account has been activated.</p><p align=\"center\" class=\"standard\">You now need to change your password. If you like you can also change your username, Remember that you only have 3 days to do so and this change will be permanent.</p>");

?></td>
        </tr>
      <form name="ChangeDetails" method="post" action="<?=$_SERVER['PHP_SELF']?>">
      <input type="hidden" name="activationid" value="<?php if($_GET['id']){ $id=$_GET['id']; echo($id); } elseif($_POST['activationid']){ $id=$_POST['activationid']; echo($id); } else { die("No ID") } ?>" />
      <tr>
        <td width="50%"><div align="right" class="standard">New Username: </div></td>
        <td width="50%"><input name="login" type="text" id="login" size="35" maxlength="30" /></td>
      </tr>
      <tr>
        <td><div align="right" class="standard">New Password:</div></td>
        <td><input name="password" type="password" id="password" size="35" maxlength="30" /></td>
      </tr>
      <tr>
        <td><div align="right" class="standard">Re-enter password:</div></td>
        <td><input name="passwordc" type="password" id="passwordc" size="35" maxlength="30" /></td>
      </tr>
      <tr>
        <td><div align="right" class="standard">Please enter the code: </div></td>
        <td>

<?php

require_once('recaptchalib.php');

$publickey = "6Le4fsESAAAAAKMOHb8aaiyDfGRJyr0y0EU7dXm-"; // you got this from the signup page

echo recaptcha_get_html($publickey);
            ?>
        </td>
      </tr>
      <tr>
        <td>&nbsp;</td>
        <td><input type="submit" name="submit" id="submit" value="Change your details" /></td>
      </tr>
      </form>
    </table>
     </td>
   <td><img src="images/spacer.gif" width="1" height="450" border="0" alt="" /></td>
  </tr>
  <tr>
   <td colspan="4" background="images/template.slice.19.png">&nbsp;</td>
   <td><img src="images/spacer.gif" width="1" height="50" border="0" alt="" /></td>
  </tr>
  <tr>
   <td colspan="9" background="images/template.slice.20.png">&nbsp;</td>
   <td><img src="images/spacer.gif" width="1" height="40" border="0" alt="" /></td>
  </tr>
</table>
</div>
</body>
</html>
<?php
} ?>


Thanks to all you kind people that take your time to read and help me with this problem. I'm sorry if it is a really simple problem I missed out that makes me look like a right idiot and wasted your time, but that's me I'm always missing stuff out like that, I do proof read though just sometimes not good enough.

Thanks in advance!