rpicms

A CMS for the Raspberry Pi
git clone git://archive.git.mtrnord.blog/RpicmsTeam/rpicms.git
Log | Files | Refs | README | LICENSE

commit 7edb0287448c5cf05b21f622d1f0d54f2a379c36
parent 89207e66521ff1a7ffeb28cf496a1a7032f07c1e
Author: MTRNord <mtrnord1@gmail.com>
Date:   Tue, 19 Aug 2014 18:12:12 +0200

auto commit

Diffstat:
Mcore/inc/db_connect.inc.php | 15+++++++++++++++
Acore/inc/db_connect.inc.php.original | 10++++++++++
Minstall/add_tables.php | 5+++--
3 files changed, 28 insertions(+), 2 deletions(-)

diff --git a/core/inc/db_connect.inc.php b/core/inc/db_connect.inc.php @@ -0,0 +1,14 @@ +<?php + +$db_servername = 'localhost'; + + +$db_username = 'root'; + + +$db_password = '1199Mtr3#'; + + +$db_name = 'test'; + +$connection = mysqli_connect($db_servername, $db_username, $db_password, $db_name) or die ("Verbindung war nicht m&ouml;glich"); +\ No newline at end of file diff --git a/core/inc/db_connect.inc.php.original b/core/inc/db_connect.inc.php.original @@ -0,0 +1,10 @@ +<?php + +$db_servername = "localhost"; +$db_username = "root"; +$db_password = "1199Mtr3#"; +$db_name = "blog"; + +$connection = mysql_connect($db_servername, $db_username, $db_password) or die ("<p>Verbindung war nicht m&ouml;glich</p>"); +mysql_select_db($db_name) or die ("<p>Die Datenbank ist nicht vorhanden</p>"); + diff --git a/install/add_tables.php b/install/add_tables.php @@ -14,8 +14,9 @@ `id` INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY , `text` TEXT NOT NULL , `title` TEXT NOT NULL , - `name` TEXT NOT NULL , - `time` DATETIME NOT NULL + `author` TEXT NOT NULL , + `date` DATETIME NOT NULL , + `categrory` TEXT NOT NULL ) ENGINE = MYISAM ; "; $result = mysqli_query($connection, $sql)