PHPize Online / SQLize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
CREATE TABLE IF NOT EXISTS `user_value` (`Id` int(5) NOT NULL, `user_name` varchar(10), `user_color` int(6) NOT NULL DEFAULT 1, `user_pass` varchar(10)); ALTER TABLE `user_value` ADD PRIMARY KEY (`Id`); ALTER TABLE `user_value` MODIFY `Id` int(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1;
Copy Clear
Copy Format Clear
<?php if($q = mysqli_prepare($mysqli, "INSERT INTO `user_value` (`user_name`, `user_pass`, `user_color`) VALUES (?, ?, ?)" )){ $json_param = '[["dsi","1.1","test","''"],["ssi","sacatec","sacated","10"]]'; if($obj = json_decode($json_param, true, 3)){ $temp = array(); foreach($obj as $key=>$val){ //$q->bind_param($val[0], $val[1], $val[2]); call_user_func_array(array($q, 'bind_param'), $val); if($q->execute()) echo "success\n".count($val)."\n"; else echo "error executing\n"; } }else echo "error in json"; }else echo "error preparing"; $GetAExpense = mysqli_query($mysqli, "SELECT * FROM user_value WHERE 1"); while($Col = mysqli_fetch_assoc($GetAExpense)){ echo "\n"; echo $Col['Id']; echo "\n"; echo $Col['user_name']; echo "\n"; echo $Col['user_pass']; echo "\n"; echo $Col['user_color']; }
Show:  
Copy Clear