Jump to content
Larry Ullman's Book Forums

angelsonearth

Members
  • Posts

    42
  • Joined

  • Last visited

Everything posted by angelsonearth

  1. Hello, friends! Please note that I have a question that is partially related to this inquiry. I believe that you would add slashes when inserting or updating code from, say a POST array from a form, into the MySQL database. So, for "inserts" and "updates", you would use add slashes or mysqli_real_escape_string? When else would you use the add slahes or mysqli_real_escape_string? Also, I'm not sure when you would use the strip slashes function (or when you would reverse the mysqli_real_escape_string function if that is at all possible). Please kindly advise!
  2. Thanks so much, Larry! I'm a big fan of your line of books for good reason! Congratulations on the excellent forum and terrifict writing! I thought it would be a nice touch to add the documentation for changing PHPMyAdmin's config file to reflect the new password. I copied and pasted the following from the XAMPP site: Here it is: With the"XAMPP Shell" (command prompt) you can also change the password. Open the shell and execute this command: mysqladmin.exe -u root password secret Of course, your password should not be "secret", too. In the next step you must adjust the phpMyAdmin configuration for this new password. In the file "\xampp\phpMyAdmin\config.inc.php" change the lines: $cfg['Servers'][$i]['user'] = 'root'; $cfg['Servers'][$i]['password'] = ''; to: $cfg['Servers'][$i]['user'] = 'root'; $cfg['Servers'][$i]['password'] = 'secret'; Instead in the XAMPP Shell, you can also change the password with phpMyAdmin, and then adjust the phpMyAdmin configuration.
  3. Thank you, Larry! It's a good reason, too, to peruse the phpMyAdmin docs for the first time. Before I sign off, would you please be so kind as to let me know whether I would need to use the same password and username (root) as I used in MySQL for phpMyAdmin. In other words, do the passwords for the root user need to be the same for both the MySQL client and phpMyAdmin? Also, when using mysql_connect files, would I use the password and username for the MySQL root user or for the phpMyAdmin root user? Please forgive me for my confusion as I'm just starting to use the system. Once I'm active with using it, I think working with the actual code will be a lot easier than this initial set-up learning stage. Thank you so much for any and all advice.
  4. Hello again, friends! I changed my password in MySQL, keeping the "root" component for the username. However, when I go into PHPmyadmin by typing localhost and then entering the PHPMyAdmin section, access is denied with the following message: "phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server." I am wondering what I need to do to be able to access the PHPMyAdmin area as I haven't done any work at all in PHPMyAdmin up to this stage. Please kindly advise--hopefully with some detail about the code if I need to re-enter the password and username I used in MySQL into PHPMyAdmin. Thank you!
  5. Thank you for the kind advice. I have learned that programming on the Windows command line is on a lower level, I believe, which is closer to the operating system. Therefore, I'd need to back up a lot of files if I were to have the courage to work on that level. PhpMyAdmin, I believe, is more exclusive to the PHP and mySQL components, so there is less risk. Thank you for the great advice of working in phpMyAdmin, friends!
  6. Hello, friends! Thank you for viewing this post and potentially offering a more-than-welcome reply! Please kindly note that I am wondering how I would import a database on my Windows desktop into mysql. One of the questions I have concerning this is how do I reference the absolute path to the file on my Windows desktop--in the command line-- when it has spaces in it (i.e., C:\Documents and Settings\AngelsonEarth\Desktop)? Please be so kind as to help me find a way to import the database create files (from a tutorial I'm viewing) into Mysql. Thank you so much for your time and consideration! You have all been amazing thus far and I'm eternally grateful for all of the wonderful feedback!
  7. Thank you very much, Larry,for the conscientious and helpful reply--and all of the excellent learning tools! Have a great day!
  8. Hi Larry and Jay--and all of our other friends on the forum! Jay, I, too, plan on purchasing Larry's Ruby book--as well as his entire collection of books (I'm that impressed with the learning curve with his books)! I've already purchased almost all of his Web programming books (I own six so far--in a matter of about four months since starting to read his books-- with more Ullman purchases up-and-coming), but am wondering about which order to read the C, C++, and Ruby books in. Any advice on the matter? I have no programming background outside of Javascript, PHP, and SQL. Please kindly advise! Thanks very much, friends!
  9. Hello friends! Please kindly note that I am having problems understanding the function my_error_handler ($e_number, $e_message, $e_file, $e_line, $e_vars) in the configuration file because I never seem to encounter it being called in the e-commerce paypal site design. I just noticed, in a second read, that it has the following code apply: set_error_handler('my_error_handler'); Please kindly forgive my lack of foresight, but what are the implications of the function my_error_handler being attached to the custom function set_error_handler for handling errors. For instance, how would it be invoked in the code later on? and what exactly is a custom function for handling errors. Please kindly clarify? Thank you so very much to everyone and anyone who provides some sort of clarification. Bless you all!
  10. Thank you very much, friends, for the wonderful advice! FYI, I found some other relevant material related to assigning the mysqli_connect file to a location outside of the server. It's in Larry Ullman's book on Effortless Ecommerce around page 123. He basically says that some servers won't allow you to upload a document outside of the root Web directory (shared servers?), but you could password protect the file (or, the file's directory(?)) within the Web root.
  11. Hello, friends! I'm wanting to make a subfolder in htdocs that would point to the root directory for my Web page. I'm initially placing my Web page on the localhost server, but intend to eventually transfer it to a paid remote server. I'm wondering if I would place the mysql_connect file (in order to keep it secure) either 1. inside the htdocs folder but one folder above the root directory or 2. above the directory for the htdocs folder as is done in Larry's book. (Forgive me if I'm not expressing this correctly) If 2. above is correct, how would I reference the mysql_connect file in the includes? Also, where would I place the msql connect file on a local host server if it's one (or two?) levels outside of the Web root directory? Thank you for your time and energy!
  12. Oh, wonderful news! I'm so excited about reading the Javascript and Ajax books next (along with the rest of the entire Ullman collection!). Thank you very much for the valuable lead, HartleySan, and thank you so much Larry for the superior book series and marvelous forum!
  13. Hello, my friends! Please kindly note that I need to place live, streaming stock quotes (or are they called stock indexes) on the top of a client's Website. The end product would look like the very top line of the page: www.optionmonster.com. However, I'm overly ambitious with a limited information set, not knowing how to go about achieving this goal. (Thank God for Larry's forum and books!) I understand that sites like Associated Press and Business News Network offer these RSS feeds, but I'm not sure what the process if for receiving them and getting them active on the top of the Website. As they are live streaming, continually changing stock prices, I believe, I imagine that I'd need to use PHP and assign the components to variables. Please excuse my lack of know-how, but any and all pieces of advice would be greatly appreciated here. How do I get these stock quotes up-and-running on the top of the Website like they are at www.optionmonster.com? Thank you so very much!
  14. Thanks so very much for the very generous and helpful advice, HartleySan! I will heed your recommendations and start with the JS book before moving onto Ajax. Thank you very much, again!
  15. Hello. I just read the AJAX chapter in PHP and MySQL and want to learn much more on the topic--especially concerning PHP's role with AJAX. I'm seriously considering buying the AJAX: Visual QuickProject book, but noticed it was published a while ago. I'm wondering about both what deprecated features (in PHP and Javascript) might be present in the book and whether I should start with the Javascript book. Please kindly advise. Thank you!
  16. Thank you very much for the very kind, generous, and helpful advice, Sonal and Larry! I know that lynda.com offers a great month-to-month subscription that offers extensive video tutorials on various tools, such as Wordpress, MySQL, and PHP. Do you have any recommendations for where else I might be able to go to get versed on Wordpress's internal structure. (By the way, Larry, I enjoyed your books so much that I'm now enrolling in a Comp Sci degree program with a Web programming specialization--thank you for the inspiration and excellent materials!)
  17. Please kindly note the following question: Is it possible to integrate a Wordpress blog with a PHP and MySQL site (e.g., one running an e-commerce component) such that the following is possible: 1. the Wordpress blog is log-in secured through PHP and MySQL 2. articles to the wordpress blog are sent from the PHP site to Wordpress through an admin interface (kind of like a CMS system) that the user (who doesn't know any programming) would utilize? In short, is it possible to seamlessly integrate communications between Wordpress and PHP/MySQL? If so, how could this be accomplished? Thank you very much for your time.
×
×
  • Create New...