#StackBounty: #phpmyadmin phpMyAdmin Localhost issues :- #1932 – Table 'ajax_simple.city' doesn't exist in engine

Bounty: 50

1.) I have get one issue. when i click the MySQL start button click but not start.
Its first issue solve following this link.

https://stackoverflow.com/questions/15169861/xampp-error-mysql-shutdown-unexpectedly

2.) But i have second problem get open the phpmyadmin and click any table showing this error #1932 - Table 'ajax_simple.city' doesn't exist in engine

enter image description here

How to solve this error.

Please help me because in phpmyadmin many database store.

THANKS.


Get this bounty!!!

#StackBounty: #phpmyadmin phpMyAdmin Localhost issues :- #1932 – Table 'ajax_simple.city' doesn't exist in engine

Bounty: 50

1.) I have get one issue. when i click the MySQL start button click but not start.
Its first issue solve following this link.

https://stackoverflow.com/questions/15169861/xampp-error-mysql-shutdown-unexpectedly

2.) But i have second problem get open the phpmyadmin and click any table showing this error #1932 - Table 'ajax_simple.city' doesn't exist in engine

enter image description here

How to solve this error.

Please help me because in phpmyadmin many database store.

THANKS.


Get this bounty!!!

#StackBounty: #phpmyadmin phpMyAdmin Localhost issues :- #1932 – Table 'ajax_simple.city' doesn't exist in engine

Bounty: 50

1.) I have get one issue. when i click the MySQL start button click but not start.
Its first issue solve following this link.

https://stackoverflow.com/questions/15169861/xampp-error-mysql-shutdown-unexpectedly

2.) But i have second problem get open the phpmyadmin and click any table showing this error #1932 - Table 'ajax_simple.city' doesn't exist in engine

enter image description here

How to solve this error.

Please help me because in phpmyadmin many database store.

THANKS.


Get this bounty!!!

#StackBounty: #phpmyadmin phpMyAdmin Localhost issues :- #1932 – Table 'ajax_simple.city' doesn't exist in engine

Bounty: 50

1.) I have get one issue. when i click the MySQL start button click but not start.
Its first issue solve following this link.

https://stackoverflow.com/questions/15169861/xampp-error-mysql-shutdown-unexpectedly

2.) But i have second problem get open the phpmyadmin and click any table showing this error #1932 - Table 'ajax_simple.city' doesn't exist in engine

enter image description here

How to solve this error.

Please help me because in phpmyadmin many database store.

THANKS.


Get this bounty!!!

#StackBounty: #phpmyadmin phpMyAdmin Localhost issues :- #1932 – Table 'ajax_simple.city' doesn't exist in engine

Bounty: 50

1.) I have get one issue. when i click the MySQL start button click but not start.
Its first issue solve following this link.

https://stackoverflow.com/questions/15169861/xampp-error-mysql-shutdown-unexpectedly

2.) But i have second problem get open the phpmyadmin and click any table showing this error #1932 - Table 'ajax_simple.city' doesn't exist in engine

enter image description here

How to solve this error.

Please help me because in phpmyadmin many database store.

THANKS.


Get this bounty!!!

#StackBounty: #mysql #phpmyadmin #excel Multiple queries in phpmyadmin – Distance using coordinates, Slope, Intercept, Angle, and few m…

Bounty: 50

I having around 500 excel sheets in .csv format with data captured for my experiment having following columns in place.

enter image description here

Now I need to calculate the following parameters using this data. I have done these in excel, however doing this repeatedly for each excel so many times is difficult, so I want to write an SQL query in PhpmyAdmin will help some time.

  1. Last charecter typed – need to capture last charecter from the column ‘CharSq’
  2. *Slope (in column J) =(B3-B2)/(A3-A2)
  3. Intercept (in column K) =B2-(A2*(J3))
  4. Angle (in degrees) =MOD(DEGREES(ATAN2((A3-A2),(B3-B2))), 360) –
  5. Index of Difficulty =LOG(((E1/7.1)+1),2)
  6. Speed Value length (if speed value length >3, then mark as 1 or else 0) = =IF(LEN(D3) >= 3, "1","0")
  7. Wrong Sequence (if I3=I2,then mark search time, else actual time) =IF(I3=I2,"Search Time","Actual Time")
  8. Mark charecter into (1,2,3) = =IF(I2="A",1, IF(I2="B",2, IF(I2="C",3, 0)))
    enter image description here

I have started with this SQL query SELECT id, type, charSq, substr(charSq,-1,1) AS TypedChar, xCoordinate, yCoordinate, angle, distance, timestamp, speed FROM table 1 WHERE 1

Need help for the rest of the parameters. Thanks.

Note – I am going to run this in phpMyAdmin SQL


Get this bounty!!!

