PHP/MySQL Tutorial by Graeme Merrall

Unless you've been living on Mars for the last six to eight months, you've heard of open source software (OSS). This movement has got so much momentum that even the big boys are taking notice. Companies like Oracle, Informix, and a host of others are releasing their flagship database products for that poster child of the OSS movement, Linux. Having a massively complex RDBMS (relational database management system) is all well and good if you know what to do with it. But perhaps you are just getting into the world of databases. You've read Jay's article and you want to put up your own data-driven Web site. But you find you don't have the resources or desire for an ASP server or some pricey database. You want something free, and you want it to work with Unix. Enter PHP and MySQL. These two make up what must be the best combination for data-driven Web sites on the planet. You needn't take my word for it. An unofficial Netcraft survey shows that PHP usage has jumped from 7,500 hosts in June 1998 to 410,000 in March 1999. That's not bad. The combination was also awarded Database of the Year at Webcon98, where it received a lovely tiara. MySQL is a small, compact database server ideal for small - and not so small - applications. In addition to supporting standard SQL (ANSI), it compiles on a number of platforms and has multithreading abilities on Unix servers, which make for great performance. For non-Unix people, MySQL can be run as a service on Windows NT and as a normal process in Windows 95/98 machines. PHP is a server-side...

Website: www.robertobandini.it | Filesize: 175kb
No of Page(s): 9
download

Database Programming (JDBC) Slide Tutorial

