Python and php database connection problems
In a few days of fixing the final project, it involves some handling of connection problems between python and php databases.There are also database-related systems. here is a small summary.
1. python
A friend needs to use sugarcrm's php to read Mssqlserver's Chinese documents. because the original documents are Access databases, it is not convenient to export data to mysql. However, after importing to sqlserver 2005, it was found that its
Search for mssql. so or dll in Win first, failed! It may be possible to compile the. so file, but how to compile it is the same thing, so it is not a simple php. ini
Search for mssql. so or dll in Win first, failed! It may be possible to compile
There are quite a few options for compiling PHP under Linux, so make up your mind today./configure--help > Help.txt exports a list of compilation options and translates them for later review.
SAPI modules (option for PHP SAPI interface module):
For first Contact
Pod extensions are added in PHP5, which provides the PHP PDO class to access the database, using the same method name for different databases and resolving the problem of a database connection not being unified.
Target of the PHP
What is PDO?
The POD (PHP Data Object) extension is added in PHP5, and PHP6 connects the database with PDO, and all non-PDO extensions will be removed from the extension in PHP6. The extension provides PHP built-in class PDO to access the database,
This article mainly introduces the description of common PHP compilation parameters in Chinese. This article describes the function of PHP compilation parameters in Chinese. For more information, see
This article mainly introduces the description of
If you need to access the Microsoft SQL Server or Sybase Database in Linux, the following software packages are recommended. SybaseCommon http://download.sybase.com/pub/ase1192_linux/sybase-common-11.9.2-3.i386.rpm SybaseOpenClient
Link between php and SQL server
$ Conn = dbo. mssql_connect ("61.164.111.245", "yon", "123456 ");$ Dbname = @ mssql_select_db ("yong1", $ conn);?>This Link Code also prompts error mssql_query (): 3 is not a valid ms SQL-Link resource in F:
PHP 5.4.17 is released. Last RC version was 5.4.16 of. About 20 bugs and several security vulnerabilities were fixed. The official version 5.5.0 has been released. But 5.4 has not stopped the update. 5.3 not synchronously updated to 5.3.27 I believe
some of the Configure parameters when compiling PHP./Configure–prefix=/usr/local/php PHP installation directory –with-apxs2=/usr/local/apache/bin/Apxs–with-config-file-PATH=/USR/LOCAL/PHP/ETC specifies PHP.INI location
PHP has a lot of configuration parameters, here only to do some common parameters of the description.
First download PHP source package http://www.php.net
Of course, before the installation, you need to install a lot of dependent packages, or
1. What is PDO?PDO (PHP data Object) is a lightweight, interface-compatible PHP data connection extension, is a PHP official PECL library, released with PHP 5.1, requires PHP 5 object-oriented support, and therefore not available on earlier versions.
Summary of this section Basic EnvironmentIpython FoundationObjectiveThis is the first blog in 18, because boss for some of my job expectations, need to start doing some data analysis work, so began to write this series of blog. The main content of
Installing httpd-2.4dependent on apr-1.4+, apr-util-1.4+, [Apr-iconv]Apr:apache portable runtime to solve cross-platform implementationsCentOS 6: Default: apr-1.3.9, apr-util-1.3.9To prepare the development package before installation:Development
System version: CentOS 6.5 software version: libmcrypt-2.5.8 mysql-5.6.26 nginx-1.8.0 pcre-8.37 php-5.6.13LNMP platform components: Linux, Nginx, MySQl, PHPNginx is a high-performance, lightweight Web services software, with high stability, low
./configure Compilation parameters–prefix=/application/php5.3.27 Specifies that the installation path for PHP is /application/php5.3.27–with-mysql=/application/mysql/Need to specifymysql installation path , install Php required mysql related
--prefix=/usr/local/php//Specify the PHP installation directoryThe--WITH-APXS2=/USR/LOCAL/APACHE/BIN/APXS//consolidation Apache,apxs function is to use the loadmodule instruction in Mod_so to load the specified module to Apache, requiring Apache to
Interpretation of common parameters for compiling PHP
Copy Code code as follows:
--prefix=/usr/local/php #指定 PHP installation directory
--with-apxs2=/usr/local/apache/bin/apxs #整合apache, the APXS function is to use the loadmodule
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.