#StackBounty: #mysql #pivot #dynamic-sql #phpmyadmin Monthly Date and Hour wise report generation using PHP MYSQL

Bounty: 50

Attendance Portal in PHP

I am facing problem at Final Attendance Report Generation

I’m stuck at the final stage of the Project:

I have a Table- attendance, If a student is Present I mark it as 1 if absent 0. we have a date, day order, hour (we are following Day Order Time Table)

 Table 
    dayorder:
        id day
        1 day1
        2 day2
        3 day3
        4 day4
        5 day5
        6 SAT
        7 day6
Table 
Hour:
   id
    1
    2
    3
    4
    5
    6
    7

Table attendance:
enter image description here

I must generate a Monthly report like a register as below
enter image description here
Code I have Tried:

SELECT student_id,deptno,Month, Year_c,
branch.description as bdesc,
course.coursecode as ccd, 
users.firstname as ufn, 
users.lastname as uln,
course.description as ccdes,schedules.hour as hhour,
h,dayorder,AttdDate,
CONCAT(AttdDate,h,dayorder) AS fate,
IF(Day_c=1, p, " ") AS '1',
IF(Day_c=2, p, " ") AS '2',
IF(Day_c=3, p, " ") AS '3',
IF(Day_c=4, p, " ") AS '4',
IF(Day_c=5, p, " ") AS '5',
IF(Day_c=6, p, " ") AS '6',
IF(Day_c=7, p, " ") AS '7',
IF(Day_c=8, p, " ") AS '8',
IF(Day_c=9, p, " ") AS '9',
IF(Day_c=10, p, " ") AS '10',
IF(Day_c=11, p, " ") AS '11',
IF(Day_c=12, p, " ") AS '12',
IF(Day_c=13, p, " ") AS '13',
IF(Day_c=14, p, " ") AS '14',
IF(Day_c=15, p, " ") AS '15',
IF(Day_c=16, p, " ") AS '16',
IF(Day_c=17, p, " ") AS '17',
IF(Day_c=18, p, " ") AS '18',
IF(Day_c=19, p, " ") AS '19',
IF(Day_c=20, p, " ") AS '20',
IF(Day_c=21, p, " ") AS '21',
IF(Day_c=22, p, " ") AS '22',
IF(Day_c=23, p, " ") AS '23',
IF(Day_c=24, p, " ") AS '24',
IF(Day_c=25, p, " ") AS '25',
IF(Day_c=26, p, " ") AS '26',
IF(Day_c=27, p, " ") AS '27',
IF(Day_c=28, p, " ") AS '28',
IF(Day_c=29, p, " ") AS '29',
IF(Day_c=30, p, " ") AS '30',
IF(Day_c=31, p, " ") AS '31'
FROM
(SELECT *,DAY(date) AS Day_c, 
MONTHNAME(date) AS Month, 
Year(date) AS Year_c,
date(date) AS AttdDate,hour as h, day as dayorder,
(CASE  WHEN present = 1 
    THEN 'P'
    WHEN present = 0 
    THEN 'A'
    WHEN present is null   
    THEN ' '
END) AS p
FROM attendance a 
WHERE date between '$from' AND '$to' And branch = $branchid AND coursecode = $courseid AND batch = $batchid
GROUP BY student_id
ORDER BY student_rollno ASC 
)
as report 
LEFT JOIN branch on branch.id = report.branch
LEFT JOIN course on course.id = report.coursecode
LEFT JOIN users on users.id = report.user
LEFT JOIN schedules on schedules.id = report.hour
ORDER BY Month DESC, Year_c DESC

OUTPUT in PHPMYADMIN:
enter image description here
But I am not able to show up as a HTML Page using PHP and MY SQL.
How to get data without dates which are not recorded?


Get this bounty!!!

#StackBounty: #mysql #phpmyadmin Can't run the newest version of MySQL on phpMyAdmin

Bounty: 50

I am building a database on phpMyAdmin. However, it doesn’t include the latest version of MySQL:enter image description here

I downloaded the latest version of MySQL from this link: MySQL Community Server 8.0.16

However, even after I installed it I cannot find a way to change it on phpMyAdmin since when I open wamp, go to MySQL –> Version the only version that appears is 5.7.26. So how can I update it to the latest one? I am running it on Windows 10.


Get this bounty!!!

#StackBounty: #mysql #phpmyadmin Can't run the newest version of MySQL on phpMyAdmin

Bounty: 50

I am building a database on phpMyAdmin. However, it doesn’t include the latest version of MySQL:enter image description here

I downloaded the latest version of MySQL from this link: MySQL Community Server 8.0.16

However, even after I installed it I cannot find a way to change it on phpMyAdmin since when I open wamp, go to MySQL –> Version the only version that appears is 5.7.26. So how can I update it to the latest one? I am running it on Windows 10.


Get this bounty!!!