Tag Info

New answers tagged

3

Use mysqli or PDO libraries for PHP, do not use mysql, as it is deprecated Use prepared statements: they are cleaner, less prone to SQL injection and, in some cases, faster to execute Use exceptions to capture errors throughout your code -query fails, query gets killed, database crashes, unable to connect, ... If you feel intimidated by SQL, an ORM can help ...


8

Technically instance resides in memory and database (physical files) resides on disk. There can be an instance without a database (an example is a started instance right before you create a database). There also can be a database without an instance (example of this is database files residing on disk but instance is not running, or files copied to some other ...


1

I'm guessing that you're talking about Oracle here. See my reply to this question about the difference between a schema and a database in Oracle. See also my comment in reply to Phil Sumner about using tables that aren't in the same schema - yes it's possible, but not an ideal solution. [EDIT in response to OP's comment] Yes, what you have said is exactly ...



Top 50 recent answers are included