Jump to content


  • Content Count

  • Joined

  • Last visited

  • Days Won


Everything posted by niche

  1. No doubt a call out to people that somewhat justifiably dislike acronyms
  2. I use GeomFromText() mysql function all the time
  3. 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
  4. PDO is a step in the right direction. https://websitebeaver.com/php-pdo-prepared-statements-to-prevent-sql-injection
  5. 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
  6. 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?
  7. 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?
  8. Try wrapping this in an if statement that tests for string length: $var = 7; echo sprintf('%02d', $var);
  9. https://www.w3schools.com/sql/sql_update.asp Just substitute col name for value.
  10. niche

    Upload image code example

    Is your question about how to "tuck a $_SESSION"?
  11. Where's it breaking and what error messages are you getting?
  12. 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?
  13. Sure! https://www.w3schools.com/sql/sql_count_avg_sum.asp
  14. Don't understand your question
  15. Check $row["StoryHeadline"] instead of row["StoryHeadline"] 
  16. Looks to me like 'r' is being returned by your query. Please post your query.
  17. What's actually in your results array when you dump it?
  18. Query your table to initialize values then do your nested if statement.
  19. Looks like ID 1 is the ID that has the same a/b values. How does ID 4 & 5 qualify?
  20. 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
  21. 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.
  • Create New...