Thinkphp Tutorial Implement Tips

Official website: http://www.thinkphp.cn/info/155.html

1. Download full version and wampserver. Extract full version under /wamp/www
2. Follow the instruction, .htaccess is no suffix.
3. Create database, using phpMyAdmin in wampserver, the password for mysql is empty.
the path for database is ” D:\wamp\bin\mysql\mysql5.5.24\data ”
4. Auto fill/verify failed. http://www.5idev.com/p-thinkphp_validate_auto_Invalid.shtml
In my case, I wrong spell class to calss ….
5. When define read() function, still defined in FormAction.class.php
6. Add ” ‘_multi’=>true “, to represent it is multi condition match

7. Connect sqlite database, first move D:\wamp\www\ThinkPHP\Extend\Driver\Db\DbSqlite.class.php to D:\wamp\www\ThinkPHP\Lib\Driver\Db\DbSqlite.class.php
Or the system will report that it did not support Sqlite.
In config.php write:
‘DB_TYPE’ => ‘pdo’,
‘DB_DSN’ => ‘sqlite:’ . DATA_PATH . ‘/test.db’,
‘DB_PREFIX’ => null, // 数据库表前缀
‘DB_CHARSET’ => ‘utf8’, // 数据库编码默认采用utf8
‘DB_FIELDS_CACHE’ => false, // 启用字段缓存

. DATA_PATH . means you should put db in app/runtime/data/
In indexAction.class.php, try
// $model = new Model();

// 创建一个表 applications
// $model->execute(“CREATE TABLE applications ( id INT ( 10 ) NOT NULL PRIMARY KEY , username VARCHAR ( 250 ) NOT NULL )”);

// 插入一条数
// $model->execute(“INSERT INTO applications ( id , username )VALUES ( 1 , ‘PHP init learn’ )”);

// 生成一个demo对应的Model对象
$DemoModel = M (‘applications’);

// 取所有数据
$result = $DemoModel->select();

// 打印数据。
var_dump($result);

Then you will see the db data, all done now.

8. When use display(), we must use $this->display(), or else it will said no function definition. Because it is defined in Action class, and we modified $this->application = $DemoModel->select(); then in index.html, we should use

{$vo.id}–{$vo.name}

9. Using sql to get multitable results:
$DemoModel = M (‘applications’);

$sql = “select a.name as name,a.power as power,d.name as device,a.apptype as apptype from applications as a,devices as d where a.device_id=d.id and a.name=’$AppName’ and a.apptype=’$AppCateID’“;

$app = $DemoModel->query($sql);

10. add excel export: put template.xls in /testproject/file and
add in class:
include ‘PHPExcel.php’;
include ‘PHPExcel/IOFactory.php’;
Put phpExcel folder and phpExcel.php in \wamp\www\ThinkPHP\Extend\Vendor
E.g.: http://www.ithinkphp.com/44.html

11. send info from one function to another, using hidden in html:
<!–App Name:

<INPUT type="hidden” name =”appCateIDOld” value={$dname}>

–>
12. Table in html:
<!–

<!–

–>

–>

Advertisements
This entry was posted in Website design and implement. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

App Name Power Device Type
{$data.id} {$data.name} {$data.power} {$data.device}
ali on Oprofile 0.9.6 ——-…
Ola on Oprofile 0.9.6 ——-…
tran dung on Oprofile 0.9.6 ——-…
Jisu on Oprofile 0.9.6 ——-…
Sachin Agarwalla on Oprofile 0.9.6 ——-…
  • Archives

  • Categories

  • Meta