PHP - Moved: Insert Substring Function

This topic has been moved to PHP Regex.

http://www.phpfreaks.com/forums/index.php?topic=321386.0

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=309473.0

I have a class built for an INSERT query but it is passing two sets of records into the database rather than one.

Code: [Select]
class DatabaseInsert {

function DatabaseConnectionRequire() {
include("../scrips/php/database.connection.class.php");
include("../scrips/php/database.settings.php");
include("../scrips/php/database.connection.class.invoke.php");

}

function ArticleInsert($values,$fields,$table) {

$values_imploded = implode("   ",$values);
$fields_imploded = implode("   ",$fields);
$i = "INSERT INTO $table ($fields_imploded) VALUES ($values_imploded)";
mysql_query($i) or die(mysql_error());

if (!mysql_query($i)) {

    echo "Sorry, something whent wrong there...";
}

else {
echo "<strong><p style='color:green;'>Content added sucessfully!!!</p></strong>";
}

}
}

Hello all, so I created an insert function and it seems no matter what I try that it won't add values using the query function inside a table from the respective variables, I would like to know why is this happening? Here is the code can you tell me why it doesn't insert anything in the database? It shows no errors when it runs but then again when I check the tables they're empty!

function insert(){
				$user = $_POST['user'];
				$pass = md5($_POST['pass']);
				$priv = "User";
				$mail = $_POST['mail'];
				$avatar = $_FILES['avatar']['name'];
				$date="now()";
				$submit = $_POST['submit'];
			
			
				$query = "INSERT INTO user(user,pass,priv,mail,avatar,date) VALUES(`$user`,`$pass`,`$priv`,`$mail`,`$avatar`,`$date`);";
				if($submit){
					$res = mysqli_query($con,$query) or die(mysqli_error($con));
				}
				
				
			}

HI,i am using java script to create a add row function in the php .but when the first row data can insert into database ,the 2nd row data cannot insert into database ,can help me to check my coding? thanks a lot


Code: [Select]
<SCRIPT language="javascript">
        function addRow(tableID) {
 
            var table = document.getElementById(tableID);
 
            var rowCount = table.rows.length;
            var row = table.insertRow(rowCount);
 
            var cell1 = row.insertCell(0);
            var element1 = document.createElement("input");
            element1.type = "checkbox";
            cell1.appendChild(element1);
 
         
            var cell2 = row.insertCell(1);
            var element2 = document.createElement("input");
            element2.type = "text";
            cell2.appendChild(element2);

var cell3 = row.insertCell(2);
            var element3 = document.createElement("input");
            element3.type = "text";
            cell3.appendChild(element3);

var cell4 = row.insertCell(3);
            var element4 = document.createElement("input");
            element4.type = "text";
            cell4.appendChild(element4);

var cell5 = row.insertCell(4);
            var element5 = document.createElement("input");
            element5.type = "text";
            cell5.appendChild(element5);

 
        }
 
        function deleteRow(tableID) {
            try {
            var table = document.getElementById(tableID);
            var rowCount = table.rows.length;
 
            for(var i=0; i<rowCount; i++) {
                var row = table.rows[i];
                var chkbox = row.cells[0].childNodes[0];
                if(null != chkbox && true == chkbox.checked) {
                    table.deleteRow(i);
                    rowCount--;
                    i--;
                }
 
            }
            }
catch(e) {
                alert(e);
            }
        }
 
    </SCRIPT>


THE PHP CODE
Code: [Select]
<?php 
require_once ('../../../Connections/admin_db.php'); 

mysql_select_db("admin_db");

if ((isset($_POST["Submit"])) && ($_POST["Submit"] == "Submit")) {
$i=0;
foreach($_POST['abc'] as $value )
{
   
                 $abc           = $_POST['abc'][$i];
 $level         = $_POST['level'][$i];
     $level_desc    = $_POST['level_desc'][$i];
      $pc_desc       = $_POST['pc_desc'][$i];
 
 
//Insert Data into Instructor Profile Info
$q = "INSERT INTO plo_pc(p_name,plo_id,plo_criteria,plo_level,level_dec,plo_desc)
VALUES ('$list','$plo_id','$abc','$level','$level_desc','$pc_desc') " ; 
 
mysql_query($q) or die(mysql_error()) ;
$i=$i+1;
}
}
?>