Jump to content

drewbee

Members
  • Posts

    171
  • Joined

  • Last visited

    Never

About drewbee

  • Birthday 03/02/1984

Contact Methods

  • AIM
    drewbe121212
  • Website URL
    http://www.boardgamevault.com

Profile Information

  • Gender
    Male
  • Location
    Columbus, Ohio

drewbee's Achievements

Member

Member (2/5)

0

Reputation

  1. The variable $title should be coming from the $_GET parameter. There is, however, the variable $newTitle. Did you mean to put echo "$newTitle"; ?
  2. Ok. After doing some tests and reading up on some benchmarking... mysqli_multi_query actually ran slower then looping through and updating each row individually. Seems kinda pointless? I havn't got to test this out yet, but how do transactions usually operate? {start transaction} {for loop 0 > 24; index = x} {update foo = bar, seed = hash where id = loop{x}} {/for loop} {end transaction; commit} Does this end up running as 25 seperate queries, or is it grouped and sent to mysql all at once?
  3. ^^^^^ Beautiful What is mysqli ? It can be used in conjunction with the old stuff, right? mysql_query etc.
  4. Its from a script that will be running that is based launched off of user actions. At any time, this very script could be running 100's of times. Obviously there is some scability issues with that current setup. While I have faith that it will not have any hicups with 10 users running it, the amount that it potentially could be running at is the current user base that I have. This is why I am seeing an issue with this
  5. Hello all, to summarize this i basically have a table that gets selected upon, then for each row that is returned needs to be updated. IE $query = mysql_query("SELECT id FROM tablename WHERE foo = bar"); while ($row = mysql_fetch_assoc($query)) { $update = mysql_query("UPDATE tablename SET column = 'blah' WHERE id = $row['id']"); } This is for batch processing so the records are actually pulled in earlier, and then updated later on. (ID and new information is saved in an array though) The batches will generally run between 25-50 records at atime, and obviously making 25-50 update statements in a few seconds is not deseriable. What is the best way to optimize this? Perhaps using transactions and do 1 final commit at the end?
  6. Thanks Barand. I have the hardest time remembering that name for some reason!
  7. jonsjava Yes --- what are they called? php, thoes are html comments :x
  8. Everyone, I have been trying to explain to someone how to use the >>> code, but I have not used it in a long time and my syntax is off slightly. What are these called? I have been looking around for the name of it... but obviously searching google for ">>>" doesn't really help to much. These are called ........ blocks... ? echo BLAH>>> my text BLAH;
  9. A proxy is used to spoof ones ip address by redirecting requests through it. A person with the IP address of 111 will use a proxy changing his ip address to 222. You will never know where the original request came from, only that it came from the proxy. Some of the more advanced proxies have rotating ip's, meaning one page load might show the user from the USA, and the next page load may show them from China, depending on the random IP pull from the proxy. IP Banning is really never a safe bet, because as stated above, the ones who you actually need to worry about will not be able to be blocked by there IP address due to proxies / spoofing.
  10. There are different types of constraints and relationships, but I am not sure I understand why you would want to use a non-pk in one table as a fk in another? A relationship can be between anything; but it just makes sense to use the primary key.
  11. The constraint will not add to the table if your current data violates the constraint.
  12. hi MabiSm, I did have this set as well. While all I did was updated the PHP.ini with the same values that were already set, it seems to be taking effect now. Strange.
  13. From what I am reading as well, in firefox you can get a plugin that changes your user-agent. If you set this user-agent to GoogleBot, you can see all the answers without scrolling all the way down. SEO SPAM anyone?
  14. roopurt, OMG. You are correct. I can't believe I never seen that before. You have to scroll all the way down to the bottom ,but everything is re-repeated with the answer-unblocked. This includes the accepted solution. Wow... amazing... how in the world was this never noticed before (atleast by me?). I guess the assumption that the values were blocked out at the top kept me from looking below.
  15. Everyone, I can't get error reporting to work on some of my files, yet it works on others. I cannot see what the consistency or the changes are in between, but at the top of every php file (class and class host file) I have the following: error_reporting(E_ALL); ini_set('display_errors', '1'); IN the php.ini I also have set error_reporting = E_ALL; When a fatal error occurs (sometimes), all I get is a white screen; and this is terriblely difficult to debug as you can imagine. Does anyone have any clues or insight as to what might be going on here?
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.