Jump to content

niche

Members
  • Posts

    3,671
  • Joined

  • Last visited

  • Days Won

    17

Everything posted by niche

  1. I use GeomFromText() mysql function all the time
  2. https://www.w3schools.com/php/php_ref_date.asp https://www.w3schools.com/php/func_date_date_sub.asp https://www.w3schools.com/php/func_date_time.asp EDIT: Let us know if you need any more help
  3. PDO is a step in the right direction. https://websitebeaver.com/php-pdo-prepared-statements-to-prevent-sql-injection
  4. float and div properties with graphs, tables and explanations inside the divs EDIT: giving each div a height and width might simply you understanding of div relationships on your page
  5. Everything on a website is some kind of risk. Looks like you have your unordered list. EDIT Darn the torpedoes. What do you want to do next?
  6. Always room for improvement and hopefully you'll never stop improving. Obviously you're learning so don't be afraid to break things. Experiment. Make mistakes. Decide for yourself what you think you've learned. Have the courage to be wrong. That's when I'm most likely to remember what I learned. The bigger the mistake the bigger the memory! EDIT: The most important question is what you posted good enough for you right now?
  7. Try wrapping this in an if statement that tests for string length: $var = 7; echo sprintf('%02d', $var);
  8. https://www.w3schools.com/sql/sql_update.asp Just substitute col name for value.
  9. Is your question about how to "tuck a $_SESSION"?
  10. Where's it breaking and what error messages are you getting?
  11. Depends on what you want to do and how you want to do it.. Coding is a Superpower. Don't take my word for it. Take Drew Houston's word for it. He's the co creator of dropbox. https://www.youtube.com/watch?v=nKIu9yen5nc Listen to his quote at the 00:04:50 mark (approximately). How much time should someone spend to get a Superpower?
  12. Sure! https://www.w3schools.com/sql/sql_count_avg_sum.asp
  13. Don't understand your question
  14. Check $row["StoryHeadline"] instead of row["StoryHeadline"] 
  15. Looks to me like 'r' is being returned by your query. Please post your query.
  16. What's actually in your results array when you dump it?
  17. Query your table to initialize values then do your nested if statement.
  18. Looks like ID 1 is the ID that has the same a/b values. How does ID 4 & 5 qualify?
  19. Not badly designed (yet). Bad approach! Many thanks to the fox and Funce. Found this link and learned more about PDO investigating PDO rules. https://stackoverflow.com/questions/9250434/pdo-quote-method
  20. Thought I could alter a table with a pdo query and binding. Apparently not. Is there a way to use a pdo query to alter a table without binding using some kind of variable? if so, what would a simple example look like? Else, I'll use mysqli.
  21. JSG said it best. $con doesn't exist. Obviously, the site's not making the connection. For me, that was the whole point of learning how to code. How do I manage the use of frameworks and libraries, when I know I don't have the code skills that would've allowed me to do it myself. https://www.w3schools.com/php/php_mysql_connect.asp I'm not criticizing any one. Just talking for myself. IMHO, frameworks and libraries are the rewards for knowing how to code. EDIT: If needed, there are very good vids on youtube RE: PHP Objects
×
×
  • Create New...