Search DaniWeb - terminology

Multiple MySQL connections + transactions 1 Month Ago by Dani … transaction associated with Connection 1 This is probably the wrong terminology, but I hope you get the idea of what I… Re: Multiple MySQL connections + transactions 1 Month Ago by Dani A slightly related question: Is it okay to use PHP's `mysqli::select_db()` function to switch databases in the middle of a transaction? This is what got me into trouble in the first place, when I started a transaction, performed some writes, switched databases, and then wrote to that second database, and then switched back, and performed some … Re: Multiple MySQL connections + transactions 1 Month Ago by Salem https://www.php.net/manual/en/mysqli.select-db.php I think the key word in all of this is "default". You can probably do what you want, but you have to refer to each DB by it's own handle. Using `select_db` is fine, if you only have one DB and you want to be lazy about referring to it. So you make it the default DB. But as … Re: Multiple MySQL connections + transactions 1 Month Ago by Reverend Jim As far as I know you can connect to more than one database at a time but you require a separate connection object for each one. Since queries go through the connection object you can't run a query on more than one db at a time. It seems to me that transactions are also connection based so you would have to manually roll back a transaction on A if … Re: Multiple MySQL connections + transactions 1 Month Ago by Dani I am already using multiple MySQL connections throughout the project, as well as select_db() in some other places. My question specifically revolved around if anyone can explain why select_db() implicitly committed the transaction, and then when done again to return back to the initial database, it did a rollback instead of commit. Re: Multiple MySQL connections + transactions 1 Month Ago by Reverend Jim In that case I can't suggest anything. I've never had to update multiple databases for any of the systems I set up. Re: Multiple MySQL connections + transactions 1 Month Ago by toneewa You're not suppose to switch databases with a connection mid-transaction. It's by design to rollback because it considers it a change to the session context. XA Transactions can be done if you use the InnoDB storage engine. Create separate PDO connections for each database. I wonder what kind of results you get with autocommit, serializable … Re: Multiple MySQL connections + transactions 1 Month Ago by Dani > If the databases are on the same server and use InnoDB, you can use fully qualified table names, and write to multiple databases on a single connection. That's what I ultimately started doing instead! Thank you so much for a definitive answer to my question. Re: Terminology, Compiled software? 12 Years Ago by christinetom Thanks np and decepticon.. that helps. All this terminology,, confuuusing.. That makes sense anyway so thanks so much for coming back.. Nested Program Generation -- Looking for Terminology 17 Years Ago by crwtom … report on a software package. I'm looking for standard terminology for the process/construction of one program generating another program… scientists call such program constructions? What is the general, theoretical terminology? Is there some theory attached to these constructions? Thanks, Thomas Programming Terminology 13 Years Ago by scarcella Hi, i am new to programming and have self taut myself PHP. I am very comfortable with PHP and know the gist of things. But my real set back is the terminology and logical or theory side of programming. Where must i begin to learn this, or what websites or YouTube can teach me this? Thank you in advance. Re: Programming Terminology 13 Years Ago by zeroliken [QUOTE]the terminology and logical or theory side of programming.[/QUOTE] As in … How do you pronounce certain networking terminology 4 Years Ago by andrew58 Do you guys have any examples of networking terminology that some people pronounce in different ways that completely throw you off? Similar to GIF vs JIF but networking related. For example, there are different ways people choose to pronounce GUI, OSI, and CCIX. Any other curious examples? Re: How do you pronounce certain networking terminology 4 Years Ago by pasta … Network Engineer, I had heard many people misproounce simple such terminology such as EIGRP and IGRP in my experience, others not… Re: How do you pronounce certain networking terminology 4 Years Ago by Naheedmir The following are some of the networking terminology that most people pronounce incorrectly: * SQL used to be SEQUEL * SUS server * VPN as a vippen Re: How do you pronounce certain networking terminology 2 Years Ago by dark404 The following are some of the networking terminology that most people pronounce incorrectly: SQL used to be SEQUEL; SUS server; VPN as a vippen. Terminology 19 Years Ago by Mr.'BackUp' I apologise in advance for my ignorance :!: - but if robots from Google for example are visiting your site then does that mean it has been 'indexed'? I ask because I read that if you want to be 'indexed' into Google within a short space of time then it would be a good idea to link to a high PR site of say 7. Even if that means buying the link … Re: Terminology 19 Years Ago by jewboy Most likely yes. The best way to check if your domain and pages are indexed in google is by typing in: site:[url="http://www.mywebsite.com"]www.mywebsite.com[/url] site:[url="http://www.mywebsite.com/page.htm"]www.mywebsite.com/page.htm[/url] If Google returns a match, you are indexed. The same procedure works for all … Re: Terminology 19 Years Ago by TopDogger Don't be in a hurry with Google. Most new sites get stuck in Google's Sandbox for 5 to 8 months, which means that the site probably won't rank well in G for most competitive terms for quite some time. A well-designed site with good content should rank well in MSN and Yahoo within a month or two. Getting some links pointed to your site does help. … Re: Terminology 19 Years Ago by jewboy Being indexed by Google and ranking for a keyword are two separate issues. Some peopel observe a sandbox effect - in which it can take almost a year to rank for a particular keyword. A few words about directories. I would avoid free directories or directories that want recip links. In my opinion, and that of many top search marketers is they are a… Re: Explanatin needed on a bunch of basic database terminology 14 Years Ago by AndreRet Use the following links search engine to search for whatever terminology you need if not found in the page itself. [URL="http://en.wikipedia.org/wiki/Relational_database"]http://en.wikipedia.org/wiki/Relational_database[/URL] Re: Clarification of terminology! 14 Years Ago by mike_2000_17 …, as far as I know, they are synonymous in programming terminology as well. "Utility functions" are similar in some… Terminology and Grammer 15 Years Ago by Bertie Is it correct to say that you can create a DLL which contains an abstract class that each programmer must declare instances of to keep segragated code working independently of eachothers progress??? I understand that most forums don't allow their users to delete their threads, so dont mind the Judge Judy attitude. Oh, can you elaborate on … Re: Terminology and Grammer 15 Years Ago by Bertie ... do you define an interface, [B]then[/B] write the implementation to a DLL, [B]then[/B] pass the DLL around, [B]then[/B]... I can't figure out how to allow each programmer of a "team" to work together [U]without[/U] causing a [I]revolution[/I] every time something in the code changes. I know to a high degree that the interface will… Re: Terminology and Grammer 15 Years Ago by Bertie Okay, so I think I figured out that you do change the DLL, and load/reload it into the program. ... Help Me ... I need engineering advice please ... Re: Terminology and Grammer 15 Years Ago by Ancient Dragon You mean you want help on how to keep your team members happy and still be able to develop the DLL? >>do you define an interface, then write the implementation to a DLL, then pass the DLL around, then. Basically, yes that's the way to do it. But it doesn't mean that DLLs can not be changed once it has been passed around. The programmer … Re: Terminology and Grammer 15 Years Ago by Bertie I believe that I understand. Re: Terminology and Grammer 15 Years Ago by BeElZeBub .. ironic that your Q Title contains a Spelling Error ! Gramm[B]A[/B]r ! Re: Terminology and Grammer 15 Years Ago by Bertie [QUOTE]Ancient Dragon: You mean you want help on how to keep your team members happy and still be able to develop the DLL?[/QUOTE] Yes Sir. [QUOTE]Ancient Dragon: ...nightly command-line builds...[/QUOTE] Sir? I will look into this. Help is much Appreciated Terminology of user-defined types 14 Years Ago by ttx336 Hello All, this is my first post here, I was a novice Pascal and C programmer back in the DOS days, now I am taking a C++ class based on "Programming - Principles and Practices Using C++" by Bjarne Stroustrup. In the book he gives an example in which he is explaining about "Tokens"... I have pared that down to the bare bones and…