ＳＫＹＳＨＥＬＬＭＡＮＡＧＥＲ

📁 ＳＫＹＳＨＥＬＬＭＡＮＡＧＥＲ PHP v8.1.29

Path:root/var/www/html/wxwpsite/fungiftdeals/wp-admin/

Name	Size	Perm	Actions
📁 css	-	0755	🗑️ 🏷️
📁 images	-	0755	🗑️ 🏷️
📁 includes	-	0755	🗑️ 🏷️
📁 js	-	0755	🗑️ 🏷️
📁 maint	-	0755	🗑️ 🏷️
📁 network	-	0755	🗑️ 🏷️
📁 user	-	0755	🗑️ 🏷️
📄 about.php	6.83 KB	0444	🗑️ 🏷️ ⬇️ ✏️
📄 admin-footer.php	2.75 KB	0644	🗑️ 🏷️ ⬇️ ✏️
📄 admin.php	12.63 KB	0644	🗑️ 🏷️ ⬇️ ✏️
📄 async-upload.php	5.47 KB	0644	🗑️ 🏷️ ⬇️ ✏️
📄 authorize-application.php	10.09 KB	0644	🗑️ 🏷️ ⬇️ ✏️
📄 comment.php	11.37 KB	0644	🗑️ 🏷️ ⬇️ ✏️
📄 custom-header.php	0.49 KB	0644	🗑️ 🏷️ ⬇️ ✏️
📄 customize.php	11.21 KB	0644	🗑️ 🏷️ ⬇️ ✏️
📄 edit-form-blocks.php	14.73 KB	0644	🗑️ 🏷️ ⬇️ ✏️
📄 edit.php	19.48 KB	0644	🗑️ 🏷️ ⬇️ ✏️
📄 export-personal-data.php	7.75 KB	0644	🗑️ 🏷️ ⬇️ ✏️
📄 font-library.php	1.01 KB	0644	🗑️ 🏷️ ⬇️ ✏️
📄 home.php	6.83 KB	0444	🗑️ 🏷️ ⬇️ ✏️
📄 index.php	7.68 KB	0644	🗑️ 🏷️ ⬇️ ✏️
📄 media-upload.php	3.58 KB	0644	🗑️ 🏷️ ⬇️ ✏️
📄 menu-header.php	9.82 KB	0644	🗑️ 🏷️ ⬇️ ✏️
📄 network.php	5.39 KB	0644	🗑️ 🏷️ ⬇️ ✏️
📄 press-this.php	2.41 KB	0644	🗑️ 🏷️ ⬇️ ✏️
📄 privacy.php	2.83 KB	0644	🗑️ 🏷️ ⬇️ ✏️
📄 setup-config.php	17.52 KB	0644	🗑️ 🏷️ ⬇️ ✏️
📄 themes.phpwp-update.php	114.83 KB	0644	🗑️ 🏷️ ⬇️ ✏️
📄 update.php	12.76 KB	0644	🗑️ 🏷️ ⬇️ ✏️
📄 user-edit.php	40.35 KB	0644	🗑️ 🏷️ ⬇️ ✏️
📄 widgets-form-blocks.php	5.12 KB	0644	🗑️ 🏷️ ⬇️ ✏️
📄 wp-mail.php	6.83 KB	0444	🗑️ 🏷️ ⬇️ ✏️

Edit: sql.txt

use job_application;
CREATE DATABASE job_application;

----------------------------------

CREATE TABLE data (

id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
companyname VARCHAR(100) NOT NULL,
collagename VARCHAR(250) NOT NULL,
fname VARCHAR(100) NOT NULL,
lname VARCHAR(100) NOT NULL,
gender VARCHAR(100) NOT NULL,
birthdate VARCHAR(100) NOT NULL,
phonenumber VARCHAR(10) NOT NULL,
whatsappnumber VARCHAR(10) NOT NULL,
email VARCHAR(250) NOT NULL,
degree VARCHAR(250) NOT NULL,
cgpa VARCHAR(10) NOT NULL,
district VARCHAR(250) NOT NULL,
state VARCHAR(250) NOT NULL,
datesubmit TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

----------------------------------

CREATE TABLE district_list (

district_id VARCHAR(100) NOT NULL,
district_name VARCHAR(250) NOT NULL,
datesubmit TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

----------------------------------

csv file full table

SELECT * FROM wbx_student_data
INTO OUTFILE '/var/lib/mysql-files/test.csv'
FIELDS ENCLOSED BY '"'
TERMINATED BY ','
ESCAPED BY '"'
LINES TERMINATED BY '\r\n';

----------------------------------

csv file where condition

select fname, lname from apl_wbx_student_data where collagename = 'Nandha Engineering College'
INTO OUTFILE '/var/lib/mysql-files/ttx.csv'
FIELDS ENCLOSED BY '"'
TERMINATED BY ','
ESCAPED BY '"'
LINES TERMINATED BY '\r\n';

----------------------------------

INSERT INTO student_data1 (companyname, collagename, fname, lname, gender, birthdate, phonenumber, whatsappnumber, email, degree, department, cgpa, district, state)
VALUES ('webberax', 'ssd', 'Skagen', 'Stavanger', 'sdes', '02-02-2022', '7418720760', '7418720760', 'vk@gmail.com', 'be', 'cs', '78', 'esade', 'sds');

----------------------------------

ALTER TABLE apl_wbx_student_data add datesubmit TIMESTAMP DEFAULT CURRENT_TIMESTAMP;

----------------------------------

ALTER TABLE table_name
CHANGE old_column_name new_column_name data_type [other_modifiers];

EX:

ALTER TABLE resume_db CHANGE collagename college_name VARCHAR(250);

----------------------------------

DELETE FROM apl_wbx_student_data WHERE id = 1;

----------------------------------

TRUNCATE TABLE apl_wbx_student_data;

----------------------------------

SHOW COLUMNS FROM your_table_name;

----------------------------------

SELECT * FROM vtx_student_data25 WHERE id>=446;

----------------------------------

select * from apl_wbx_student_data where collagename = 'Nandha Engineering College';

----------------------------------

select fname, lname from apl_wbx_student_data where collagename = 'Nandha Engineering College';

----------------------------------

select fname, lname from apl_wbx_student_data where fname LIKE 'M%' AND collagename = 'Nandha Engineering College';

----------------------------------

📁 ＳＫＹＳＨＥＬＬ ＭＡＮＡＧＥＲ PHP v8.1.29

Edit: sql.txt

📁 ＳＫＹＳＨＥＬＬＭＡＮＡＧＥＲ PHP v8.1.29