Jump to content
Larry Ullman's Book Forums
Sign in to follow this  
Alex1

PHP for the Web chapter 13 error help (long)

Recommended Posts

I have been getting some errors in my chapter 13 site and I am not sure how I can fix them. I am able to login with the login.php page.

When I do I get this error.

?php // Script 13.4 - footer.html // Display general admin links... // - if the user is an administrator and it's not the logout.php page // - or if the $loggedin variable is true (i.e., the user just logged in) if ( (is_administrator() && (basename($_SERVER['PHP_SELF']) != 'logout.php')) OR (isset($loggedin) && $loggedin) ) { // Create the links: print '

 

When I go to the add_quotes.php page I get this error.
 

Quote

 

Warning: include(../mysqli_connect.php): failed to open stream: No such file or directory in C:\xampp\htdocs\PHP\Chapter 13\view_quotes.php on line 18

Warning: include(): Failed opening '../mysqli_connect.php' for inclusion (include_path='C:\xampp\php\PEAR') in C:\xampp\htdocs\PHP\Chapter 13\view_quotes.php on line 18
Notice: Undefined variable: dbc in C:\xampp\htdocs\PHP\Chapter 13\view_quotes.php on line 24


Warning: mysqli_query() expects parameter 1 to be mysqli, null given in C:\xampp\htdocs\PHP\Chapter 13\view_quotes.php on line 24


Notice: Undefined variable: dbc in C:\xampp\htdocs\PHP\Chapter 13\view_quotes.php on line 44


Warning: mysqli_error() expects parameter 1 to be mysqli, null given in C:\xampp\htdocs\PHP\Chapter 13\view_quotes.php on line 44

Could not retrieve the data because:

The query being run was: SELECT id, quote, source, favorite FROM quotes ORDER BY date_entered DESC
Notice: Undefined variable: dbc in C:\xampp\htdocs\PHP\Chapter 13\view_quotes.php on line 47
Warning: mysqli_close() expects parameter 1 to be mysqli, null given in C:\xampp\htdocs\PHP\Chapter 13\view_quotes.php on line 47
?php // Script 13.4 - footer.html // Display general admin links... // - if the user is an administrator and it's not the logout.php page // - or if the $loggedin variable is true (i.e., the user just logged in) if ( (is_administrator() && (basename($_SERVER['PHP_SELF']) != 'logout.php')) OR (isset($loggedin) && $loggedin) ) { // Create the links: print '

 

 

When I try and add a quote I get this list of errors.

 

Quote

 

Warning: include(C:/xampp/htdocs/PHP/Chapter13/mysqli_connect.php): failed to open stream: No such file or directory in C:\xampp\htdocs\PHP\Chapter 13\add_quote.php on line 23

Warning: include(): Failed opening 'C:/xampp/htdocs/PHP/Chapter13/mysqli_connect.php' for inclusion (include_path='C:\xampp\php\PEAR') in C:\xampp\htdocs\PHP\Chapter 13\add_quote.php on line 23

Notice: Undefined variable: dbc in C:\xampp\htdocs\PHP\Chapter 13\add_quote.php on line 26

Warning: mysqli_real_escape_string() expects parameter 1 to be mysqli, null given in C:\xampp\htdocs\PHP\Chapter 13\add_quote.php on line 26

Notice: Undefined variable: dbc in C:\xampp\htdocs\PHP\Chapter 13\add_quote.php on line 27

Warning: mysqli_real_escape_string() expects parameter 1 to be mysqli, null given in C:\xampp\htdocs\PHP\Chapter 13\add_quote.php on line 27

Notice: Undefined variable: dbc in C:\xampp\htdocs\PHP\Chapter 13\add_quote.php on line 37

Warning: mysqli_query() expects parameter 1 to be mysqli, null given in C:\xampp\htdocs\PHP\Chapter 13\add_quote.php on line 37

Notice: Undefined variable: dbc in C:\xampp\htdocs\PHP\Chapter 13\add_quote.php on line 39