Database Programming (JDBC) Lecture 5 2 Outline •Jav DB Conectivity (JDBC) overview •JDBC API Reading: Embeded SQL •Direct SQL (= ad-hoc SQL) is rarely used •In practie: SQL is embeded in some aliction code –user interaction, devices, programing logic •SQL code is embeded into a host language using special syntax 4 JDBC (Jav DB Conectivity) Java application { ... "SELECT ... FROM ... WHERE" ... } DBMS 5 xDBC •JDBC: standard for Jav language •OB: Open DataBase Conectivity –Language bindings for /+ 6 JDBC in Practise Java client code JDBC Database server (Postgres, Oracle, MySQL, SQL Server) SQL statements 7 JDBC Drivers Jav aplication JDBC- Driver manger Native Protcol driver JDBC- Net-driver Native API-driver JDBC-ODBC bridge DB Client libray DB- Midleware ODBC DB Client libray JDBC-API 8 Runing a JDBC Aplication Phase Task Relvant jav.sql clases Initialisation Procesing Termination Load river Create conection Generate SQL statements Proces result dat Terminate conection Relase dat structures DriverManger Conectio Statement ResultSet etc. Conection Statemet etc. 9 A Simple JDBC Aplication loadDriver getConection createStatement excute(SQL) Result handling More results ? closeStatement closeConection no yes import jav.sql.*; public las jdbctest { public static void main(String args[]){ try{ DriverManger.egisterDriver(new com.ysql.jdbc.Driver( ); Clas.forName(“com.mysql.jdbc.Driver”) onection con = DriverManger.getConection ("jdbc:mysql:/lsir-cis-pc1:306/is01", user", "paswd"); Statement stt = con.createStatement(); ResultSet rs = stmt.excuteQuery (”SELCT nae, number FROM pcmtable WHER number < 2"); while(rs.next() System.out.printl(rs.getString(1) + " ( + rs.getInt(2) + ")); stmt.close() con.close(); } catch(Exception e){ System.er.printl(e); } 10 Loading of Driver •Create an istance of the driver •Register driver in the driver manger •Explicit loading Class.forName(“com.mysql.jdbc.Driver”) •Sevral drivers can be loade and rgister 1 Example: Oracle and JDBC Class.forName("oracle.jdbc.driver.OracleDriver ”) Connection con = DriverManager.getConnection( "jdbc:oracle:thin:@dbaprod1:1544:SHR1_PRD", username, passwd);...

Website: lsirwww.epfl.ch | Filesize: 387kb
No of Page(s): 15
Download: http://lsirwww.epfl.ch/courses/iis/2009ss/slides/slides-5-JDBC.pdf

Developing Database Applications Using MySQL Connector/C++

This tutorial will show you the essential steps to build and install MySQL Connector/C++ driver, with simple examples to connect, insert, and retrieve data from a MySQL database. Because the focus is on database connectivity from a C++ application, this document assumes that some kind of MySQL database is already up and accessible from the client machine.

Application developers who are new to MySQL Connector/C++ but not to C++ programming and MySQL database, are the target audience of this tutorial. Listed below are the tools and technologies used to compile, build and run the examples in this tutorial. Database MySQL Server 5.1.24-rc C++ Driver MySQL Connector/C++ 1.0.5 MySQL Client Library MySQL Connector/C 6.0 Compiler Sun Studio 12 C++ compiler Make CMake 2.6.3 Operating System OpenSolaris 2008.11 32-bit CPU / ISA Intel Centrino / x86 Hardware Toshiba Tecra M2 Laptop Contents • MySQL C++ Driver Based on JDBC 4.0 Specification • Installing MySQL Connector/C++ • Runtime Dependencies • IDE for Developing C++ Applications • Create the City Table in the test Database for Code Examples • Testing the MySQL Database Connectivity With the Connector/C++ • Using Prepared Statements • Using Transactions • Accessing Result Set Metadata • Accessing Database Metadata • Accessing Parameter Metadata from a PreparedStatement Object • Catching Exceptions • Debug Tracing with MySQL Connector/C++ • For More Information • About the author • Appendix I: Installing MySQL Connector/C++ from Source Copyright © 2009 MySQL • Reprint by permission only 2 MySQL C++ Driver Based on JDBC 4.0 Specification MySQL Connector/C++ is one of the latest...

Website: docs.huihoo.com | Filesize: 320kb
No of Page(s): 36
Download: http://docs.huihoo.com/mysql/mysql-apps-using-connector-and-cpp.pdf

Linux to Solaris Administrators Guide

The aim of the Linux to Solaris Administrator Guide is to give Linux administrators the information and guidance they'll need to make a successful transition to using Solaris 10. The Linux to Solaris Administrators Guide is not intended for a first time system administrator. The guide assumes a certain amount of background administering a Linux system.
While similar in many respects there are still quite a few differences between a Linux and Solaris machine including commands, file systems and heritage.
These differences can be as simple as a renamed configuration file to the more complicated alternate meanings for command line arguments.
This chapter presents an overview of some of the differences between Linux and Solaris.
Topics Covered: Architectural Similarities and Differences, File System Organization, Locations of Common used Commands, Location of Configuration Files, Location of Log Files, Script Migration, Architectural Similarities and Di?erences
While similar in many respects there are fundamental differences between the Solaris and Linux operating environments.
Throughout the development of Solaris the focus has been on compatibility. Compatibility with previous releases (binaries compiled on Solaris 8 will run on Solaris 10) and compatibility with de jure standards such as POSIX. Linux has had the freedom to establish new de facto standards (such as extended command line syntax, with a strong consistency among commands). However, judicious use of the included GNU utilities, the proper command line settings, downloads of additional utilities, and some acquired knowledge such as this guide and sites such as the Rosetta Stone1 will mitigate most differences.
Many of the system similarities can be attributed to the implementation of different system standards. These standards make it a lot easier to move applications between Operating Systems. Solaris conforms to the POSIX, SVID and XPG standards.
Although many commands may have the same name, the implementation and command line options may have changed. The man pages should be consulted to verify the functionality of commands.

download: http://www.sun.com/software/solaris/sysadmin_guide.pdf

The Linux System Administrator's Guide

The Linux System Administrator's Guide, describes the system administration aspects of using Linux. It is intended for people who know next to nothing about system administration (those saying "what is it?''), but who have already mastered at least the basics of normal usage. This manual doesn't tell you how to install Linux; that is described in the Installation and Getting Started document. See below for more information about Linux manuals.
System administration covers all the things that you have to do to keep a computer system in usable order. It includes things like backing up files (and restoring them if necessary), installing new programs, creating accounts for users (and deleting them when no longer needed), making certain that the filesystem is not corrupted, and so on. If a computer were, say, a house, system administration would be called maintenance, and would include cleaning, fixing broken windows, and other such things.
The structure of this manual is such that many of the chapters should be usable independently, so if you need information about backups, for example, you can read just that chapter. However, this manual is first and foremost a tutorial and can be read sequentially or as a whole.
This manual is not intended to be used completely independently. Plenty of the rest of the Linux documentation is also important for system administrators. After all, a system administrator is just a user with special privileges and duties. Very useful resources are the manual pages, which should always be consulted when you are not familiar with a command. If you do not know which command you need, then the apropos command can be used. Consult its manual page for more details.
While this manual is targeted at Linux, a general principle has been that it should be useful with other UNIX based operating systems as well. Unfortunately, since there is so much variance between different versions of UNIX in general, and in system administration in particular, there is little hope to cover all variants. Even covering all possibilities for Linux is difficult, due to the nature of its development.
There is no one official Linux distribution, so different people have different setups and many people have a setup they have built up themselves. This book is not targeted at any one distribution. Distributions can and do vary considerably. When possible, differences have been noted and alternatives given. For a list of distributions and some of their differences see http://en.wikipedia.org/wiki/Comparison_of_Linux_distributions.
In trying to describe how things work, rather than just listing ``five easy steps'' for each task, there is much information here that is not necessary for everyone, but those parts are marked as such and can be skipped if you use a preconfigured system. Reading everything will, naturally, increase your understanding of the system and should make using and administering it more productive.

download: http://www.ibiblio.org/pub/Linux/docs/LDP/system-admin-guide/sag.pdf

Ubuntu Tips & Tricks

When you install a dual-boot of Ubuntu, one of the frustrating things that you'll immediately notice is that Ubuntu is now set as the default operating system in the Grub loader. There's an easy way to switch back to using Windows as the default.
To make this change, you'll first have to boot into Ubuntu, and then run the following command:
sudo gedit /boot/grub/menu.lst
Find this section of the file:
## default num
# Set the default entry to the entry number NUM. Numbering starts from 0, and
# the entry number 0 is the default if the command is not used.
# You can specify 'saved' instead of a number. In this case, the default entry
# is the entry saved with the command 'savedefault'.
# WARNING: If you are using dmraid do not change this entry to 'saved' or your
# array will desync and will not let you boot your system.
default 0
The important line is the last one. You will need to change that number 0 to match the Windows boot section. Typically it's always going to be 4 on a default dual-boot configuration. Change this value to 4, and then save and reboot your machine. You should go into Windows instead of Ubuntu automatically.
Note: The blocks at the bottom of the file match the items in the menu. You can change this value to match whichever item you want as default, just remember that numbering starts at 0.

download

Getting Start with Crossloop

This guide is intended to assist you with downloading, installing, and running the CrossLoop Software Application.
CrossLoop is a free secure screen sharing utility designed for people of all technical skill levels.
CrossLoop enables non-technical users to get connected from anywhere on the Internet in seconds without changing any firewall or router settings.
With CrossLoop, people can help their contacts remotely as if they were working side by side. Popular uses for CrossLoop range from technical assistance to trouble- shooting to software and application training, such as how to set up a blog or create videos online.
TROUBLESHOOTING INSTALLATION PROBLEMS
Most installation problems have to do with the Windows operating system or security software being aggressively vigilant and blocking the installation process.
In these cases you should select whichever option removes the blocking action (typically, a button called “Ignore”, “Continue”, “Yes”, “Grant”, “Run”, or “Allow”.)

download