php - INSERT INTO called once but runs twice (not in a loop) -

-

I have a query that appears every time, it is run twice, which is not intended to be done before and after The logging in the file is added and the file is cleaned before running the script.

I do not think I have to post another code because I believe my logging proves that this query is only called once.

code: 

  file_put_contents ($ _SERVER ['DOCUMENT_ROOT']. '/ PDOErrors.txt', "\ n \ n 1 query immediately before the ban." Date ('r'). "(1)", FILE_APPEND); $ Sth = $ mdbh- & gt; Query ("INSERT INTO banned_IP SET ip_add = '$ ip', proxy_ip = '$ proxy_ip'"); $ Sth- & gt; Executed (); File_put_contents ($ _SERVER ['DOCUMENT_ROOT']. '/ PDOErrors.txt', "\ n \ n User banned using query 1." .date ('r'). "(2)", FILE_APPEND) ; Return 999;   
 Note that immediately after its running immediately there is a  return  and even if it is called twice, then my  PDOErrors The .txt  file will show diagnostic data for each run, which does not.  
  PDOErrors.txt  runs the first diagnostic data, but the second never runs!  
 Here is a copy of PDOErrors.txt  
  Precisely before the restriction query 1. Thu, 21 Mar 2013 13:38:56 +0800 (1) Exception 'PDOException 'With message' SQLSTATE [23000]: Conflict of Integrity Handicap: 1062 Duplicate Entry '127.0.0.1' for 'ip_add' '/ home / speaker / documents / websites / our_websites / bookkeeper / books / bookkeeper / public / include / Classes / loginAttempt Class.php: 137 Stack Trace: # 0 Home / Speaker / Document / Websites / Our_websites / Bookkeeper / Books. Bookkeeper.f / Public / Inclusion / Category / Long: V.PP (137): PDOSTATment - & gt; Execute () # 1 /home/peter/Documents/websites/Our_websites/bookkeeper/books.bookkeeper.ph/public/includes/classes/login.class. Php (980): Login-> Record Login Att (Array) # 2 / Home / Spear / Documents / Website / Our_Websites / Bookkeeper / BooksbookPier.F / Public / AJAX / Login. User.fip.25): login-gt; DoLogin (Array) # 3 {main}   
 Let me tell you that before each run, I will completely clear the  banned_IP  database table.  
 I am also logging all the questions because it is a development environment and the log of the query can be seen below:  
  708 queries restricted in the INSERT iIP SET ip_add = '127.0.0.1', proxy_ip = '708 question INSTEED, restricted IP SET ip_add =' 127.0.0.1 ', Proxy_IP =' 708 Leave   
 I think only this question That would include two sets of diagnostic data in PDOERs .txt if not query on an empty database table Sector has generated an error message on the very first run. What could be the reason for this?   
 
 
 PDO-> The query will execute a query and PDOStatement will return the object, now you are returning PDOStment again which causes this error.  
 Use PDO-> PDO-> which gives the PDOSTMent object and then executes the statement or PDO-> Use Query and do not execute PDOATatament

Comments

Post a Comment

Popular posts from this blog

excel vba - How to delete Solver(SOLVER.XLAM) code -

-
After opening several examples of macro / code written, I suddenly get stuck with a code that seems safe. Solver (SOLVER.XLAM) is doing this notation and I would like to remove it from my system. I do not think this is a relativant code. Can anyone tell me what should I do? I have already installed something to remove the password but Solver is still asking for password and I can not get rid of it! itemprop = "text"> Solver Excel is add-in If you want to delete it, then Excel Application & gt; Options & gt; Add-ins & gt; Search for 'Go to' button and gt; Uncheck the solver on the list like press something (I can not give you the exact path because I have the Polish version of Excel). Trying to open Solver's VBA code is not good because it There is allegedly copyright. Besides, I do not think Solver creates any disadvantages while working with Excel or VBA.
Read more

github - Teamcity & Git - PR merge builds - anyway to get HEAD commit hash? -

-
I have a team city build project with Gitbab VCS route, I have been triggered for both / head on PR and / Merge the referee. The annoying thing is that you can not do anything useful with the merged hash - it is not present in Gitobb. I want to exclude newsgate packages with head in gutub comet situations in the version number along with Hewash (Newsaging 7) for the music build, but against head hash. However, I can not see a way to get the head hashes while constructing that merge. I just want to head because it's useless - we only care about merge. (PR - Pull Request) This command works reliably while running One on / merge is git log --no-merge -1 ---- = '% h'
Read more

ios - Replace text in UITextView run slowly -

-
I have a UITextView and I change a word like the code at the end of UITextView.text: - (void) Replace TexttechWitWord: (NSString *) word {NSString * currentTextViewText = self.textView.text; CurrentTextViewText = [currentTextViewText stringByReplacingCharactersInRange: NSMakeRange ([self.textView.text length] - [word length], [word length]) withString: word; Self.textView.text = currentTextViewText; } Replacement work is fine, but it runs very slowly and very slowly when the textView now lengthens Is there any better way? I try the replacement range: with text for a week but still stuck. Not to know how to use it to replace it in your case. Please guide! Thanks in advance! This is an important job. As you are using an irreversible string and you are creating a very long string and before Assigned to NSString created from. NSString will be used instead of NSMutableString . - (UITableViewCell *) TableView: (UITableView *) Table View CellForOutPath: (NSIndex...
Read more