jasont8
-
Posts
6 -
Joined
-
Last visited
Posts posted by jasont8
-
-
thank you, I been wondering what was the error for the longest time.
-
so i look at the myphpadmin to check that I have the stored procedures from the book and apparently I do. I'm still getting this error and I don't know why.
An error occurred in script '/var/www/html/ex2/html/wishlist.php' on line 81: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given Array ( [0] => Array ( [function] => my_error_handler [args] => Array ( [0] => 2 [1] => mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given [2] => /var/www/html/ex2/html/wishlist.php [3] => 81 [4] => Array ( [_GET] => Array ( ) [_POST] => Array ( ) [_COOKIE] => Array ( [SESSION] => a902b14df889f3355f141a5e1355ef2b ) [_FILES] => Array ( ) [uid] => a902b14df889f3355f141a5e1355ef2b [page_title] => Coffee - Your Wish List [r] => [dbc] => mysqli Object ( [affected_rows] => -1 [client_info] => mysqlnd 5.0.12-dev - 20150407 - $Id: 241ae00989d1995ffcbbf63d579943635faf9972 $ [client_version] => 50012 [connect_errno] => 0 [connect_error] => [errno] => 1146 [error] => Table 'ecommerceshop.wish_lists' doesn't exist [error_list] => Array ( [0] => Array ( [errno] => 1146 [sqlstate] => 42S02 [error] => Table 'ecommerceshop.wish_lists' doesn't exist ) ) [field_count] => 0 [host_info] => Localhost via UNIX socket [info] => [insert_id] => 0 [server_info] => 5.7.16-0ubuntu0.16.04.1 [server_version] => 50716 [stat] => Uptime: 44779 Threads: 2 Questions: 401 Slow queries: 0 Opens: 224 Flush tables: 1 Open tables: 135 Queries per second avg: 0.008 [sqlstate] => 00000 [protocol_version] => 10 [thread_id] => 41 [warning_count] => 0 ) ) ) ) [1] => Array ( [file] => /var/www/html/ex2/html/wishlist.php [line] => 81 [function] => mysqli_num_rows [args] => Array ( [0] => ) )
)
-
looking though phpmyadmin, I don't have the tables for the wishlist like get_wish_list_contents, what are the tables required for the wishlist and how do I make them?
-
I'm currently using phpmyadmin if that counts but I'm not sure how to go about fixing this problem and I been stuck for a while. I just began using mysql. do you need to see the code?
-
so when starting up the wishlist.php using the book scripts of the second site, I'm getting an error that
An error occurred in script '/var/www/html/ex2/html/wishlist.php' on line 81:
mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given
Array.what does this error and mean. How do I go about fix it? Is it a problem with the data in the database?
How Does Dynamic Routing Work In Php?
in Effortless E-Commerce with PHP and MySQL (2nd Edition)
Posted
There is something about php that I have trouble understand coming from using javascript like angular. How does routing in php work exactly? Like how does a php site know about going to a link
(/browse/coffee/Dark+Roast/2) or a shop/product link. How does the htacess file works with the site. Currently, when going to a link the /shop/coffee, it responds by not found. I tried to look it up but I don't understand it per say as it different from the way I normally do it in javascript.