Jump to content


  • Content Count

  • Joined

  • Last visited

  • Days Won


Everything posted by niche

  1. niche

    PHP error

    looks like you need a ; at the end of this line: $mbox = IMAP stream, $mid = message id
  2. niche

    PHP error

    pls post with the code tags <>
  3. niche

    PHP error

    might as well post your code so we can see what's actually on line 73
  4. Try using value ="some data" instead of placeholder. value =" ' . <?php $var ?> . ' " or value =" ' . <?php $var['columnName'] ?> . ' " depending on situation if I'm understanding your question
  5. niche

    fetch the data

    create a variable for everything inside the parens. Do you need procedural or OO code?
  6. Please post the relevant file content or a sample.
  7. just put commas between the words. else, you'll need to use something like php if you have a lot of them.
  8. Where's the relevant part of your code?
  9. My understanding is that PDO does the sanitation for you. Validation is a different issue.
  10. Bingo: https://www.w3schools.com/php/php_mysql_create.asp This will help too: http://www.developphp.com/video/PHP/PDO-Prepared-Statements-PHP-Tutorial These will get you started Also, remember that google is your friend. Always consider googling your topic. A good google will always produce plenty of likely answers. That's especially helpful when almost everyone's asleep.
  11. niche

    php form and mysql

    This will get you started: https://www.w3schools.com/php/php_forms.asp
  12. niche

    php form and mysql

    The answer to your specific question is you'd use a $_GET or $_POST method.
  13. You probably have a problem when you bindParam especially when you expect a different row count. Is :voor really an INT? http://php.net/manual/en/pdostatement.bindparam.php Also, you need to use try/catch for errors.
  14. dsonesuk's example is much simpler than the one I found: https://codepen.io/quasimondo/pen/lDdrF
  15. https://www.w3schools.com/css/css_rwd_intro.asp
  16. I use file filezilla for ftp client to upload.
  17. It's an array that gives you a place to put data that a user generates during their session. It's an important concept. http://www.w3schools.com/php/php_sessions.asp
  18. niche

    align form with css

    We need to see more code. Else, look into the css box model, divs, and float
  19. niche

    What's the real problem?

    Understood. I haven't encountered many limitations with mysql. Obviously this is one of them. Thanks for the reinforcement jsg.
  20. I think I'm hitting a limit that looks like a time limit, but it's probably something else. What I don't know. Here's my script : UPDATE du_raw2, cris4 SET du_raw2.sn2 = cris4.sn WHERE du_raw2.key1 LIKE CONCAT('% ',cris4.sn,' %') My localhost is a wampserver with mysql 5.6.17, php 5.5.12, and apache 2.4.9. My code parses mailing addresses. It targets the key1 column in the table du_raw2. The key1 column contains addresses (all the address components on a single line). cris4 contains all the street name possibilities for a specific city. There are 2000 of them. The script scans each address in the target file (when it has less than 2000 rows) and returns the street name if it's found (from the 2000 street name possibilities). It successfully updates 1000 target rows in a second. The query log says the connections are opened and closed.It successfully updates 2000 target rows in three seconds. The query log says the connections are opened and closed.It times-out somewhere between 2000 and 3000 target rows. The query log says the connections are opened, but never closed. When I reduce the number of street name possibilities from 2000 to 50, my script successfully processes 3000 target rows in 26 seconds. The query log says the connections are opened and closed. I expected it to take less than 26 seconds (causing me to think it's the way I designed the code, but then I'd need know what concept I'm violating). My script isn't in a loop (yet). I have 100,000 rows to process. I'm just peeling it back to figure-out where it chokes. It's not the data. It's the number of rows and or the way I'm applying the code. I'm using it with php, but I doubt php is the problem, I've already played with set_time_limit(). I suppose I could work around the problem in a while loop. It would only run 50 times. I'd rather know what the true problem is. What do you think? Where else can I look?
  21. Here's the tutorial that will tell you how to find your css. Even if someone just gave you the correction you probably need, you'd still have to know how to find your css to make the change. This willl show you how to find it: http://www.w3schools.com/css/css_howto.asp
  22. http://php.net/manual/en/function.isset.php
  23. Yes. Parens short for parenthesis.
  24. Sure. Also, you'll need to use parens around the ORs WHERE (show=1 AND deleted=0 AND id=1) OR (id=2)
  • Create New...