PHP connects to the database and click the button to query the data. if data is not clicked, the button turns red and no data remains red. -PHP source code

PHP connects to the database and click the button to query the data. if data is not clicked, the button turns red and no data remains red. Code

 "; Echo""; $ Mysql_server_name =" localhost "; // Database Server Name $ mysql_username =" root "; // database connection username $ mysql_password =" 123456 "; // database connection password $ mysql_database = "td_oa"; // database name // connect to the database $ conn = mysql_connect ($ mysql_server_name, $ mysql_username, $ mysql_password ); // solve the garbled mysql_query ("set names 'utf8'"); mysql_query ("set character set UTF8"); mysql_query ("SET CHARACTER_SET_RESULTS = utf8 '"); // SQL statement for extracting information from the table $ strsql = "select. field4 as 'vehicle no. ',. field8 as 'Task number',. field5 as 'date of loading ',. field6 as 'Vendor name',. field7 as 'purchase price' from 'CRM _ store' a left join 'CRM _ order' B on. field4 = B. field2 and. field8 = B. field16where (B. field8 = 0 or B. field8 is null) and DATE_ADD (. field5, INTERVAL 4 day)