$this->Mmodel->useDbConfig = 'test';
//Checking is done by connecting with the database
if (class_exists('DATABASE_CONFIG')){
$dbConfigName1 = 'test'; //<-- PUT YOUR DATABASE CONFIG VARIABLE NAME HERE
$dbConfig1 = new DATABASE_CONFIG();
//pr( $dbConfig1);
if( isset( $dbConfig1->$dbConfigName1)){
//Now check wether the database configuration, its alive!
//pr( $dbConfig1->$dbConfigName1);
$dbTemp1 =& ConnectionManager::getDataSource($dbConfigName1);
if( $dbTemp1->isConnected() == true){
//Means database exist and you can use it
echo "DATABASE CONFIG '$dbConfigName1' EXIST AND MANAGE TO CONNECT";
}
else{
//Database configuration exist, but cannot connect to the database
echo "DATABASE CONFIG '$dbConfigName1' EXIST BUT FAILED TO CONNECT";
}
}
else{
//The database configuration does not exist
echo "HAS NO DATABASE CONFIGURATION WITH NAME '$dbConfigName1'";
}
}
else{
//The database.php file not even exist. How can this be? IMPOSIBIEBERBEL!
echo "CANNOT FIND THE 'database.php' CONFIGURATION FILE";
}
basename( realpath('.'));
 |
| Too many table will automatically create a page pagination |
 |
