php - pass MySQL link to a class method -

-

Here's my problem, I have a class with Away method, I want to pass it with mysql db link, So I create a new object from the class, and call the saveProperty method, and in my main file I have created a MySQL connection and saved it in a var called $ db, when I call the method it is from this link Is: saveProperty ($ db)

But to save the data, I get an error:

Warning: mysql_select_db (): Distributed logic is not a valid MySQL-link resource C: \ wamp \ www \ < / P>

WARNING: mysql_query (): The supply logic is not a valid MySQL-link resource C: \ wamp \ www \ aqaria \ classes \ property.php on line 99

Which means that I did not correct the link?

& lt ;? Php class test {function saveProperty ($ db) {$ sql = "& lt; mysql_query ($ SQL, $ Database); If (mysql_affected_rows ()> 0) echo " data was saved "; Else Echo "& lt; h3 & gt; Error saving data & lt; / h3 & gt;"; }}

Here is the calling code: 

  $ db = mysql_connect ('localhost', 'root', ''); Mysql_select_db ("aqaria", $ databases); $ Property = new property (); $ Property- & gt; SaveProperty ($ Database);

Although this would work if I had added the globile keyword to the class method, then I was wondering if I could pass the database connection link?

Have you tried with a reference?

In addition to $ db you can use mysql_affected_rows () 

  function property (& amp; $ db) {$ sql = "& Lt; & lt; the query goes here & gt; & gt; " Mysql_query ($ SQL, $ Database); If (mysql_affected_rows ($ db)> 0) echo " data was saved "; Else Echo "& lt; h3 & gt; Error saving data & lt; / h3 & gt;"; }

Comments

Post a Comment

Popular posts from this blog

email - PHP mail error ... failed to open stream : permission denied -

-
I am trying to send an email using PHP mail. I get the following error: WARNING: Unknown: Failed to open the stream: Permission denied in unknown in line 0 Fatal error: unknown: required to open the required '/ Home Php $ name = $ _REQUEST ['name']; $ Email = $ _REQUEST ['email']; $ Theme = $ _REQUEST ['subject']; $ Message = $ _REQUEST ['message']; Mail ("myemail@myhost.com", "topic title", $ message, "sender: $ email"); Header ("Location: http://www.google.com"); ? & Gt; This message is not a mail error PHP file can not open ask_us.php if ask_us If the .php is your file, then check its permissions (and parent folders).
Read more

c# - ListView onScroll event -

-
I am programming a simple C # application, and I need a Scallow event on the list view. So I inherited the original ListView class created in ListviewEx witch. I found out how to locate the scroll message from WinAPI and I modified the WndProc method. Now I have this WndProc: protected override zero WndProc (Ref message message) {base.WndProc (Ref I); If (m.msg == WM_VSCROLL) {onScroll (This, New EventArgs ()); }} But the problem is, I do not know how to know about scrolling information. This data should be in wParam, but there is a LOWORD macro ++ like in C in C # and I switch to find the criteria like SB_ below, SB_ENDSCROLL, SB_PAGEUP etc. there any way Need to change the LOWORD macro from C #? Or any other way to find the necessary parameters about scrolling? You can define the WParam constants as the following: Private const int WM_HSCROLL = 0x114; Private Constant WM_VSCROLL = 0x115; Private contact int SBHOZZ = 0; Private Consultant SB_VERT = 1; Private Con...
Read more

c - Linux mmap() error -

-
I have a memory map file, out of which I want to parse the content of the buffer. MMAP () achieves success, and I can successfully use fprintf to print the buffer content in the file. However, when I try to access Buffer as an array in my program directly, I get a partition error. Why is this happening? Here's the code: #define PTT_DUMP "/ home / druru / somefile". . Int fd_ptt_dump = Open (PTT_DUMP, O_RDONLY); Structure state struct_ptt_dump; Fstat (fd_ptt_dump, & amp; struct_ptt_dump); Printf ("\ n \ n \ t \ t \ t --- Size of dump =% d ----- \ n \ n", struct_ptt_dump.st_size); Four * membuffer; Four pid_num [100]; Four cycles [100], examples [100], CPI [100]; Int pid_index = 0; Int cycles_index = 0; Int instr_index = 0; Int cpi_index = 0; Int len ​​= (int) struct_ptt_dump.st_size; Int newline_count = 0; Int n = 0; If ((membuffer = mmap (0, struct_ptt_dump.st_size, PROT_READ, MAP_FILE | MAP_PRIVATE, fd_ptt_dump, 0)) == (caddr_t) -1) err_sys ("mm...
Read more