PHP - Page Doesn't Show Any Html After A Php Script.

I'm trying to expand my knowledge on some more str type functions, and I've always wanted to learn implode and explode, but I was just too lazy.

Anyways, for some reason, if I type in: salad,pizza,apples - the first value in the array, salad, doesn't show up. o.O


<?php

$favorite_food = $_POST['favorite_food'];

if(!$favorite_food)

{

?>

<form action="words.php" method="POST">

<input type="text" name="favorite_food">

<input type="submit">

</form>

<?php

}

else

{

$ex = explode(",", $favorite_food);

$amount = count($ex) + 1;

while($i < $amount)

{

echo $ex[$i]."<br/>";

++$i;

}

}

?>

I know arrays start at 0, so thats why I added 1 to the count.

I need to copy a table from one code to another. But I couldn't figure out how to do it properly. Just tried to copy code from one file to another but it doesn't work the same. I need to find where to change the code to show right columns.

https://easyupload.io/maoa9h - zipped cart.php (original code with right table) and review.php (the one that doesn't show right table)
 

We need to copy the table from cart.php:
https://ibb.co/MZ7K7S5 - table look

But it doesn't work. The quantity column doesn't show in review.php - as you can see here https://ibb.co/brP0yy1

Quesion: Show each movie in the database on its own page, and give the user links in a "page 1, Page 2, Page 3" - type navigation system. Hint: Use LIMIT to control which movie is on which page. I have provided 3 files: 1st: configure DB, 2nd: insert data, 3rd: my code for the question. I would appreciate the help. I am a noob by the way.

First set up everything for DB:

<?php
//connect to MySQL
$db = mysql_connect('localhost', 'root', '000') or
    die ('Unable to connect. Check your connection parameters.');

//create the main database if it doesn't already exist
$query = 'CREATE DATABASE IF NOT EXISTS moviesite';
mysql_query($query, $db) or die(mysql_error($db));

//make sure our recently created database is the active one
mysql_select_db('moviesite', $db) or die(mysql_error($db));

//create the movie table
$query = 'CREATE TABLE movie (
        movie_id        INTEGER UNSIGNED  NOT NULL AUTO_INCREMENT,
        movie_name      VARCHAR(255)      NOT NULL,
        movie_type      TINYINT           NOT NULL DEFAULT 0,
        movie_year      SMALLINT UNSIGNED NOT NULL DEFAULT 0,
        movie_leadactor INTEGER UNSIGNED  NOT NULL DEFAULT 0,
        movie_director  INTEGER UNSIGNED  NOT NULL DEFAULT 0,

        PRIMARY KEY (movie_id),
        KEY movie_type (movie_type, movie_year)
    )
    ENGINE=MyISAM';
mysql_query($query, $db) or die (mysql_error($db));

//create the movietype table
$query = 'CREATE TABLE movietype (
        movietype_id    TINYINT UNSIGNED NOT NULL AUTO_INCREMENT,
        movietype_label VARCHAR(100)     NOT NULL,
        PRIMARY KEY (movietype_id)
    )
    ENGINE=MyISAM';
mysql_query($query, $db) or die(mysql_error($db));

//create the people table
$query = 'CREATE TABLE people (
        people_id         INTEGER UNSIGNED    NOT NULL AUTO_INCREMENT,
        people_fullname   VARCHAR(255)        NOT NULL,
        people_isactor    TINYINT(1) UNSIGNED NOT NULL DEFAULT 0,
        people_isdirector TINYINT(1) UNSIGNED NOT NULL DEFAULT 0,

        PRIMARY KEY (people_id)
    )
    ENGINE=MyISAM';
mysql_query($query, $db) or die(mysql_error($db));

echo 'Movie database successfully created!';
?>



********************************************************************
***********************************************************************

second file to load info into DB:



<?php
// connect to MySQL
$db = mysql_connect('localhost', 'root', '000') or
    die ('Unable to connect. Check your connection parameters.');

//make sure you're using the correct database
mysql_select_db('moviesite', $db) or die(mysql_error($db));