| The reason, change this and all problem solved! |
//DISABLE "GO BACK TO PREVIOUS HISTORY" IF PRESSING "BACKSPACE"
if (typeof window.event != 'undefined')
document.onkeydown = function()
{
if( event.keyCode == 8){
theEvent = event.srcElement.tagName.toUpperCase();
if( theEvent == 'HTML'){
return false;
}
else if( theEvent == 'INPUT'){
theType = event.srcElement.getAttribute('type').toUpperCase();
//alert(theType);
switch(theType){
case 'TEXT':
return true;
break;
default:
return false;
}
return false;
}
else{
switch( theEvent){
case 'TEXTAREA':
return true;
break;
default:
//alert('Backspace pressed on ' + theEvent + ', return false');
return false;
}
return false;
}
}
}
else
document.onkeypress = function(e)
{
if( e.keyCode == 8){
theEvent = e.target.nodeName.toUpperCase();
if( theEvent == 'HTML'){
return false;
}
else if( theEvent == 'INPUT'){
theType = e.target.getAttribute('type').toUpperCase();
//alert(theType);
switch(theType){
case 'TEXT':
return true;
break;
default:
return false;
}
return false;
}
else{
switch( theEvent){
case 'TEXTAREA':
return true;
break;
default:
//alert('Backspace pressed on ' + theEvent + ', return false');
return false;
}
return false;
}
}
}
| a until z | keycode 97 until 122 |
| A until Z | keycode 65 until 90 |
| 0 until 9 | keycode 48 until 57 |
function whatKeyCodeHaveIType( theEvent)
{
charCode = (theEvent.which) ? theEvent.which : theEvent.keyCode
theTempoElement = document.getElementById('thisiswhatyouhavetpye');
theTempoElement.innerHTML = theTempoElement.innerHTML + ', ' + charCode;
//This is to ignore "ENTER" key. Its usefull to prevent a form from autosubmit if you press enter
return (charCode != 13);
}
//Later in HTML, use these
<input id="whatyouhavetype" style="width: 500px;" onkeypress="return whatKeyCodeHaveIType(event);"/>
<textarea id="thisiswhatyouhavetpye" cols="70" rows="5"></textarea>
var typingTimer;
var doneTypingInterval = 700;
//Detect keystroke and only execute after the user has finish typing
function delayExecute()
{
clearTimeout(typingTimer);
typingTimer = setTimeout(
function(){somethingExecuted('typesomethinghere')},
doneTypingInterval
);
return true;
}
function somethingExecuted( theInputName)
{
alert( "You have type '" + document.getElementById(theInputName).value + "'");
}
//Later in the HTML code, put these
<input onkeypress="return delayExecute();" id="typesomethinghere">
Please note that /var/www is your root for the website
sudo chmod -R 777 '/var/www'
sudo ln -s '/usr/share/phpmyadmin' '/var/www'
sudo chown -R asipo '/var/run/mysqld'
sudo chmod -R 777 '/var/run/mysqld'
sudo a2enmod rewrite
sudo gedit /etc/apache2/sites-enabled/000-default
sudo /etc/init.d/apache2 force-reload
sudo chown -R asipo '/var/www/smellynomore/app/tmp'
sudo chmod -R 777 '/var/www/smellynomore/app/tmp'
error_reporting = E_ALL & ~E_DEPRECATED & ~E_NOTICE
<p><b>Localhost</b></p>If you have been wandering how I put this code into this blog. This is the place http://asipi.blogspot.com/2011/01/write-blog-post-using-tinymce.html
<p>Select folder or file to navigate</p>
<?php
echo "<ul>";
if ($handle = opendir('.')) {
while (false !== ($file = readdir($handle))) {
if ($file != "." && $file != "..") {
echo "<li><a href='$file'>$file<a></li>";
}
}
closedir($handle);
}
echo "</ul>";
?>
sudo gedit /etc/phpmyadmin/config.inc.php
/* Authentication type */
//$cfg['Servers'][$i]['auth_type'] = 'cookie';
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = 'mypasswordissecret';
http://www.fileformat.info/info/unicode/char/b1/index.htmThe link is a plus minus symbol (±). You can search fur further symbol at the top left
input("Account.$aa.name"); ?>
input("Account.$aa.id"); ?>
<input id="tempCount" value="" />
function tempCountert( theTempCountValue)Then you need to change you loop for the account name
{
document.getElementById('tempCount').value = theTempCountValue;
}
input("Account.$aa.name"); ?>
input("Account.$aa.name", array( 'onchange'=>'tempCountert("Account'.$aa.'Id")')); ?>
var updatedColumner = document.getElementById('tempCount').value;
document.getElementById(updatedColumner).value = sValue;
$headerStart = 22; //Start row
foreach( array( 'A', 'B', 'C', 'D', 'E', 'F', 'G', 'H', 'I', 'J', 'K', 'M', 'N', 'O', 'Q', 'R', 'S', 'T') as $alphabet){
$objPHPExcel->getActiveSheet()->getStyle($alphabet.$headerStart)->getAlignment()->setWrapText(true);
$objPHPExcel->getActiveSheet()->mergeCells( $alphabet.$headerStart.":".$alphabet.($headerStart+1));
$objPHPExcel->getActiveSheet()->getStyle($alphabet.$headerStart)->getAlignment()->setVertical( PHPExcel_Style_Alignment::VERTICAL_CENTER);
}
class DATABASE_CONFIG {
var $default = array(
'driver' => 'mysql',
'persistent' => false,
'host' => 'your_host',
'login' => 'your_login_1',
'password' => 'your_password_1',
'database' => 'DB_1',
'prefix' => ''
);
var $general_syst = array(
'driver' => 'mysql',
'persistent' => false,
'host' => 'your_host',
'login' => 'your_login_2',
'password' => 'your_password_2',
'database' => 'DB_2',
'prefix' => ''
);
}
?>
class User extends AppModel {
var $name = 'User';
var $useDbConfig = 'general_syst';
//your code here
//....
}
class Post extends AppModel {
var $name = 'Post';
var $useDbConfig = 'default';
//your code here
//....
}
$this->Post->bla_bla_bla : data will be retrieved/inserted/updated from DB_1
$this->User->bla_bla_bla : data will be retrieved/inserted/updated from DB_2
pr($this->Student->useDbConfig);
$this->Student->useDbConfig = 'general_syst';
$ret = $this->Student->query("SELECT * FROM tbl_lecturer");
FPDF - MutiCell - underline on each line
Draw line under each line when new line is created when using FPDF. Or simply like picture below
Lazy to put picture
If you are using FPDF and want to make a line at the bottom of the text using Muticell, the parameter you send willl be like this
$pdf->MultiCell( 10, 100, "Hello World", 'B')
Where the 'B' represent line at bottom
But if you have a case like $pdf->MultiCell( 10, 100, "Hello \nWorld", 'B') //New line
or $pdf->MultiCell( 10, 100, "Hello World Hello World Hello World Hello World Hello World Hello World ", 'B') //Text too long auto new line
They will look like this
Lazy to put picture
And what you want is to look like this
Lazy to put picture
If you change the text into underline, it also does solve the purpose but it is not underline upon cell. It will be underline upon text
Lazy to put picture
So what left is only a tweak to the FPDF where I will tell you where to modify, which is in the function MultiCell(...) of course
First of all, I'm using FPDF version 1.53 (2004-12-31) where Olivier PLATHEY said "You may use and modify this software as you wish."
So this tweak is legal
Second, this code I write is free you may use and modify what I code as you wish. This is also 'AS IS', if anything happen dont blame me
If got bug, I dont care because with this code I already manage to get what I want
Lets start
Step 1
Go to the function MultiCell($w,$h,$txt,$border=0,$align='J',$fill=0)
Step 2
Inside there, you will see function Cell(...) is called 4 times and what you need to do is add additional code at the bottom of cell number 1 and 3
If I was correct
Cell no 1 is at line 755
Cell no 3 is at line 794
Step 3
Make the code to look like this. Make it like that at the 1st and 3rd cell
$this->Cell($w,$h,substr($s,$j,$i-$j),$b,2,$align,$fill);
//Hassif. If you want the Multicell to have a bottom line at each text. use this
//Common border 'B' only bottom line at the end of text. Not at each line of text
if( strpos($border,'Z')){
$this->Line( $this->x, $this->y, $w+$this->x, $this->y);
}
Step 4
It done. So to use this feature you need to put $pdf->MultiCell( 10, 100, "Hello \nWorld", 'BZ') which is additional 'Z' character
Im kind of busy right now to explain further, so later...
SELECT email,
COUNT(email) AS NumOccurrences
FROM users
GROUP BY email
HAVING ( COUNT(email) > 1 )
SELECT email
FROM users
GROUP BY email
HAVING ( COUNT(email) = 1 )