PHP MYSQL Automate Create Value

Question

i have code like

$quota = 100;
$quotaperclass = 25;

for ($x = 0; $x <= $quota/$quotaperclass ; $x++) {
    $sql = "INSERT INTO classroom (name) VALUES ('A')";
    for ($y = 0; $y <= 25 ; $x++) {
        $sql = "INSERT INTO classroomstudent (studen_id, class_id) VALUES ('', 'A')";
    } 
}

I want if quota per class 25, total quota div quota per class. in my case result is 4 and then automated create 4 class like A, B, C, D and then add every student to the class.

my question is. how to change value name automated like

loop 1 is A 
loop 2 is B
loop 3 is C
etc

and how to add every student into class automatically.

thanks

So are you trying to create 100 students divided across 4 classes? Or better stated X number of students divided into Y number of classes based on maximum of Z students per class? Why insert empty stings for id values? This seems problematic. Why names like 'A', 'B', 'C' for classes rather than something meaningful. If you just want to divide into Y number of classes, I would think integer value would suffice rather than applying arbitrary letters values (what happens after you exceed 26 classes?) — Mike Brant
– Mike Brant, Commented Jan 21, 2015 at 18:43

Funk Forty Niner · Accepted Answer · 2015-01-21 18:41:03Z

1

$range = range('A', 'Z');

$quota = 100;
$quotaperclass = 25;

for ($x = 0; $x <= $quota/$quotaperclass ; $x++) {
    $sql = "INSERT INTO classroom (id, name) VALUES ('', '".$range[$x]."')";

}

edited Jan 21, 2015 at 18:41

Funk Forty Niner

74.2k14 gold badges71 silver badges146 bronze badges

answered Jan 21, 2015 at 18:39

Mihai

26.8k8 gold badges71 silver badges87 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Funk Forty Niner Over a year ago

@MochamadSaepulM now - This was posted 6 mins. prior to that. If this works, consider accepting the answer.

Sreelal P Mohan · Accepted Answer · 2015-01-21 18:39:23Z

0

Try this

$c = 'A';
for ($x = 0; $x <= $quota/$quotaperclass ; $x++) {
 $sql = "INSERT INTO classroom (id, name) VALUES ('', '$c')";
 $c++;
}

answered Jan 21, 2015 at 18:39

Sreelal P Mohan

3131 silver badge11 bronze badges

Collectives™ on Stack Overflow

PHP MYSQL Automate Create Value

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related