If count($arr2) is 26 if(count($arr1) === count($arr2) === 26) evaluates to if(count($arr1) === True) which would then fail. You need to perform two logic checks and check they both evaluate to true 3 solved using count in if statement and comparing with its returned value doesn’t work [closed]
Both your PHP and your MySQL syntax have problems. First, your SQL statement needs to be surrounded by quotes. Secondly, the syntax for LOAD DATA INFILE is incorrect. Try this: $stmt=$db->prepare(“LOAD DATA INFILE ‘insert.txt’ into table `Info`”); $stmt->execute(); See the MySQL docs for LOAD DATA INFILE for more options. You’ll probably need to specify your … Read more
Parse error: parse error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting ‘]’ in C:\Programe\xampplite\xampplite\htdocs\insert.php on line 12 [closed] solved Parse error: parse error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting ‘]’ in C:\Programe\xampplite\xampplite\htdocs\insert.php on line 12 [closed]
Yes, you will need to put your file inside the libraries folder(if the class is separate from codeigniter or is shared among many controllers, if not a Model would suffice), then create a controller for it. class Ajax_Controller extends CI_Controller { public $statusCode = 200; public $response = array(); public function __construct() { parent::__construct(); if(!$this->is_ajax_request()){ … Read more
emm … if you asking if it is posible , Yes it is . You can use socket.io , it is a librery to send and listen data in “real time” . In you page you can listen if other user change the color and you can send it to change , and in a … Read more
Since you are using wampp. try go command line on the bin folder with mysql.exe file. Test are you able to connect to that server in the first place. mysql -uroot -h 192.168.1.### -P 3306 -p -uroot -u is indicate user name. root is the user name to login your mysql server. Just change the … Read more
Applications which runs on the end-users machines should never-ever have direct database access. Create a REST API with PHP (if you already using it) which handles the database operations and invoke it with JavaScript (this is the short explanation of AJAX). solved INSERT into MySQL database with JavaScript but without Node.js [closed]
Use EXPLODE inside foreach <?php $yourArr = array(‘2,3′,’2,3’); $a = 0; $b =0; foreach ($yourArr as $temp) { $tempnew = explode(“,”,$temp); $a += $tempnew[0]; $b += $tempnew[1]; } echo “a = “.$a.”<br>”; echo “b = “.$b; ?> 1 solved How to Adding values of two dimnetional array in php [closed]
You can’t add quality just by increasing the bitrate. It’s like an image – if you have an image that is 24px square, and increase it to 72px it’s just going to get blurry. FFMPEG or any other library has no way of knowing what data was removed when you reduced it to 16kbps (if … Read more
Use this: <table> <tr> <td><?php echo $json[‘rows’][0][0]; ?></td> </tr> </table> 1 solved Get just one data in an array in PHP [closed]
Server-side-generated JavaScript would be an appropriate description. It even shows up on Google autocomplete, and there are many results. I am not a fan of this pattern. I find that it is better to keep JavaScript on the view-side completely and just inject the values you need via an init method of some sort. 1 … Read more
You can use DISTINCT to achieve it. Syntax: SELECT DISTINCT column_name FROM table_name; Based on above syntax, your query should be SELECT DISTINCT CLASS FROM ‘table_name’ solved Retrieve table values without retrieving duplicate values [closed]
Your question is very unclear and I may be way off, but here is my attempt to your question. $link = array(‘S1, Ep1’, ‘S1, Ep2’, ‘S1, Ep3’, ‘S1, Ep10’); $results = preg_replace_callback(‘~^S(\d+)\D+(\d+)$~m’, function($m) { $which = strlen($m[2]) > 1 ? ’00’ : ‘000’; return $m[1] . $which . $m[2]; }, array_values($link)); print_r($results); Output Array ( … Read more
I don’t know what data base are you using. You can search for “Bulk Insert” for your data base, it allows you to insert complete file in one step. If you need to create an instruction like this: INSERT CodesTable VALUES (91111), (91112), … (91999) You could open/copy&past the file in query editor. Make a … Read more
Try this its working <? $file = file(“data.txt”); foreach($file as $key => $value) { $filter_value = trim($value); if($filter_value!=”” && $filter_value!=”—-SMS_START—-” && $filter_value!=”—-SMS_END—-“){ $new_array[] = $value; $my_array = array_chunk($new_array, 7); } } $count = count($my_array); for($I=0;$I<$count;$I++){ foreach($my_array[$I] as $key => $value){ $ss = explode(“:”, $value); $mm_array[$I][$ss[0]] = str_replace($ss[0].”:”, “”, $value); } } echo “<pre>”; print_r($mm_array); echo … Read more