Data dodania Pytanie
2017-10-04 16:10 Delete record from database using AJAX »
I have a PHP file which displays data from a database. I'm using while() to display each of the records. My PHP file: <?php $flightTicketsSQ...
(2) odpowiedzi
2017-10-04 09:10 MySQL server not started after installed Apache Cassandra »
I am trying to work with multiple database with single project. I have successfully integrated my project with MySQL database, but after installing Ca...
(0) odpowiedzi
2017-10-03 22:10 Change 32-bit PK to BIGINT on 32-bit rails app »
I have a Rails 3.2.18 app running on 32-bit Ubuntu using MySQL as the backend. The PK for one of my tables is a 32-bit integer and has recently maxed ...
(1) odpowiedzi
2017-10-03 12:10 How to fetch record from another table if first table return no record using UNION in MySQL query »
I have two table name 'activites' & 'archived_activities'. I devide my activities table record into another table record. Activities table contain...
(3) odpowiedzi
2017-10-03 12:10 JOIN THREE TABLES IN CODEIGNITER »
I have three tables 1.article (id,article_title) 2.article_status(id,article_id,stage_id) 3.article_stages(id,stage_name) Each article have multip...
(4) odpowiedzi
2017-10-03 11:10 Escape from CakePHP Paginate condition »
Paginate query: $this->paginate = array( 'conditions' => array( // 'Product.soft_delete NOT' => 'on', ...
(1) odpowiedzi
2017-10-02 19:10 Sort database results by distance with Query Builder (Spatial) »
First I want to show you the current database structure. There are three tables: dishes (id, name) locations (id, name, coordinates (POINT)) dish_l...
(3) odpowiedzi
2017-10-02 18:10 Need help building a QUERY in sql »
Need help building a query in sql. I have it and its working, but I also need to have the total amount of rows calculated for specific date. $query...
(1) odpowiedzi
2017-10-02 16:10 SQL IS NOT NULL not working »
I am attempting to write a short SQL query (in MySQL Workbench) that outputs the number of fails in a subject if it has been failed by more than one s...
(2) odpowiedzi
2017-10-02 12:10 how can i implement this code on laravel blade? »
how can i implement this code on laravel blade ? <td> echo '<img src="data:image/jpeg;base64,'.base64_encode( $item['image'] ).'"/>'; &lt...
(1) odpowiedzi
2017-10-01 20:10 MySQL Count in select »
i have a MySQL table with the username and bought items. Like… Username1 - Item_A Username1 - Item_A Username2 - Item_C Username2 - Item_D I need...
(1) odpowiedzi
2017-10-01 19:10 Laravel: Can't pass a Browser test using RefreshDatabase trait »
My test will fail if I use RefreshDatabase trait. Without the trait -- test will pass but data remains in database. I'm using: Laravel 5.5 (a fres...
(0) odpowiedzi
2017-10-01 15:10 Django JOIN on nested model Foreign key with look up field »
I'm using 2 models in Django Rest Framework. class Questions(models.Model): question = models.TextField() answer = models.TextField() tim...
(2) odpowiedzi
2017-10-01 01:10 UPDATE a column in every row with a random unique number »
I have a small table of about 20k rows. In that table there is a column named random_uid (INT NOT NULL). I would like to update all 20k rows with a ra...
(2) odpowiedzi
2017-09-30 17:09 Cannot print data form mysql table into dropdown »
I have categories table with columns: id and name. I want to display them into dropdown menu. They are stored in the following $categoriesArray: arra...
(2) odpowiedzi
2017-09-30 14:09 MySQL dynamic SELECT column value »
My MySQL table has these columns: Status : int(11) and Closed : int(1). The thing is that when I retrieve rows with SELECT, I want Closed to be treate...
(1) odpowiedzi
2017-09-30 11:09 How can I get values null after inner join? »
I have this structure: Table A -- |id_A | field_1a | id_B | value_A| Table B -- |id_B | field_1b | field_2b | value_B| Table C -- ...
(1) odpowiedzi
2017-09-29 23:09 MySql aggregate by different initial values on other column »
I have a table structure as follows | user_id | value | date | |---------|-------|------------| | 1 | 5 | 2017-09-01 | | 2 | 6 ...
(3) odpowiedzi
2017-09-29 17:09 laravel whereHas results weird »
product model public function country() { return $this->hasMany('App\Models\ProductCountry', 'product_id', 'id'); } the controll...
(5) odpowiedzi
2017-09-29 03:09 Spring JPA select one column doesn't work »
I need to retrieve all the records for players column in sports table. SportsRepository method like below. @SuppressWarnings("unused") ...
(1) odpowiedzi
2017-09-28 22:09 Laravel - Save HTML Dom-Parser response to database »
I have managed to get some HTML from a website using HTMLDomParser (http://simplehtmldom.sourceforge.net/): $html = HtmlDomParser::file_get_html('htt...
(1) odpowiedzi
2017-09-28 13:09 Checking duplicated data in Laravel »
This code work as send to inn_db table from ext_db. but it cannot check if the data is the same or different in inn_db. So there posited same values...
(2) odpowiedzi
2017-09-28 13:09 Json from mysql breaks »
i have some issue with a json stored in mysql TEXT field, the thing is that everything is OK until i use ' (single quote) the json then is saved \' an...
(2) odpowiedzi
2017-09-28 12:09 Django ORM Group By ID »
I am trying to get some information from my table; total price, total trip etc between two dates. Here is my query start_date = Utils.subtract_day(da...
(2) odpowiedzi
2017-09-28 08:09 MYSQL - Check conflicting time »
Currently, I have this table 'tbl_subloading' : teacher_name | start_time | end_time de Guzman, J | 08:00AM | 10:00AM Harris, M | ...
(1) odpowiedzi
2017-09-27 22:09 InnoDB: breaking and fixing indexes »
From time to time it happens that some indexes in our tables get broken and the DB start consuming 100% CPU load and in some time it gets completely s...
(1) odpowiedzi
2017-09-27 15:09 Expressing formula within a SELECT query »
I have this existing query: SELECT extension , Total_Outbound+Total_Missed+Total_Received AS Total_Calls , Total_Missed , Total_Talk_Time_minutes ...
(2) odpowiedzi
2017-09-27 11:09 select sum qty from 2 tables »
In MySQL I have 4 tables: - product(id) - order(id) - order_detail_1(id, product_id, order_id, qty) - order_detail_2(id, product_id, order_id, qt...
(2) odpowiedzi
2017-09-26 19:09 Displaying mysql results on my website using datatables with dynamic headers »
So i have a website that I am developing for work. It allows sales people to go in and enter a date range and their initials and it queries my databas...
(2) odpowiedzi
2017-09-26 16:09 Populate selection field from Mysql with Odoo »
I want to populate a fields.Selection in Odoo with values retrieved from MySQL select statement. I tried adding the values of select resultset inside ...
(1) odpowiedzi
2017-09-26 14:09 Insert data in MySQL db in all tables »
here I'm again for some help. :) I'm trying to insert data into my MySQL database using F#. My schema includes 3 tables (Experiments, Gene and Results...
(1) odpowiedzi
2017-09-26 11:09 Difference between passing the data type and executing an array without them »
I just want to know if these 2 sets of code are doing the same thing or not, if not what's the difference? $connect= new CONNECT(); $sql = ("query he...
(1) odpowiedzi
2017-09-26 05:09 Laravel 5.4 query builder Missing argument 2 when using orWhere clause »
Can someone tell me why im getting this error and how to fix it please. $lastDayPreviousMonth = date("Y-m-d", strtotime("last day of previous mon...
(1) odpowiedzi
2017-09-25 17:09 Remove Order in hibernate »
I have 4 entities : Profile wich have a relation with companyContract : @OneToMany(fetch = FetchType.EAGER, mappedBy = "profile", cascade = { Casc...
(1) odpowiedzi
2017-09-25 10:09 MySQL Column headers into a single column, second column for the values »
I currently have a table that shows the data I need in the format of SELECT * FROM XYZ; Date | Brand | Game1| Game2 | Game3 | 2017 | xxxxx | xxx...
(3) odpowiedzi