here in below how you can do it $this->db->select(‘r.report_id, a.advertisement_title, COUNT(r.advertisement_id) AS total’); $this->db->from(‘report r’); $this->db->join(‘advertisement a’,’a.advertisement_id = r.advertisement_id’); $this->db->group_by(‘r.advertisement_id’); solved How do I convert below query into codeigniter [duplicate]
Using Javascript will likely work. <div id=”grandtotal”>0.00</div> <?php $getinfo = mysql_query(“SELECT * FROM sales”); while($rows = mysql_fetch_assoc($getinfo)){ $price = $rows[‘price’]; // I want this to be display on top of my page before this query $quantity = $rows[‘quantity’]; // I want this to be display on top of my page before this query $total = … Read more
check this code , guess you want to single array result check array_reduce () built in function <?php $your_array = array(0 => array(‘item_id’ => 3160), 1 => array(‘item_id’ => 13123), 2 => array(‘item_id’ => 234234), 3 => array(‘item_id’ => 2123)); echo “<pre>”; print_r($your_array); $convert_array = array_map(‘intval’, array_column($your_array, ‘item_id’)); echo “<pre>”; print_r($convert_array); then your original Array … Read more
That is why storing base64 encoded serialized data in the database is extremely bad idea. You have to redesign your database, getting rid of base64_encode and serialized data. While using base64 with database makes absolutely no sense by any means, storing serialized data in the database is like mending an electronic device with stone hammer. … Read more
SELECT cid, SUM(vote) AS upvoted, SUM(CASE WHEN vote = 0 THEN 1 ELSE 0 END) AS downvoted FROM yourtablename GROUP BY cid; 0 solved counting upvotes and downvotes [closed]
First of all, don’t do mysql query in the event, that make the server lag. You have to create hashmap with the data you want to link to mysql server and do a scheduler Async task that do the query. Example: package test; import java.sql.DriverManager; import java.sql.SQLException; import java.util.Map.Entry; import java.util.UUID; import java.util.concurrent.ConcurrentHashMap; import org.bukkit.entity.Player; … Read more
edit: as the Colonel indicated, apparently this (no longer?) works with LIMIT clauses. If you’re using simple queries / are not that bothered with type: function fetchAll(){ $args = func_get_args(); $query = array_shift($args);//’SELECT * FROM users WHERE status=? LIMIT ?,?’ //you’ll need a reference to your PDO instance $pdo somewhere…. $stmt = $pdo->prepare($query); $stmt->execute($args); return … Read more
You can use : $this->db->get_where(‘product’, ‘category_id >=10’); OR $this->db->where(‘category_id >=10’); 0 solved how to get result form mysql query in specific ids [closed]
Include executes all of the code inside the file right away, and performs exactly as if you were copy-and-pasting the files into the document. This is different from how C or other languages handle #include statements. Pretend you are copy and pasting your code from those 3 files into one file, in that order… would … Read more
Below is sample code for enable textbox on selectbox option select. Please do required changes. <script type=”text/javascript”> function showtextbox() { var x=document.getElementById(“intext”). x.disabled=false; } </script> </head> <body> <form> <select onChange=”showtextbox()””> <option >one</option> <option>two</option> </select> <input type=”text” id=”intext” name=”intext” disabled=’disabled’> </form> </body> </html> Use your php code to connect and insert data in database. 2 solved … Read more
Check the MySQL slow query log to identify which query(ies) are causing the delay, then run EXPLAIN on them to see which (if any) indexes are being used. If you see that indexes are not being used, consider adding indexes to relevant columns. Such columns would be those used in WHERE and JOIN clauses. For … Read more
Hope it helps you, $num = mysql_num_rows($result); instead of $num = $result1->num_rows; mysql_fetch_object($result) instead of mysql_fetch_object($result1) <?php if (!$x) { echo “<script type=”text/javascript”>document.location.href=”https://stackoverflow.com/questions/20008385/index.php”;</script>”; } else { $con = mysql_connect(‘localhost’, ‘userdb’, ‘pwd’) or die(mysql_error()); $db = mysql_select_db(‘dbname’, $con) or die(mysql_error()); $result = mysql_query(“SELECT * FROM `users` WHERE `md5pwd` = ‘”. $x .”‘”); $num = mysql_num_rows($result); if($num … Read more
Use two variables to store the positioncolumn values of ids having 1 and 2. Then use a CASE expression to update the table accordingly. Query set @a := (select `position` from `your_table_name` where id = 1); set @b := (select `position` from `your_table_name` where id = 2); update `your_table_name` set `position` = ( case `id` … Read more
is this what you are looking for? foreach([100, 500, 543, 1000, 5000, 51000, 500000] as $my_friends) echo ‘5 in ‘. getScoreOf($my_friends) . “<br>”; function getScoreOf($my_friends){ $of = 5; $total = 5e5; //that’s 500,000 😉 $step = 100; //minimum step, so output is not “4604” but “4600” $out_of = $total / $my_friends * $of; return $out_of … Read more
$fields = array_keys($_POST); if (!empty($fields)) { $names = implode(‘`, `’, $fields); $values = implode(‘, :’, $fields); $sql = “INSERT INTO customers ( `”.$names.”` ) VALUES ( :”.$values.” )”; print_r($sql); $addRandom = $pdo->prepare($sql); foreach ($fields as $field) { $addRandom->bindValue(“:{$field}”, $_POST[$field]); } $boolean = $addRandom->execute(); if ($boolean){ echo ‘INSERTED’; } else { echo ‘FAILED’; } } 0 … Read more