Ch0cu3r

Use var_dump to analyse the values correctly var_dump($_SERVER['PHP_AUTH_PW']); echo '<br />'; var_dump($row["Password"]); Whats the output now for the password values?

You are getting that error because your query is failing, due to an error, to see what the error is you can use erroInfo. change line 65 to 78 to be $result = $db->query($sql); // check query did not fail (returns false on error) if($result) { while ($row = $result->fetch()) { if(!empty($row["Username"]) AND !empty($row["Password"])) { $_SESSION['user'] = $row["user"]; echo "Login Succefull!"; } else { echo "You entered wrong username and/or password. Please refresh this page to retry. It may be possible that your account doesn't exist. In this case, cancel the login box and sign up."; } } } // query failed else { $error = $db->erroInfo(); trigger_error('Unable to process login query. DB Error: ' . $error[2]); }

No. return will terminate the function and return the data at that point. The second return statement will never be reached. See the documentation on return here http://php.net/return Any, way you do not need the second query. You could pass the result of calling your function to count to get the total results, this is because $stmt->fetchAll() returns a multidimensional array of all the rows returned by your query. Example function yourFunction() { ... omitted code ... return $stmt->fetchAll(PDO::FETCH_ASSOC); } // when calling your function $results = yourFunction(); // pass the result of your function to count, get the number of results returned from your function $numResults = count($results); // loop though results foreach($results as $row) { // generate xml } The alternative is instead of using return $stmt->fetchAll(PDO::FETCH_ASSOC); to have it return the PDO Statement object return $stmt; then when calling your function the code will be // when calling your function $stmt = yourFunction(); // call the PDO Statement rowCount() method to get the number of results $numRows = $stmt->rowCount(); // call the PDO Statement fetchAll method to loop through the results foreach($stmt->fetchAll(PDO::FETCH_ASSOC) as $row) { // generate xml }

If you are using simple html dom, then there is no need for the use of xpath. You use one or the other. Both return the same result, just uses different syntax for the grabbing the data you require. This xpath //div[@class=highslide-gallery] is the equivalent in simplehtmldom as div.highslide-gallery (it uses css selectors as the dom path) The reason the script maybe crashing is because it is running out of memory? You should check your servers error logs or enable errors either in the php.ini or adding the following two lines of code at the top of your script ini_set('display_errors', 1); error_reporting(E_ALL);

Your can wrap your content in a container. See example https://jsfiddle.net/arswgywm/

dirname(__FILE__) will be returning the directory of the current script, for example it will return this file path C:\xampp\htdocs\food\admin\crud\customers You will have to use dirname(dirname(dirname(__FILE__))) to get back to the food directory. The better solution would be to add your admin directory to a constant, then prefix your filepaths using the ADMIN constant, example define('ADMIN', 'C:/xampp/htdocs/food/admin'); // or as // define('ADMIN', dirname(dirname(dirname(__FILE__))) // prefix filepaths with ADMIN constant include ADMIN . '/includes/admin-header.php'; include ADMIN . '/includes/admin-navbar.php'; include ADMIN . '/admin-functions.php'; include ADMIN . '/db/dbconnect.php';

The best place would be php.net/mysqli. That is the documentation for mysqli. Each function has an explanation of what arguments it requires, what it does, what it returns and a code example for how it is used. From there you should be able to convert your the mysql_* functions to the mysqli_* equivalent functions. Alternatively you may find http://codular.com/php-mysqli helpful.