Dear There,
I am working on E Learning Management “ELM” system online with php, I have tow problem’s:
-
how can I hide the Password with start.
-
how can I drop list of registered cources for the user when he sign in, see the database:
– phpMyAdmin SQL Dump
– version 3.4.5
– http://www.phpmyadmin.net
– Host: localhost
– Generation Time: May 07, 2012 at 08:21 AM
– Server version: 5.5.16
– PHP Version: 5.3.8
SET SQL_MODE=“NO_AUTO_VALUE_ON_ZERO”;
SET time_zone = “+00:00”;
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT /;
/!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS /;
/!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION /;
/!40101 SET NAMES utf8 */;
–
– Database: workshop
–
– Table structure for table course
CREATE TABLE IF NOT EXISTS course (
ID int(11) NOT NULL AUTO_INCREMENT,
NWorkshop text NOT NULL,
Description longtext NOT NULL,
Sdate int(11) NOT NULL,
Edate int(11) NOT NULL,
Price int(11) NOT NULL,
Lector text NOT NULL,
LInfo longtext NOT NULL,
LPic text NOT NULL,
Video text NOT NULL,
HC text NOT NULL,
Certificate text NOT NULL,
PRIMARY KEY (ID)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=19 ;
–
– Dumping data for table course
INSERT INTO course (ID, NWorkshop, Description, Sdate, Edate, Price, Lector, LInfo, LPic, Video, HC, Certificate) VALUES
(11, ‘fatima ali update’, ‘hiAli\r\nhiALI\r\nhi\r\nhi’, 111, 222, 333, ‘fatima ali last’, ‘last last\r\nlast’, ‘C:xampphtdocsworkshopimagesimagesAdd.ico’, ‘C:xampphtdocsworkshopimagesimagesBack.ico’, ‘C:xampphtdocsworkshopimagesimagesack-icon.png’, ‘C:xampphtdocsworkshophard-copy est4.txt’),
(12, ‘excel2010update’, ‘update\r\ncreate table\r\ndeal with cell\r\ncell formatting\r\noperation\r\n’, 111, 222, 10012, ‘ms.jounupdate’, ‘updateupdateupdateupdateupdate’, ‘C:xampphtdocsworkshopimagesimagesAdd.ico’, ‘C:xampphtdocsworkshopimagesimages915418374.png’, ‘C:xampphtdocsworkshopimagesimagesutton.png’, ‘C:xampphtdocsworkshophard-copy est4.txt’),
(13, ‘Hello world’, ‘C++ lerning’, 33, 44, 800, ‘dr.smith’, ‘DR’, ‘C:xampphtdocsworkshopimagesimagesBack.ico’, ‘C:xampphtdocsworkshopimagesimages915418374.png’, ‘C:xampphtdocsworkshopimagesimages915418374.png’, ‘C:xampphtdocsworkshophard-copy est4.txt’),
(18, ‘If-Statement’, ‘C++’, 1, 30, 200, ‘Smith Broun’, ‘Teacher in university’, ‘C:xampphtdocsworkshopimagesimagesdr-wilson.png.jpg’, ‘C:xampphtdocsworkshopvideoIf-Statement.flv’, ‘C:xampphtdocsworkshophard-copy est3.txt’, ‘C:xampphtdocsworkshophard-copy est1.txt’);
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT /;
/!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS /;
/!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;