Jump to content
Larry Ullman's Book Forums


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About olaoyesunday

  • Rank
  1. Thanks Necuima, but I can't find Jai's post I searched all through the six pages of this forum.
  2. Please, how can we add image file or attachment to the mail function. I checked your php advance OOP 2012, I couldn't find it,
  3. Dear Larry, thanks for the answers but can you just give me a sample code snippets for that number 1 above where you said " " I love your way of writing codes than using frameworks
  4. 1) Our header file is in the includes file. if a client want to enter keywords to each products created in goodies categories for example, Please, how can he includes the keywords for Google to rank his site high? or how can we make our product entry in admin panel to handle it similar to the screenshot I attached with this messages, it was done using Laravel. 2) how can we also add recently viewed items say 5 to our site too?
  5. Upon re-written of the SQL below I got this error: #1067 - Invalid default value for 'date_modified' but When I removed "DEFAULT '0000-00-00 00:00:00' " the SQL ran successfully. I want to know if I am correct or not but Based on the link you sent I think I am on the way " For the first column that uses the TIMESTAMP data type in a specific table, MariaDB automatically assigns the following properties to the column: • DEFAULT CURRENT_TIMESTAMP • ON UPDATE CURRENT_TIMESTAMP. CREATE TABLE `carts` ( `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, `user_session_id` CHAR(32) NOT NULL, `product_type` enum('coffee','goodies') NOT NULL, `product_id` MEDIUMINT(8) UNSIGNED NOT NULL, `quantity` TINYINT(3) UNSIGNED NOT NULL, `date_modified` TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00', ` date_created` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`), KEY `product_type` (`product_type`,`product_id`), KEY `user_session_id` (`user_session_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  6. Dear all. I am having SQL issues with Table Carts and Wish_lists table on page 189, 192. the date_modified column was given error it was saying MySQL said: #1067 - Invalid default value for 'date_modified' should I just remove TIMESTAMP Data type from date_modified column and change it to DATETIME?. I am using Maria DB 10.3.15 version bundled with xampp.
  7. the original template. I just want to follow everything in the book step by step as explained.
  8. Hi sir, I could not find the coffee template that you chose for the Part three of this book before breaking them into PHP files in the code that I downloaded. pls, can we get it, I want to really follow where you got the box that you converted to Constant on page 210.
  9. Thanks very much, I am reading a javascript book and is pointing me towards the right direction. If I need any further assistance on this I will post it in any javascript forum. but I'm still coming with a lot of questions on php when I am through with reading PHP and MySQL for Dynamic Web Sites, Fifth Edition
  10. Hi everybody, I want to write a php code that extract numbers say 4567 from an image when you press scan button and then sum the numbers together. I have used one javascript library but I'm having problem in converting the numbers into an array. pls. I need an help urgently.
  11. Abiagail I wrote the two queries, I would have posted it but this text editor does not allow to copy and paste I wouldn't know why it is preventing me from pasting? or is there any other way to paste on this particular text editor?
  12. Thank you Bill. My problem is on how to insert into two tables simultaneously, I tried inserting into orders table after the line 100 in the registration.php which read $uid = mysqli_insert(dbc,q); $_SESSION['reg_user_id'] = $uid; but it is not working. You know what I need to know is how to insert into multiple table simultaneously. i.e users and orders table upon knowing the user_id
  • Create New...