Sae上使用一轻量ORM库 idiorm的问题。
本人小菜,发现一个好用的轻量orm库idiorm,纯粹是觉得方便加上怕自己写的东西会有安全性问题所以想用这个。
他的文档如下:http://idiorm.readthedocs.org/en/latest/index.html
Github中地址: https://github.com/j4mie/idiorm
Index.php代码如下:
<?phprequire_once "ORM.php";ORM::configure('mysql:host=localhost;dbname=mydemotest');ORM::configure('username', 'root');ORM::configure('password', '123456');//初始化ORM::configure('return_result_sets', true);//$account = ORM::for_table('account')->create();$account->id = 11;$account->account = 1236;$account->save();
分别用的就是其文档上的:
以上这段代码在我本地的xampp上可以运行
但是放到sae上就有问题
我的sae下首先自己创建了一个数据库,表名是account
然后在我的目录下游这两个文件,(ORM就是那个idiorm库)
对应index.php中的代码是:
<?phprequire_once 'ORM.php';ORM::configure('mysql:host=w.rdc.sae.sina.com.cn:3307;dbname=SAE_MYSQL_DB');ORM::configure('username', 'SAE_MYSQL_USER');ORM::configure('password', 'SAE_MYSQL_PASS');$account = ORM::for_table('account')->create();$account->id = 11;$account->account = 1236;$account->save();?>
然后就出现以下问题:
所以就想请教下各位前辈,自己也百度了很久,实在本人知识水平有限。
谢谢
回复讨论(解决方案)
SAE_MYSQL_XXXX 是常量!
ORM::configure('mysql:host=w.rdc.sae.sina.com.cn:3307;dbname=' . SAE_MYSQL_DB);ORM::configure('username', SAE_MYSQL_USER);ORM::configure('password', SAE_MYSQL_PASS);
另外,主机名、端口名也应用它提供的常量 SAE_MYSQL_HOST_M、SAE_MYSQL_PORT

Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

AI Hentai Generator
Generate AI Hentai for free.

Hot Article

Hot Tools

Notepad++7.3.1
Easy-to-use and free code editor

SublimeText3 Chinese version
Chinese version, very easy to use

Zend Studio 13.0.1
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

Hot Topics

TortoiseORM is an asynchronous ORM framework developed based on the Python language and can be used to manage relational databases in Python asynchronous applications. This article will introduce how to use the TortoiseORM framework to create, read, update and delete data. You will also learn how to perform simple and complex queries from a relational database. Preparation Before starting this tutorial, you need to install Python (Python3.6+ is recommended) and install TortoiseOR.

Database operations in PHP are simplified using ORM, which maps objects into relational databases. EloquentORM in Laravel allows you to interact with the database using object-oriented syntax. You can use ORM by defining model classes, using Eloquent methods, or building a blog system in practice.

With the development of the Internet, the development of Web applications has gradually been widely used. One of the most important languages is PHP. However, data management and processing has always been a problem faced by developers. For this reason, ORM has become a good choice for data processing. What is an ORM? ORM stands for Object-Relational Mapping. It is a method of converting objects in object-oriented programming language programs by using metadata that describes the mapping between objects and databases.

The HibernateORM framework has the following shortcomings: 1. Large memory consumption because it caches query results and entity objects; 2. High complexity, requiring in-depth understanding of the architecture and configuration; 3. Delayed loading delays, leading to unexpected delays; 4. Performance bottlenecks, in May occur when a large number of entities are loaded or updated at the same time; 5. Vendor-specific implementation, resulting in differences between databases.

Hibernate polymorphic mapping can map inherited classes to the database and provides the following mapping types: joined-subclass: Create a separate table for the subclass, including all columns of the parent class. table-per-class: Create a separate table for subclasses, containing only subclass-specific columns. union-subclass: similar to joined-subclass, but the parent class table unions all subclass columns.

Answer: ORM (Object Relational Mapping) and DAL (Database Abstraction Layer) improve code readability by abstracting the underlying database implementation details. Detailed description: ORM uses an object-oriented approach to interact with the database, bringing the code closer to the application logic. DAL provides a common interface that is independent of database vendors, simplifying interaction with different databases. Using ORM and DAL can reduce the use of SQL statements and make the code more concise. In practical cases, ORM and DAL can simplify the query of product information and improve code readability.

Hibernate is a JavaORM framework for mapping between Java objects and relational databases. Its ORM mechanism includes the following steps: Annotation/Configuration: The object class is marked with annotations or XML files, specifying its mapped database tables and columns. Session factory: manages the connection between Hibernate and the database. Session: Represents an active connection to the database and is used to perform query and update operations. Persistence: Save data to the database through the save() or update() method. Query: Use Criteria and HQL to define complex queries to retrieve data.

With the continuous development of web applications, corresponding web development frameworks are also emerging. Among them, the Phalcon framework is favored by more and more developers because of its high performance and flexibility. Phalcon framework provides many useful components, among which ORM (Object Relational Mapping) is considered one of the most important. This article will introduce how to use ORM in the Phalcon framework and some practical application examples. What is ORM First, we need to understand what ORM is. ORM is Object-Rel
