Redirecting to a User Profile Issue..

pmorales · August 4, 2013

Hey PHP coders,

Having trouble with a small application here. I copy/pasted 4 files below. My connect.php (Is the database connection with username, password, etc), index.html (file used to get user information for upload --- its a form that (redirects to create_user.php), create_user.php (my sql statements to upload the form into the database, show_user.php (redirected from create_user.php that should be populated with user information and should show up [however it does not].

WHAT AM I DOING WRONG HERE??????

PLEASE LET ME KNOW. THANKS IN ADVANCE.

I AM USING LOCALHOST..

__________________________________________________

CONNECT.PHP:

__________________________________________________________________

<?php

$database_host = "localhost";

$username = "php1";

$password = "jack";

$database_name = "user";

//require_once 'app_config.php';

mysql_connect($database_host, $username, $password)

or die ("<p>Error connecting to database: " .

mysql_error() . "</p>");

header("Location: show_user.php?user_id=" . mysql_insert_id());

// exit();

//echo "<p>Connected to MySql!!!!!</p>";

mysql_select_db($database_name)

or die("<p>Error selecting the database user: " .

mysql_error() . "</p>");

exit();

//echo "<p>Connected to Mysql, using database USER.</p>";

/*

$result = mysql_query("SHOW DATABASES;");

if (!$result) {

die("<p>Error in listing tables: ". mysql_error() . "</p>");

}

echo "<p>Table in database:</p>";

echo "<ul>";

while ($row = mysql_fetch_row($result)) {

echo "<li>Table: {$row[0]}<li>";

}

echo "</ul>"

*/

?>

____________________________________________________________________________

CREATE_USER.PHP

__________________________________________________________________________________________________

<?php

require_once 'connect.php';

$first_name = trim($_REQUEST['first_name']);

$last_name = trim($_REQUEST['last_name']);

$email = trim($_REQUEST['email']);

$facebook_handle = trim($_REQUEST['facebook_handle']);

$twitter_handle = trim($_REQUEST['twitter_handle']);

$bio= trim($_REQUEST['bio']);

$insert_sql = "INSERT INTO user (first_name, last_name, " .

"email, facebook_handle, twitter_handle, bio) " .

"VALUES ('{$first_name}', '{$last_name}', '{$email}', " .

"'{$facebook_handle}', '{$twitter_handle}', '{$bio}');";

mysql_query($insert_sql);

// $user_id = $_REQUEST['user_id'];

header('Location: show_user.php?user_id=' . mysql_insert_id());

// $user_id = $_REQUEST['user_id'];

// exit();

// or die(mysql_error());

?>

_______________________________________________

INDEX.HTML

_______________________________________________________________________

<!--

To change this template, choose Tools | Templates

and open the template in the editor.

-->

<!DOCTYPE html>

<html>

<head>

</head>

<body>

<div id="header"><h1>PHP & MYSQL: uuuuuuuuuuuu</h1> </div>

<form action="create_user.php" method="POST"

enctype="multipart/form-data">

<label for="first_name">First Name:</label>

<label for="email">Email Address:</label>

<label for="facebook_handle">Facebook Handle:</label>

<label for="twitter_handle">Twitter Handle:</label>

<label for="user_pic">Upload a Picture:</label>

</fieldset>

<br/>

</fieldset>

</form>

</div>

</body>

</html>

_____________________________________

SHOW_USER.PHP

_________________________________________________________________

//require_once 'create_user.php';

require_once 'connect.php';

$user_id = $_REQUEST['user_id'];

$select_query = "SELECT * FROM user WHERE user_id = " . $user_id;

$result = mysql_query($select_query);

if ($result) {

//get the query result rows using $ result

$row = mysql_fetch_array($result);

$first_name = $row['first_name'];

$last_name = $row['last_name'];

$bio = $row['bio'];

// $email = $row['email'];

// $facebook_handle = $row['facebook_handle'];

// $twitter_handle = $row['twitter_handle'];

} else {

die ("Error locating user with ID {$user_id}");

}

?>

<html

<head>

// user end up here by using the create_user.html and create_user.php.

//also my loggin in and clicking "my profile".

//selecting a particular user from a list.

</head>

<body>

<div id="header"><h1>The first creatative site phil morales</h1></div>

<div id="example">User Profile</div>

<p><img src="<?php echo $user_image; ?>" class="user_pic" />

<?php echo $bio; ?></p>

<p class ="contact_info">Get in touch with $first_name:</p>

</div>

</body>

</html>

adoado · August 5, 2013

A bit more information would help.. have you got errors on, or a tail log open?

pmorales · August 5, 2013

http://localhost/PhpP/show_user.php?user_id=0

I GET THIS ERROR ABOVE... IT NEVER INCREMENTS OR GETS THE "USER_ID" FROM DATABASE NOR DOES IT POPULATE THAT SHOW_USER.PHP ON SCREEN

chriscloyd · August 5, 2013

You are setting the id's but if a page is reloaded and the user does not have a cookie or a session it will not remember which user is logged in

pmorales · August 6, 2013

Thanks chrisloyd,

I got to start inputting the session. I will give a shot see what happens.

Sign In

Redirecting to a User Profile Issue..

Recommended Posts

pmorales

Link to comment

Share on other sites

adoado

Link to comment

Share on other sites

pmorales

Link to comment

Share on other sites

chriscloyd

Link to comment

Share on other sites

pmorales

Link to comment

Share on other sites

Join the conversation

Browse

Activity

Important Information