Data dodania Pytanie
2017-12-30 10:12 How to change DateTime format to a desired format via Carbon laravel »
I'm using laravel 5.5 and Carbon library to write an API. I store all date and time values in MySQL database as common YYYY-MM-DD HH:MM:SS format. ...
(4) odpowiedzi
2017-12-30 03:12 PHP mySQL Simple Echo from SELECT »
I am trying to create a simple echo from a SELECT from DB. It echos blank always. Here is the code: <?php $username = "xxxx"; $password = "xxxx...
(4) odpowiedzi
2017-12-29 23:12 Set .js file variable value from ejs on button click »
I have an ejs file where a table is displayed with the user id and name that is fetched from a mysql database. There are also buttons in all the rows ...
(0) odpowiedzi
2017-12-29 21:12 Laravel eloquent get all if variable is null »
i have a model User and i want search user by city but if the city varible is null a want all user my code like this User::where('city', $city)->...
(1) odpowiedzi
2017-12-29 16:12 Sorting Records on a Custom calculated value at the runtime- rails »
I have Two models Product, Price Product has_many :prices Price belongs_to :product we have price_type and price_date attributes in the Price M...
(0) odpowiedzi
2017-12-29 13:12 Laravel raw query that counts results per month and aggregates »
I have the following query $this->builder = (DB::table('sales') ->select(DB::raw('DATE_FORMAT(sale_date, "%M") as sale_date'), DB::raw(...
(2) odpowiedzi
2017-12-29 11:12 Tried both ng-repeat and ng-options for select dropdown; query results keep coming back empty »
First, let me make a couple of disclaimers: This is my very first time posting a question here. I only do so because I've tried numerous possible so...
(0) odpowiedzi
2017-12-29 10:12 Best way to create relational database model for different Customer modals in Laravel »
In my Laravel project i have 3 kind of types, Vehicle Owner, Driver and Customer models. When I'm adding credits and debts for all kind. It's workin...
(2) odpowiedzi
2017-12-29 08:12 Not understanding mysql statement DATE_ADD(NOW() INTERVAL) »
I am working on a page which contains the following line of mysql. The overal objective is simply to match the current week num to the current date $...
(4) odpowiedzi
2017-12-29 08:12 Menu tree not showing »
I want to create menu tree from a MySQL database. Below is my PHP code. I am unable to fetch data from database. I have shown data that shows for my c...
(3) odpowiedzi
2017-12-28 16:12 Create table mysql with TIMESTAMPDIFF »
I am converting some tables from my system that used sql server now to mysql, and am having a question in mysql how can I create a table with TIMESTAM...
(1) odpowiedzi
2017-12-28 13:12 How to make an application with editable structure of database »
I need to create an application with an editable database structure. Where you can add/delete/modify tables and fields, views and structure of the dat...
(2) odpowiedzi
2017-12-28 02:12 Join 2 tables via UNION group by a given field and get only the latest of the group »
I'm building an email inbox within a little dashboard. Is a custom email client using other APIs. The way I prepared the DB structure is as follows: ...
(1) odpowiedzi
2017-12-27 23:12 Syntax Eror Row number Database »
SELECT ROW_NUMBER()OVER(ORDER BY id), x, y, id FROM coordonnees ORDER BY id I'm trying to return the row number of each row (the table named coordon...
(1) odpowiedzi
2017-12-27 19:12 Why this callback does not access the correct value of outer scope? »
Using node-mysql I have the following code: for (var i = 0; i < 10; i++) { connection.query('select 1', function(err, rows) { console....
(1) odpowiedzi
2017-12-27 16:12 unable to make the foreign key get its referenced id value by default »
I am new in LARAVEL and i got some issues. My problem is that when i insert data into the first table i can see that it has an id settled by default ...
(1) odpowiedzi
2017-12-27 11:12 How to select rows with matching fields in MySQL? »
I have 2 tables, one with price overrides and one with minute overrides, each per user and product. How can I select them so that I have a record for ...
(3) odpowiedzi
2017-12-27 11:12 How to create two columns from two different subqueries in mysql »
I have two different queries from a single table and I want to merge these queries into a different column First query: select user_id,meta_value as...
(6) odpowiedzi
2017-12-26 22:12 query in cfc returns [n] items on local, but repeats first element [n] times on live site »
I am new to ColdBox (and mvc in general) and have been trying to sort this out myself, to no avail. A finding function works fine on our procedural si...
(1) odpowiedzi
2017-12-26 12:12 How to use JOIN in mysql to show all data which are not matching »
I want to show data from 2 tables and I want to show them all including data that are not matching. I've tried with this query. SELECT * FROM student...
(2) odpowiedzi
2017-12-26 10:12 SQL Query to select data based on year and month »
I'm writing an ecommerce app and im writing a script to track the sales of items according to year/month. I used this query here to get the distinct ...
(7) odpowiedzi
2017-12-26 01:12 How do I group on continuous ranges (mysql 5.7) »
I want to return an array of date time ranges of when a site is down. I am using MySQL 5.7. Table down_time created_at user_id down 2017-...
(2) odpowiedzi
2017-12-25 22:12 Joining tables in MySQL and requesting data from second table only »
I'm trying to join 2 tables where I need to show only 3 columns from the second one where another column is used as a comparison. For example: Table...
(4) odpowiedzi
2017-12-25 21:12 Condition on duplicate rows »
I have 4 columns: user id, start date (D/M/Y), type and name user_id | start_date | type | name 1 | 1-01-2017 | 0 | Jack 1 | 1-01-20...
(2) odpowiedzi
2017-12-25 20:12 I can't change main Django project settings file »
I was trying to configure the Django Database Settings to use mysql. I followed the instructions provided here I started a Django project within the ...
(2) odpowiedzi
2017-12-25 18:12 Passing a value to variable in a js file from an ejs file »
I am working on a project using javascript, expressjs, mysql and ejs. I would like to update a record in my database table. I have an ejs page display...
(0) odpowiedzi
2017-12-25 15:12 PHP is loading the same content endlessly »
How can i prevent it from loading the same table row all over again and never stopping ? My head can't take it ... I know i somehow created an infinit...
(3) odpowiedzi
2017-12-25 13:12 Laravel hasManyThrough 2 tables »
i have two tables as below: users table: |id|name|email|password|created_at|updated_at messages table: |id|sender_id|receiver_id|message|created_a...
(2) odpowiedzi
2017-12-24 22:12 nth best with group by mysql »
Name Marks ------------- John 100 John 80 John 70 John 60 Nancy 95 Nancy 88 Nancy 70 Nancy 40 I have the above table. I would...
(2) odpowiedzi
2017-12-24 22:12 How do deal with bots using the in-site search and overflowing the SQL with too many requests? »
What is the best practise to not annoy users with flood limits, but yet block off bots doing automated searches? What is going on: I am been more aw...
(1) odpowiedzi
2017-12-24 12:12 Laravel:Mediable Duplication error SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry »
I am trying to use $media->onDuplicateReplace(); in code: public function update($id){ $user = User::find($id); $user->name=r...
(0) odpowiedzi
2017-12-24 11:12 Configure Wordpress on Azure Cloud Service to connect to Azure MySQL over SSL »
We run Wordpress in a sub folder of our main .NET solution on a cloud service. We have moved our MySQL from CloudDB to Azure MySQL, however it will on...
(1) odpowiedzi
2017-12-24 07:12 Django build video website similar to YouTube »
I am trying to build a video upload, view, sharing website using Softwares : Django 1.11.8 Django Rest Framework 3.7.3 Python 3.6.3 Backend Data...
(1) odpowiedzi
2017-12-24 05:12 table join or not when ON statement false? »
I have a sql query (Part of a procedure) like this:- DECLARE ab INT; SET ab = 1; SELECT * FROM `table1` LEFT OUTER JOIN `table2` ON `table1`.`columnf...
(1) odpowiedzi
2017-12-23 23:12 Can't get MySQL working »
I have Ubuntu 16.04 server and wordpress installed. I have a wired problem which I couldn't find any solution for it. I get Error establishing a data...
(1) odpowiedzi