// insert data into the movie table
$query = 'INSERT INTO movie
        (movie_id, movie_name, movie_type, movie_year, movie_leadactor,
        movie_director)
    VALUES
        (1, "Bruce Almighty", 5, 2003, 1, 2),
        (2, "Office Space", 5, 1999, 5, 6),
        (3, "Grand Canyon", 2, 1991, 4, 3)';
mysql_query($query, $db) or die(mysql_error($db));

// insert data into the movietype table
$query = 'INSERT INTO movietype
        (movietype_id, movietype_label)
    VALUES
        (1,"Sci Fi"),
        (2, "Drama"),
        (3, "Adventure"),
        (4, "War"),
        (5, "Comedy"),
        (6, "Horror"),
        (7, "Action"),
        (8, "Kids")';
mysql_query($query, $db) or die(mysql_error($db));

// insert data into the people table
$query  = 'INSERT INTO people
        (people_id, people_fullname, people_isactor, people_isdirector)
    VALUES
        (1, "Jim Carrey", 1, 0),
        (2, "Tom Shadyac", 0, 1),
        (3, "Lawrence Kasdan", 0, 1),
        (4, "Kevin Kline", 1, 0),
        (5, "Ron Livingston", 1, 0),
        (6, "Mike Judge", 0, 1)';
mysql_query($query, $db) or die(mysql_error($db));

echo 'Data inserted successfully!';
?>



**************************************************************
****************************************************************

MY CODE FOR THE QUESTION:


<?php
$db = mysql_connect('localhost', 'root', '000') or
die ('Unable to connect. Check your connection parameters.');

mysql_select_db('moviesite', $db) or die(mysql_error($db));

//get our starting point for the query from the URL
if (isset($_GET['offset'])) {
   $offset = $_GET['offset'];
} else {
   $offset = 0;
}

//get the movie
$query  = 'SELECT
   movie_name, movie_year
FROM
   movie
ORDER BY
   movie_name
LIMIT ' . $offset . ' , 1';
$result = mysql_query($query, $db) or die(mysql_error($db));
$row = mysql_fetch_assoc($result);
?>
<html>
<head>
<title><?php echo $row['movie_name']; ?></title>
</head>
<body>
<table border = "1">
<tr>
<th>Movie Name</th>
<th>Year</th>
</tr><tr>
<td><?php echo $row['movie_name']; ?></td>
<td><?php echo $row['movie_year']; ?></td>
</tr>
</table>
<p>
<a href="page.php?offset=0">Page 1</a>,
<a href="page.php?offset=1">Page 2</a>,
<a href="page.php?offset=2">Page 3</a>
</p>
</body>
</html>

I want to show a cookie of a referral's username on a sign up page. The link is like this, www.mysite.com/signup?ref=johnsmith.

The cookie doesn't show if I go to that url page. But it does show up once I reload the page.  So I'm wondering if it's possible to show the cookie the first time around, instead of reloading the page?

Here is my code.

// This is in the header
$url_ref_name = (!empty($_GET['ref']) ? $_GET['ref'] : null);

if(!empty($url_ref_name)) {

  $number_of_days = 365;
  $date_of_expiry = time() + 60 * 60 * 24 * $number_of_days;
  setcookie( "ref", $url_ref_name, $date_of_expiry,"/");

} else if(empty($url_ref_name)) {
  if(isset($_COOKIE['ref'])) {
    $user_cookie = $_COOKIE['ref'];
  }
} else {}

// This is for the sign up form
if(isset($_COOKIE['ref'])) {
  $user_cookie = $_COOKIE['ref'];
  ?>
  <fieldset>
    <label>Referred By</label>
    <div id="ref-one"><span><?php if(!empty($user_cookie)){echo $user_cookie;} ?></span></div>
    <input type="hidden" name="ref" value="<?php if(!empty($user_cookie)){echo $user_cookie;} ?>" maxlength="20" placeholder="Referrer's username" readonly onfocus="this.removeAttribute('readonly');" />
  </fieldset>
  <?php
}

 

