=
usrs table with some dummy data
users
id,mobile,name, email
after submit mobile number
it will show their data from usres table
and
we have anohter form in same page
dapartment , designation with add more
departments table
id, name
designations table
id, name
user has more departments , more designations
user_has_departments_designations
user,department_id,designation_id
[15:47]
enter mobile no text box
after enter textbox
show by default user details
[15:48]
in down give one form
select department , select designation addmore
[15:48]
submit
[15:48]
if again enter same mobile show by default all details
update details
[15:32]
$string ="fdkfhkhihrekfbkfndfnnfns";
$find=str_split($string);
$count = [];
foreach($find as $s){
if(array_key_exists($s,$count)){
$count[$s]++;
} else {
$count[$s]=1;
}
}
print_r($count);
[15:33]
Array ( [f] => 6 [d] => 2 [k] => 4 [h] => 3 [i] => 1 [r] => 1 [e] => 1 [b] => 1 [n] => 4 [s] => 1 )
[15:37]
select salary from employees order by salary desc limit (2,1)
[15:41]
select salary,count (*)as cnt from employees group by salary having count(*)>3
[15:45]
$.ajax({
url: 'www;google.com/api/xyz',
type'GET',
success:function(response){
console.log(response);
},
error:function(xhr,status,error){
}
}
);
task 2
i created students table with
name,
dob,
roll_number
section
class_name
gender
fathers name
another table
marks table
student_id
subject
marks
relation student_id and id of student_id
writtenquery
if i given roll roll_number
i wil get the co students
then checking the amrks of that student id and
caliculat total
then allot rank
[17:37]
student management system for school
[17:37]
school multilple class, design database , get student name, fa,dob, roll number, and gender, which class and which section
[17:38]
whn there are exams, three subjects , give ranks based on marks
http://127.0.0.1:8000/get_rank_by_roll_number?roll_number=13485401
{"id":1,"name":"vamsi","fathers_name":"nnr","dob":"2024-03-01","roll_number":13485401,"gender":"male","class_name":"First","section_name":"A","created_at":null,"updated_at":null,"total_marks":156,"rank":6,"marks":[{"id":1,"subject":"English","marks":51,"student_id":1,"created_at":null,"updated_at":null},{"id":2,"subject":"Telugu","marks":52,"student_id":1,"created_at":null,"updated_at":null},{"id":3,"subject":"Hindi","marks":53,"student_id":1,"created_at":null,"updated_at":null}]}
-=
No comments:
Post a Comment