Done!<\/strong><\/li>\n<\/ol>\n <\/p>\n
Database (Example)<\/h3>\n
There is nothing special here. There a are no extra fancy files required.\u00a0Just normal tables.<\/p>\n
<\/p>\n
-- phpMyAdmin SQL Dump\r\n-- version 3.2.4\r\n-- http:\/\/www.phpmyadmin.net\r\n--\r\n-- Host: localhost\r\n-- Generation Time: Jan 23, 2012 at 04:21 PM\r\n-- Server version: 5.1.44\r\n-- PHP Version: 5.3.1\r\nSET SQL_MODE=\"NO_AUTO_VALUE_ON_ZERO\";\r\n\/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT *\/;\r\n\/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS *\/;\r\n\/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION *\/;\r\n\/*!40101 SET NAMES utf8 *\/;\r\n--\r\n-- Database: `phpfusion`\r\n--\r\n-- --------------------------------------------------------\r\n--\r\n-- Table structure for table `catalogue`\r\n--\r\nCREATE TABLE IF NOT EXISTS `catalogue` (\r\n `id` bigint(20) NOT NULL AUTO_INCREMENT,\r\n `size` int(11) DEFAULT NULL,\r\n `carbrand` varchar(40) CHARACTER SET latin1 COLLATE latin1_general_cs DEFAULT NULL,\r\n `carname` varchar(40) CHARACTER SET latin1 COLLATE latin1_general_cs DEFAULT NULL,\r\n `consumption` float NOT NULL,\r\n `ps` int(11) NOT NULL,\r\n `greenlabel` varchar(6) CHARACTER SET latin1 COLLATE latin1_general_ci DEFAULT NULL,\r\n PRIMARY KEY (`id`)\r\n) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;\r\n--\r\n-- Dumping data for table `catalogue`\r\n--\r\nINSERT INTO `catalogue` (`id`, `size`, `carbrand`, `carname`, `consumption`, `ps`, `greenlabel`) VALUES\r\n(1, 4, 'Volvo', 'Abc', 5.1, 200, 'A'),\r\n(2, 2, 'BMW', 'i5', 10, 250, 'B'),\r\n(3, 6, 'Volkswagen', 'VW Bus', 8.1, 120, 'B'),\r\n(4, 4, 'Bulgati', 'BT2', 10.2, 1000, 'C');\r\n-- --------------------------------------------------------\r\n--\r\n-- Table structure for table `description`\r\n--\r\nCREATE TABLE IF NOT EXISTS `description` (\r\n `id` bigint(20) NOT NULL AUTO_INCREMENT,\r\n `lang` text NOT NULL,\r\n `desc` text CHARACTER SET latin1 COLLATE latin1_general_cs,\r\n PRIMARY KEY (`id`)\r\n) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;\r\n--\r\n-- Dumping data for table `description`\r\n--\r\nINSERT INTO `description` (`id`, `lang`, `desc`) VALUES\r\n(1, 'EN', 'This is your Catalogue description. Here you can search for cars.'),\r\n(2, 'DE', 'Dies ist Ihre Katalog Beschreibung in Deutsch.');<\/pre>\n <\/p>\n
<\/p>\n
Connect to the Database (MySQL)<\/h2>\ninclude_once(\"pf_core.php\")<\/h3>\n
Include the phpfusion core.<\/p>\n
PF_DB_connect()<\/h3>\n
Connect to database.<\/p>\n
PF_DB_select()<\/h3>\n
Selects a database.<\/p>\n
PF_DB_table()<\/h3>\n
Selects a table.<\/p>\n
<\/p>\n
Example code:<\/p>\n
<?\r\ninclude_once<\/strong>(\"pf_core.php\");\r\nPF_DB_connect<\/strong>(\"localhost\", \"<your-database-name>\", \"<your-database-password>\");\r\nPF_DB_select<\/strong>(\"<your-database-name>\");\r\nPF_DB_table<\/strong>(\"catalogue\");<\/pre>\n <\/p>\n
<\/p>\n
Controller<\/h2>\nFile index.php<\/h3>\n
It's a kind of a controller \ud83d\ude09<\/p>\n
<\/p>\n
include(\"user_config.php\");<\/p>\n
[...]<\/p>\n
<script src=\"pf_util.js\" type=\"text\/javascript\"><\/script>
\n<link href=\"pf_style.css\" rel=\"stylesheet\" type=\"text\/css\" \/><\/p>\n
<\/p>\n
[...]<\/p>\n
include($g_USER_headerfile);<\/p>\n
[...]<\/p>\n
include($g_USER_menufile);<\/p>\n
if ( isset($_GET['contact']) ) {
\ninclude($g_USER_contactfile);<\/p>\n
} else if ( isset($_GET['search']) ) {
\ninclude(\"cat_searchresult.php\");<\/p>\n
} else {
\ninclude(\"index_txt.html\");
\n}<\/p>\n
[...]<\/p>\n
include($g_USER_footerfile);<\/p>\n
<\/p>\n
Misc<\/h2>\nPF_setLANG()<\/h3>\n
Set language id.<\/p>\n
PF_query()<\/h3>\n
Query database<\/p>\n
#identifier#<\/h3>\n
Insert values from database<\/p>\n
<\/p>\n
Example Code:<\/p>\n
<? PF_DB_table<\/strong>(\"description\"); ?>\r\n<? PF_setLANG<\/strong>(\"EN\"); ?>\r\n<? echo \"Current Language: \" . ${g_USER_LANG}; ?>\r\n<? PF_query<\/strong>(\"SELECT * FROM description WHERE lang='${g_USER_LANG}'\", NULL); ?>\r\n<!-- show the description out of database -->\r\n<div style=\"background-color:#eeeeee\">#desc#<\/strong><\/div><\/pre>\n <\/p>\n
Output:<\/p>\n
Current Language: EN<\/p>\n
This is your Catalogue description. Here you can search for cars.<\/p>\n
<\/div>\n
NOTE: See also \"description\" table within database.<\/p>\n
<\/p>\n
<\/p>\n
<\/p>\n
Show table results with options<\/h2>\nPF_HTML_checkbox_to_SQL()<\/h3>\n
Create SQL for checkbox<\/p>\n
PF_HTML_radio_option_to_SQL()<\/h3>\n
Create SQL for radio option<\/p>\n
PF_CSV_to_HTML_table()<\/h3>\n
Print html table.<\/p>\n
NOTE: You can connect to an other phpfusion file, here \"Details\", to show detail record. This is down with\u00a0cat_detail.php?id=<\/p>\n
<\/p>\n
Example Code:<\/p>\n
<? PF_DB_table(\"catalogue\"); ?><\/p>\n
<?<\/p>\n
$g_SQL_fields = \"\"
\n. PF_HTML_checkbox_to_SQL(\"greenlabel\")
\n. PF_HTML_radio_option_to_SQL(\"ps\")
\n. PF_HTML_radio_option_to_SQL(\"size\")
\n. PF_HTML_radio_option_to_SQL(\"consumption\")
\n;<\/p>\n
$g_sql = \"SELECT * FROM \"
\n. \" $g_DB_table \"
\n. \" WHERE (1) \"
\n. $g_SQL_fields
\n;<\/p>\n
\/\/PF_debug(true);
\n\/\/PF_debug(false);<\/p>\n
$result = mysql_query($g_sql);<\/p>\n
PF_CSV_to_HTML_table($g_sql, \"Detail\", \"cat_detail.php?id=\");<\/p>\n
<\/p>\n
<\/p>\n
![\"[cml_media_alt](\"https:\/\/www.flagsoft.com\/cmswp\/wp-content\/uploads\/2017\/11\/phpfusion-Screen-Shot-2017-11-14-at-15.11.55.png\")
<\/p>\n
<\/p>\n
![\"[cml_media_alt](\"https:\/\/www.flagsoft.com\/cmswp\/wp-content\/uploads\/2017\/11\/phpfusion-Screen-Shot-2017-11-14-at-15.12.05.png\")
<\/p>\n
![\"[cml_media_alt](\"https:\/\/www.flagsoft.com\/cmswp\/wp-content\/uploads\/2017\/11\/phpfusion-logo-1024-150x150.jpeg\"){kind=logo}
<\/p>\n