Tagged Questions
MySQL is an open-source, relational database management system. If your issue relates to MySQLi, use the MySQLi tag instead.
0
votes
0answers
4 views
SQL: How to insert dynamic number of inputs in my table
I have a form with a list of cars and i want to to insert the cars which are selected in the form. How will i insert it on my table since the number of input is not fixed at a certain amount.
0
votes
0answers
21 views
Sort an SQL query not a table
I have a database containing a large amount of information that a user can query using PHP to communicate with the MySQL database. I also want to limit their results to be at most 300 results, which I ...
0
votes
0answers
4 views
Codeigniter profile page function keeps looping
I am working on a website in which i want to create user profiles. I got a page where i list all the users in a table. I made a button to link to the profile page of a user. The profile page gets the ...
0
votes
0answers
5 views
Mail() error when adding bbc
i have a mailing script to send emails to specific users. I get the emails from a mysql database.
The email setup is working fine when sending the email to a single person. when just using to: and no ...
-2
votes
0answers
13 views
how to get a value for a function wrote out side inside the database?
I have a function called getlastName() that get the last name of a person and I have a mysql table that have a last name field but I want to call my function not in a php code but in the database to ...
0
votes
0answers
22 views
MySQL dynamic order
In general, all I need to do is to order a MySQL table.
But, it has to be a "smart" order and I would like to hear your opinions.
There is a table of customers
id, name, email, phone, country, ...
0
votes
0answers
15 views
SQL get all rows from first table with specific valu and add all related rows from table 2
I have problem getting the SQL output I want.
I have two tables like this:
**tblOrder**
*ID* *User* *Status*
1 1 0
2 1 0
3 2 1
**tblOrderItem**
*ID* ...
-1
votes
1answer
22 views
How to sort group of data by rows in php that called from MySQL
hi guys me going to do some report in php with my sql
this is my output that fetch by mysql
Receipt No. Regno Vaccine Name Amount
2015100015 98007 DHLP 115.00
2015100022 ...
1
vote
0answers
14 views
German characters in angularJS live search
German characters in angularJS live search
First off, sorry for my bad English, I'm from Austria...
I have problem with angularJS live search from MySQL, everything works perfectly except German ...
0
votes
1answer
17 views
Hibernate criteria to fetch the records?
I have below records in table.
col1 col2 col3
------------------------
1 Abc IN
2 DEF CA
3 Xyz IN
4 Cae CA
5 Pty IN
6 Zwe DE
...
0
votes
0answers
8 views
Connect To MySQL Server With SSL : connectionstring
I'm using a 3rd party application to connect to MySQL Server from http://www.perfectsync.com/pp/DevTools/DevelopmentTools.php
I've created the certs and keys for MySQL and confirmed that WorkBench on ...
0
votes
1answer
6 views
Django: Automatic assignment of primary key in MySql failing
I am following the Effective Django tutorial with the change of using MySql instead of sqlite3.
Following the official recommendation of Django and given that I am working with Python3.4 I am using ...
0
votes
2answers
20 views
“Properly” looping trough (my)SQL response
I am a bit stuck with a problem (for several years now actually).
Problem description.
I have a class that does the MySQL stuff for me.
I have 1 to n rows in a MySQL Table and want to query ...
1
vote
2answers
34 views
Else statement doesn't work in option select
I am trying to implement a dropdown search option. All my search results are working. All the commands that I have assigned to if statements work, but when it does to else it deosn't work.
Here is my ...
0
votes
0answers
8 views
Sequelize create include
I have the following models and assosiations:
var AcademyModule = sequelize.define('academy_module', {
academy_id:
{
type: DataTypes.INTEGER,
primaryKey: ...
0
votes
0answers
5 views
How do you do a generic insert with JDBI?
I am using JDBI with MySQL and I've an interface GenericDao where I've this method
public void insert(T entity);
How do I implement this method with JDBI by using the fluent queries instead of ...
-1
votes
2answers
12 views
How to get count of records for some specific where condition in SQL
I have a data in which there are 2 columns:
USER_ID and CONTRACT_ID. There can be 'n' number of users in a contract id.
1 0303000
2 0303000
3 1234567
1 0303000
2 0303000
3 1234567
...
-1
votes
1answer
31 views
php file working on localhost but not in server
This is my registration php page..!
when i get registered on localhost it works fine and redirect me to feedsomeinfo.php
but in server
it is redirecting me on login_attempt.php
any clue why it is ...
0
votes
0answers
10 views
MyISAM table does not use index
I am facing a weird problem and i hope someone can help me.
I have to migrate all the data of production environment to another machine, so i made a full backup of the schema and restored it on the ...
-1
votes
1answer
24 views
AJAX PHP comment box userid=0? reply=“”?
when I entered the text in the textarea, it come up nothing.
It showed
cveUser name :jason123User id :1
forum_insert.js?t=1427284551:44 ...
0
votes
1answer
5 views
Replicate different tables to different database in MySql
I have Database1 on server1 and Database2,Database3 on server2. Database1 has two tables T1, T2. I want to replicate T1 on Database2 and T2 on Database3.
How can I accomplish it?
I googled but only ...
0
votes
1answer
12 views
Edit data in the MySQL DB table with no Primary Key in CakePHP
Using cakephp-2.6.3 on a Windows system.
I just need to edit the row data in the MySQL database table which I listed in the ABCData/index.php file.
Controller
public function index() {
...
0
votes
1answer
13 views
Database Schema knowledge boundaries
I'm struggling to figure out where to put the knowledge about the database.
For example:
Lets say we have a database with operators of different enterprise and they operate in different states and ...
1
vote
0answers
19 views
php code to Display Monthly Booking Report using sql
I am doing a Surveyor Management System in php using Mysql DB. I am stuck in my Project. Please anybody suggest How to Achieve This.
Now I want to display a report of all Surveyor Booking Count for ...
1
vote
0answers
14 views
Notice: unserialize(): Error at offset 0 of 1 bytes
I am receiving the following error:
Notice: unserialize(): Error at offset 0 of 1 bytes
Warning: implode(): Invalid arguments passed in
for the following lines:
$person = unserialize($person);
...
1
vote
0answers
4 views
How to recover xampp server database file?
My xampp server was destroyed by virus in my local host. I cannot start this xampp server again. I want to recover my database file. If I start my xampp server and click any files in it, the the ...
0
votes
1answer
17 views
So many requests in 1 second for updating one specific data record
There are 1000+ requests comes to update just single specific record in 1 or less then 1 sec. How can we deal with this, every single request is very important.
*
Suppose, 1 sec = 1000+ requests ...
0
votes
1answer
10 views
wordpress include a second mysql connection
I have a website with some pages, now to add other pages I've installed wordpress in a subdirectory.
I've created a CHILD THEME for wordpress. In the header.php of my child theme I've included the ...
0
votes
2answers
31 views
foreach logic to not repeat html
I want to get all my page titles from my WordPress database.
So I created a query like:
$results = $wpdb->get_results("SELECT * FROM $wpdb->postmeta WHERE meta_key = 'company_name' ORDER BY ...
0
votes
6answers
39 views
Multiple query on same table
This is a part of big query that are generated dynamically depending on the on post params ...
there is a table user_params
id | user_id | param_id | param_value
...
-1
votes
4answers
52 views
Show today's birthday
I want to use the script i placed underneath, but it should show me who's having birthday today. i have added a birthday in my sql table ion this format: 1985-06-03
<html>
<head>
...
0
votes
1answer
7 views
MariaDB dynamic columns for activity stream?
I have the following problem:
We have a lot of different, yet similar types of data items that we want to record in a (MariaDB) database. All data items have some common parameters such as id, ...
1
vote
0answers
22 views
Using PHP/MySQL, how can I SELECT from table with multi-value column content
This one has me stumped. I am trying to create a report from a table that has company data, including two columns both of which can have multiple values. Example:
A company can be classified as ...
0
votes
1answer
26 views
How to make dynamic slideshow using php, mysql, css and html?
I wanna make dynamic slideshow with css and HTML. Image will be took by id from tb_image.
id int
image_name varchar (100)
image_path (100)
How to make dynamic slideshow using php, mysql, css and ...
0
votes
0answers
9 views
MySQL order_by CAST in Fuel Framework
Im working on Fuel Framework and I need to build query with order_by title which is varchar but most of them are numeric.
I need to sort it in true numeric order.
So I want to use "CAST(title as ...
-1
votes
2answers
40 views
SQL Query only displaying first result rather than arrayed data
Basically I am building a calendar page that displays the months, and the days of the month(pulled from my database) and then any days that are inside the "start_date - end_date" variables are ...
1
vote
1answer
26 views
MySQL Query with IN clause
I am working on PHP and this query we want to execute :-
1: Query -
SELECT m.sku AS sku FROM merchant m WHERE m.sku IN ...
0
votes
2answers
18 views
Display query results in controller as array
I am using codeigniter and want to create restfull api, but I amstuck in displaying results of query at inside of array.
This is standart code if without query database:
$users = array(
...
0
votes
0answers
7 views
how do I manage one product with multiple vendors in magento for same store?
Suppose there are multiple vendors for the same product (say a mobile phone of a xyz brand/model) .
One product but multiple vendors.
Is it possible to list all the vendors on the product page for ...
-1
votes
0answers
12 views
Php, avoid nested cycles
My db schema is very simple:
Tab1
id_a | description | city | region
Tab2
Id_b | id_a | cod
The relactions from the tables are 1-to-M
I'm using Codeigniter, I have to show the result on the ...
0
votes
0answers
4 views
What does pt-online-schema-change tool do if it aborts?
I am planning to use pt-online-schema-change tool for a table alter on a production server in a replication environment. Wanted to understand what steps are executed when pt-online-schema-change tool ...
1
vote
1answer
12 views
create a multidimensional array for pdo select
while ($v = $stmt - > fetch(PDO::FETCH_ASSOC)) {
$basicinfo[] = array('sysid' => $v['sysid'], 'thesis' => $v['thesis']);
}
$input = array_map("unserialize", ...
-1
votes
1answer
27 views
Send and return working hours
I want to calculate how much I am getting in salary every day. Basically I want to choose a starttime and an endtime, and then send it to my MySQL database. That means when I hit submit here, the ...
0
votes
0answers
12 views
jquery week Calendar Retrieve events from DB Issue
I attempt to populate jquery Week Calendar from an mysql Database. My insert to DB event works greate but I cannot retrieve any events from my DB.
In the Demo of Week Calendar he retrieve Event ...
1
vote
1answer
19 views
How to Dump Mysql database using Command line?
When I tried to dump database using command line, it gave me following error.
Command:
D:\TOOLS\MySQL\MySQL Server 5.6\bin>mysqldump -u root -p webchat > tut_backup.sql
Error:
mysqldump: ...
2
votes
1answer
22 views
How to iterate through $_POST to update multiple recordsets in DB via PDO
I'm new to PDO and associative arrays but am making good progress. I've set up this code to save a html form to a single recordset:
$str_sql = "UPDATE tbl_benutzer SET ";
foreach($_POST as ...
0
votes
2answers
23 views
MySQL and datetime
If I have a table with a DATETIME column I can insert dates that have a format like:
2015-03-25 10:10:10
2015-03-25 10:10
2015-03-25 10
2015-03-25
It will fill in the remainder with zeros. I can't ...
-4
votes
0answers
5 views
I Have Installed xampp on windows 7 ,when i open xampp control panel mysql giving error
[mysql] Attempting to start MySQL service...
4:21:25 PM [mysql] Uninstalling service...
4:21:25 PM [mysql] MySQL Service detected with wrong path
4:21:25 PM [mysql] Change XAMPP ...
-3
votes
2answers
26 views
How to display video a url in php?
I'm trying to create a form in which a user inserts their youtube code into a field, which is then stored in mysql.
how can i display video?... while fetching data from my database it displays the ...
1
vote
2answers
20 views
What is the best way to make this SQL query as Elequent statement
I need following sql statement to translate to the Laravel Eloquent. tried several ways and literally failed.
SELECT * FROM `conversations` where `type` = 'open'
AND `sender_id`=2 AND ...
