PHP insert combination to mysql

Question

I am fresh learner.

I found a difficulty for "Insert combination data made PHP to MySQL"

Example: for 1,2,3,4, combination is:

I want to insert that into a MySQL database.

Result:

123
124
134
234
234 <= duplicate

I couldn't locate where is the problem is. Thank you so much. :-)

$lista = array($a,$b,$c,$d);
$b=1;

for ($i=0; $i<=3; $i++) {
  for ($j=$b; $j<=4;$j++) {
    for ($k=$j+1; $j<count($lista); $j++) {

       printf($lista[$i].','.$lista[$j].'<br>');

       $sql="INSERT INTO table10(id)
            VALUES($lista[$i]$lista[$j])";
        mysql_query( $sql, $con );

        }           
    }
    $b++;
}

Anik Islam Abhi · Accepted Answer · 2014-11-22 08:00:58Z

3

You can create array to avoid duplicate data

$dupList=array();
//declare this array before loop

//Hold  $lista[$i] and $lista[$j] jointly in a variable
$newVal=$lista[$i].$lista[$j];
if (!in_array($newVal, $dupList)) {

      $sql="INSERT INTO table10(id) VALUES ($newVal)";
      mysql_query( $sql, $con );
      array_push($dupList,$newVal);
}

edited Nov 22, 2014 at 8:00

answered Nov 22, 2014 at 6:54

Anik Islam Abhi

25.4k8 gold badges61 silver badges82 bronze badges

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

4 Comments

oshk100100 Over a year ago

My array logic isn't very good, after I added this to my code. It appear an error. "syntax error, unexpected T_VARIABLE< start from IF..... Is it something wrong to me? The code I added as another, please comment. Thank you so much

oshk100100 Over a year ago

Hi, I upadted the codes, it seems work, but the record is still duplicated. I felt a sense of shame, is it something wrong on me. I took almost 2 hrs try to fix it. It doesn't work. Can I send my control panel to let u check. T^T.

Anik Islam Abhi Over a year ago

what in $lista = array($a,$b,$c,$d); $a,$b,$c and $d ?

oshk100100 Over a year ago

$a=$_POST[no1]; $b=$_POST[no2]; $c=$_POST[no3]; $d=$_POST[no4]; All are number inputted by user what number they want from a simple form website.

oshk100100 · Accepted Answer · 2014-11-22 07:37:45Z

1

My array logic isn't very good, after I added this to my code. It appear an error.

syntax error, unexpected T_VARIABLE< start from IF..... Is it something wrong to me? The code I added as below.

$lista = array($a,$b,$c,$d);
$dupList=array();
//declare this array before loop
$b=1;


for ($i=0; $i<=3; $i++) {
    for ($j=$b; $j<=4;$j++) {
        for ($k=$j+1; $j<count($lista); $j++) {
            if (!in_array($lista[$i]$lista[$j], $dupList)) {
                $sql="INSERT INTO table10(id) VALUES ($lista[$i]$lista[$j])";
                mysql_query( $sql, $con );
                array_push($dupList,$lista[$i]$lista[$j]);
                }
            }
        }
    $b++;
}

answered Nov 22, 2014 at 7:37

oshk100100

312 bronze badges

Collectives™ on Stack Overflow

PHP insert combination to mysql

2 Answers 2

4 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related