Warning: mysqli_affected_rows() expects parameter 1 to be mysqli, null given in C:\xampp\htdocs\PHP\Chapter 13\add_quote.php on line 39

Notice: Undefined variable: dbc in C:\xampp\htdocs\PHP\Chapter 13\add_quote.php on line 43

Warning: mysqli_error() expects parameter 1 to be mysqli, null given in C:\xampp\htdocs\PHP\Chapter 13\add_quote.php on line 43

Could not store the quote because:
.

The query being run was: INSERT INTO quotes (quote, source, favorite) VALUES ('', '', 1)


Notice: Undefined variable: dbc in C:\xampp\htdocs\PHP\Chapter 13\add_quote.php on line 47

Warning: mysqli_close() expects parameter 1 to be mysqli, null given in C:\xampp\htdocs\PHP\Chapter 13\add_quote.php on line 47

 

 

 

Here is my add_quotes.php code

I am getting a red underline error on the  ! is administrator line

I added LINE is # where each line error is for my error list above

<?php // Script 13.7 - add_quote.php
/* This script adds a quote. */

// Define a page title and include the header:
define('TITLE', 'Add a Quote');
include('templates/header.html');

print '<h2>Add a Quotation</h2>';

// Restrict access to administrators only:
if (!is_administrator()) { (THIS LINE IS GIVING ME AN ERROR)
	print '<h2>Access Denied!</h2><p class="error">You do not have permission to access this page.</p>';
	include('templates/footer.html');
	exit();
}

// Check for a form submission:
if ($_SERVER['REQUEST_METHOD'] == 'POST') { // Handle the form.

	if ( !empty($_POST['quote']) && !empty($_POST['source']) ) {

		// Need the database connection:
	LINE 23	include('C:/xampp/htdocs/PHP/Chapter13/mysqli_connect.php');

		// Prepare the values for storing:
	LINE 26	$quote = mysqli_real_escape_string($dbc, trim(strip_tags($_POST['quote'])));
	LINE 27	$source = mysqli_real_escape_string($dbc, trim(strip_tags($_POST['source'])));

		// Create the "favorite" value:
		if (isset($_POST['favorite'])) {
			$favorite = 1;
		} else {
			$favorite = 0;
		}

		$query = "INSERT INTO quotes (quote, source, favorite) VALUES ('$quote', '$source', $favorite)";
		LINE 37 mysqli_query($dbc, $query);

		LINE 39 if (mysqli_affected_rows($dbc) == 1){
			// Print a message:
			print '<p>Your quotation has been stored.</p>';
		} else {
			print '<p class="error">Could not store the quote because:<br>' . mysqli_error($dbc) . '.</p><p>The query being run was: ' . $query . '</p>';
		}

		// Close the connection:
		LINE 47 mysqli_close($dbc);

	} else { // Failed to enter a quotation.
	LINE 43	print '<p class="error">Please enter a quotation and a source!</p>';
	}

} // End of submitted IF.

// Leave PHP and display the form:
?>

<form action="add_quote.php" method="post">
	<p><label>Quote <textarea name="quote" rows="5" cols="30"></textarea></label></p>
	<p><label>Source <input type="text" name="source"></label></p>
	<p><label>Is this a favorite? <input type="checkbox" name="favorite" value="yes"></label></p>
	<p><input type="submit" name="submit" value="Add This Quote!"></p>
</form>

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

 

 

 

 

Share this post


Link to post
Share on other sites

This error is the cause of all, or most, of your problems:

Warning: include(C:/xampp/htdocs/PHP/Chapter13/mysqli_connect.php): failed to open stream: No such file or directory in C:\xampp\htdocs\PHP\Chapter 13\add_quote.php on line 23
 

Your reference to include mysqli_connect.php from add_quote.php is incorrect based upon how the two files are found on the server. 

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
Sign in to follow this  

×
×
  • Create New...