Manage Table PT_localization

CREATE TABLE

PRACTICE TRAINING = YES
$sql_create = "CREATE TABLE " . $tablename  . " (
  id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
  stringid   VARCHAR(30) NOT NULL,
  module     VARCHAR(10) NOT NULL,
  customer   VARCHAR(30) NOT NULL,
  description_en text,
  description_es text,
  description_fr text,
  description_ca text,
  reg_date   TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
 )";
          
Create Table PT_localization

Database Credentials

  • DATABASE
    ALPHA
  • PHP INCLUDE for connection
    '/includes/sql/DB_localization-v3.php';
  • PHP function
    get_string_data($Module,$String,$Lang) ;
  • Display string "Welcome"
    Welcome = string [ES][ALL][Welcome]

 

   // --------------------------------------
   // CREDENTIALS FOR DATABASE ALPHA
   // --------------------------------------
   $credentials     = 'alpha' ;
   $SS_DB_NAME      = 'sc1lesy5955_template' ;
   $SS_DB_USER      = 'sc1lesy5955_takeat' ;
   $SS_DB_PASSWORD  = 'yL0x17ztD&#^' ;
   $SS_DB_HOST      = 'localhost';