1#@!#!123s

: / home / diafrica / result.dominicaninstitute.org /
Filename : usethis.php
back
<?php 
try{
		$conn = new PDO("mysql:host=localhost;dbname=dunigeria_byto","dunigeria_main","Pwd4OkeAre=2019");
		$conn->setAttribute(PDO::ATTR_ERRMODE,PDO::ERRMODE_EXCEPTION);
	}catch(PDOException $e){
		echo $e->getMessage();
	}

function update($table,$in,$id_field,$id_val){
			global $conn;
		//Process the Array of data
		foreach ($in as $field => $value) {
			$fields[] = sprintf("`%s` = '%s' ",$field,$value);
			$field_list = join(',',$fields);
			}
			//Set the query string
			$query = sprintf("UPDATE `%s` SET %s WHERE `%s` = %s", $table, $field_list, $id_field, INTVAL($id_val));

			//Perform Update
			$stmt = $conn->prepare($query);
			$stmt->execute();

			return true;		
	}
	
	
	$select = $conn->query("SELECT * FROM students");
	$fetch = $select->fetchAll(PDO::FETCH_OBJ);
	foreach ($fetch as $data){
	    $id = $data->sn;
	    $surname = $data->surname;
	    
	    $surname = str_replace(' ', '', $surname);
	    
	    $in = array(
	          'surname' => $surname,
	        );
	        
	  update('students',$in,'sn',$id);

	}
	echo "Done";
?>