Hi,

I would like to do the following but not sure how.

If the you/user is on index.php of http://www.domain.com/ show one page
If not show another

How would I do this?

Thanks

ONE of my SESSION values isn't remaining after login while others do.

This works fine on my localhost, it's on the live site that there is a problem and it just started yesterday. Before that it worked great.

Out of the four SESSIONs made I can only echo three values on other pages, member id the most important doesn't transfered to other pages

Notes: all these files are in the same folder, there is a SESSION started for the member id on the login page, you can see that it is used in the redirect below and the redirect works fine with the redirect going to the correct page " $home/member/index.php?user=$id_mem "

Here is the login page
// Here's the basic login page info
<?php # login.php
session_start();
ob_start() 
...connect to db & header called...
...Form validation.....

if ($e && $p) { // If everything's OK.
// Query the database:
$q = "SELECT id_mem, display_name, mem_group FROM sn_members WHERE (email='$e' AND password=SHA1('$p')) AND active IS NULL";
$r = mysqli_query ($dbc, $q) or trigger_error("Query: $q\n<br />MySQL Error: " . mysqli_error($dbc));
//  or die("Error: ".mysqli_error($dbc));

if (@mysqli_num_rows($r) == 1) { // If a match was made.

// Register the values & redirect:
// Give SELECTED elements a session
$_SESSION = mysqli_fetch_array ($r, MYSQLI_ASSOC);
$_SESSION['agent'] = md5($_SERVER['HTTP_USER_AGENT']);
mysqli_free_result($r);

// Update db for last login
$id_mem = $_SESSION['id_mem']; // <<< SESSION member id has a value here because it's used in the redirect below
$ip = $_SERVER['REMOTE_ADDR']; // Get ip address of person logging in
$q = "UPDATE sn_members SET last_login = Now(), ip = '$ip' WHERE id_mem = '$id_mem' LIMIT 1";
$r = mysqli_query ($dbc, $q) or trigger_error("Query: $q\n<br />MySQL Error: " . mysqli_error($dbc));

header("Location: $home/member/index.php?user=$id_mem");
exit(); // Quit the script.

}
?>


Here is the main page that a user would be redirect to above
<?php // /member/ all member info is through this folder
session_start();
ob_start();

if (isset($_GET['user']) && is_numeric($_GET['user'])) {
$user = $_GET['user'];
$user = $user;
if ($user < 0) {
header("Location: $home/index.php");
exit();
}
}

if ((!isset($_SESSION['id_mem']))  && (!isset($_SESSION['agent']) OR ($_SESSION['agent'] != md5($_SERVER['HTTP_USER_AGENT'])))){
// If not a logged in member redirect
header("Location: $home/index.php");
exit(); // Quit the script.
}
?>

Thanks in advance for the help
SJ

I'm a complete newb at programming so please bear with me
i'm trying to check to make sure my sql query

          $result=mysql_query("SELECT screenname FROM users WHERE privacy='0'");

shows the correct results so i did a print_r($result); die();

but when i reload the page, it shows a syntax error after the die();

isn't the script suppose to completely stop so syntax errors after die() shouldn't matter?

also i'm expecting the $result to be an array of names and i wanted to do a query to another table to grab comments from each of those screennames, is the only way to do a for loop of mysql queries?

Thanks

  Why doesn't this code update two mysql databases (on two servers)? What am I doing wrong?

//SERVER 1 
$link = mysql_connect("localhost","usern1","pw1"); 
mysql_select_db("db_one1"); 

//SERVER 2 
$link = mysql_connect("xxx.xxx.xx.xxx","usern2","pw2"); 
mysql_select_db("db_one2"); 

$query = "INSERT INTO db1(subject, search, News, img) VALUES('$hsubject','$key','$news','$img')"; 
$result = mysql_query($query); 

$query = "INSERT INTO db2(subject, search, News, img) VALUES('$hsubject','$key','$news','$img')"; 
$result = mysql_query($query); 

$sentOk = "The data has been added to the database."; 
echo "sentOk=" . $sentOk; 

Hi all,
I have two issue with script.
1. It works in PhpEd and with apache but doesn't work at remote server with apache.
    Error is well known -  "Warning: Cannot modify header information - headers already sent "

2. when I added more than 20 records like $var = $_POST['var']; it stops work local. Error is same.


adminka_wrapp.php
Code: [Select]
<?php
$addFormatName = $_POST['addFormatName'];
$addFormatDes  = $_POST['addFormatDes'];
$page               = $_GET['page'];


if (isset($addFormatName) && isset($addFormatDes))
  {
      $page = 'add_formats';
  } else if ($page == NULL)
    {
        $page =  "user_access_log";
    }
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
    <head>
        <link rel="stylesheet" type="text/css" href="../style/adminkaview.css">       
    </head>
    <body>
        <div class="col-wrap1">
            <div class="col-wrap2">
                <div class="col1">
                    <div class="content" id="c1">
                        <p><a href="?page=view_add_format">Format and extensions</a></p>
                    </div>
                </div>
                <div class="col2">
                    <div class="content" id="c2">
<?php require("$page.php");?>
                    </div>
                </div>
                <div class="clear"></div>
            </div>
        </div>
    </body>
</html>

view_add_format.php
Code: [Select]
<?php
require_once "../function.php"; 

$q = connect("SELECT
                      `formats`.*
              FROM
                       `xxx`.`formats` 
            ");
echo "<form method='post' action='adminka_wrapp.php'>
     <table>
            <tr>
                <td>id</td>
                <td>Formats Name</td>
                <td>Description</td>
            </tr>";             
  while($rowResult = $q->fetch_assoc())
  {
    echo "<tr>";  
    $id            = $rowResult["id"];  
    $formatName    = $rowResult["f_name"];  
    $description   = $rowResult["description"];
    echo    "<td>".$id."</td>"
           ."<td>".$formatName."</td>"
           ."<td>".$description."</td>";
    echo "</tr>";
  }
  
echo " <tr>
           <td>
               <input type='submit' value='AddFormat' name='submitAddFormat'>
           </td>
           <td>
                <input type='text' name='addFormatName' maxlength='20' size='5'>
            </td>
            <td>
                <input type='text' name='addFormatDes' maxlength='20' size='5'>
            </td>    
                ";                
echo "</table>
      </form>";          
?>

add_formats.php
Code: [Select]
<?php
require "../function.php"; 
 
  if (isset($addFormatName) && isset($addFormatDes) )
 {
   
        $q  = connect("INSERT INTO  
                                   `xxx`.`formats`     
                                   (`id`
                                   ,`f_name`
                                   ,`description`
                                   )
                       VALUE
                                   (NULL
                                   ,'$addFormatName'
                                   ,'$addFormatDes'
                                   )               
                   ");   
        header("Location: adminka_wrapp.php?page=view_add_format");
        exit();     
 }
?>

function.php
Code: [Select]
<?php
function connect($query)
{
  $db = new mysqli('127.0.0.1', 'xxx', 'xxx', 'xxx');
  if (mysqli_connect_errno()) 
     {
         printf("Connect failed: %s\n", mysqli_connect_error());
         exit();
     }
$result = $db->query($query);
$db->close();
return $result;   
}
?>

This topic has been moved to Other Web Server Software.

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

Hello, I am trying to pick up php again and just exercising my skills. So I have it so that it fills my form with the values of what I want to edit, and when I click the edit button, it doesn't edit any of the information. When I echo out $result, I get a MYSQL query string that has the same values as the table, so its not getting the new values that are edited.


<?php

@mysql_connect('localhost', 'root', '') or die("Could not connect to Mysql Server. " . mysql_error());

@mysql_select_db('tutorials') or die("Could not connect to Database. " . mysql_error());

if(isset($_GET['edit']))

{

$id = $_GET['edit'];

$query = "SELECT `username`, `password` FROM `users` WHERE `id` = '$id'";

$result = mysql_query($query);

$row = mysql_fetch_array($result);

$name = $row['username'];

$password = $row['password'];

}

if(isset($_POST['edit']))

{

$id = $_GET['edit'];

$query = "UPDATE `users` SET `username` = '$name', `password` = '$password' WHERE `id` = '$id'";

$result = mysql_query($query);

echo $query;

if(!$result)

{

echo mysql_error();

}else{

echo 'updated post';

}

}
?>
<form method="POST" action="" >

<input type="text" name="name" value="<?php echo $name; ?>" /> First name <br />

<input type="text" name="password" value="<?php echo $password; ?>" /> Last name <br />

<input type="submit" name="edit" value="edit" />
</form>


I believe it has something to do with the values of $name and $password in the form conflicting with the first if isset and the second if isset.

Thanks for any help possible   

Hello,
The following is my situation where I seem to get a 500 error code from the linux server:

i have an 'index' file like this:
Code: [Select]
<?php
require("includes/config.php");

$a = $_REQUEST['a'];

switch ($a)
{
   case "home":
      include("frontpage/main.php");
   case "user-process":
      include("user-process.php");
}
?>
config.php is something like this:
Code: [Select]
<?php

require(includes/classes/session.class.php);
require(includes/classes/user.class.php);
require(includes/classes/db.class.php);
...
?>
Now if we fall into the case "home" it works fine. Instead, if we fall into user-process it writes to the logs file Fatal Error: Class User does not exist bla bla bla. Why doesn't it exist ? every class is included in the config.php file then index.php includes first config.php ( which has all the classes) and then includes the requested page.

I also have a .htaccess file which is as follows:
Code: [Select]
RewriteEngine On
RewriteRule ^([^/\.]+)?/?([^/\.]+)?/?([^/\.]+)?/?([^/\.]+)?/?([^/\.]+)?/?([^/\.]+)?/?([^/\.]+)?$ index.php?a=$1&b=$2&c=$3&d=$4&e=$5&f=$6&g=$7 [NC,L]
which is used to access in a SEO friendly way the pages that users request.

Please delete.

This topic has been moved to Other Programming Languages.

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

Goal: To have a gallery that downloads images from the folder I previously uploaded to in a previous script.

Bug: When I load the page the thumbnail comes up as broken and when I click on the thumbnail to get the bigger picture it comes up with the following error message:

"Firefox doesn't know how to open this address, because the protocol (c) isn't associated with any program."


<?php
include 'db.inc.php';
//connect to MySQL
$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));

//change this path to match your images directory
$dir ='C:/x/xampp/htdocs/images';

//change this path to match your thumbnail directory
$thumbdir = $dir . '/thumbs';
?>
<html>
 <head>
  <title>Welcome to our Photo Gallery</title>
  <style type="text/css">
   th { background-color: #999;}
   .odd_row { background-color: #EEE; }
   .even_row { background-color: #FFF; }
  </style>
 </head>
 <body>
  <p>Click on any image to see it full sized.</p>
  <table style="width:100%;">
   <tr>
    <th>Image</th>
    <th>Caption</th>
    <th>Uploaded By</th>
    <th>Date Uploaded</th>
   </tr>
<?php
//get the thumbs
$result = mysql_query('SELECT * FROM images') or die(mysql_error());

$odd = true;
while ($rows = mysql_fetch_array($result)) {
    echo ($odd == true) ? '<tr class="odd_row">' : '<tr class="even_row">';
    $odd = !$odd; 
    extract($rows);
    echo '<td><a href="' . $dir . '/' . $image_id . '.jpg">';
    echo '<img src="' . $thumbdir . '/' . $image_id . '.jpg">';
    echo '</a></td>';
    echo '<td>' . $image_caption . '</td>';
    echo '<td>' . $image_username . '</td>';
    echo '<td>' . $image_date . '</td>';
    echo '</tr>';
}
?>
  </table>
 </body>
</html>


Any help appreciated.