mysql_connect() not working from class

MySQL
Just moved my site to new hosting. On the new server mysql_connect() works fine if called without using classes or inside of the method but not from ...
2 months ago

php export mysql data with dynamic columns to csv

MySQL
iam new to php, i know how to export mysql results with static columns to csv, but in some cases i will have to export dynamically without specifying ...
2 months ago

PDO insert statement not executing

MySQL
I have a page called waiting.php this page is the portal to starting a real life session between a counsellor and a student. I have a submit button th...
2 months ago

Getting Illegal string offset Warning while fetching data

MySQL
$cq = "SELECT * FROM salescard WHERE custid = '$custid'"; $rq = mysqli_query($conn,$cq); if ($c = mysqli_fetch_array($rq, MYSQLI_ASSOC)) { $edate =$c...
2 months ago

What is the optimal way of setting up a database for a messaging/email application?

MySQL
I am currently trying to create an email style web app to allow users of my site to contact one another. I have created an SQL table for this, which h...
2 months ago

Server-side functionality depending on whether a user "likes" a Facebook page with PHP/JS SDK's

MySQL
I am trying to execute a mySql database query on my website depending on whether a user has "liked" my Facebook page. I have found a few ways to do th...
3 months ago

How can I create URL that expires after some days php?

MySQL
I am working on a project which need to send a video link to any email. But this video link will expire after 3 days automatically and video url shoul...
3 months ago

Mysql database table id reuse

MySQL
In one of my projects, the current implementation of a log system uses a mysql table. The applications released to customers write some log informatio...
3 months ago

Move inactive rows to another table?

MySQL
I have a table where when a row is created, it will be active for 24 hours with some writes and lots of reads. Then it becomes inactive after 24 hours...
3 months ago

How to make join between 2 tables using 2 values?

MySQL
In Mariadb database I want to make a query to join two tables: joke and jokevote to get all jokes which are upvoted by a certain user. Here are the t...
3 months ago

Cant fill DataSet but MySqlCommand works properly

MySQL
So I am not able to fill a DataSet. I get the following Exception: A network-related or instance-specific error occurred while establishing a co...
3 months ago

Why Banks or Financial Companies prefer Oracle than other RDBMS for their "Core" systems?

MySQL
I'd like to know why most Banks or Financial companies prefer Oracle than other RDBMS for their core systems (the absolutely minimum features that a B...
3 months ago

PHP - mysqli - check the table if a value is already inserted

MySQL
I Am trying to check if the REF number added when creating a new mysql row is already in use. I don't have problems in adding a new row however, the s...
3 months ago

MySQL - Update by using a value from sub query on same table

MySQL
I have a table 'mytable' and it has following structure and sample data. +----+------------+--------------------+ | id | name | password ...
3 months ago

What is the purpose of 'comment' in MySQL?

MySQL
I have found there is the 'comment' keyword in MySQL.(not comment syntax like /* */, #) But I do not know the reason why there is the 'comment' keywo...
3 months ago

Invalid use of groupby function

MySQL
Using MySQl my db looks like this: +-----------------------+--------------------+------+--------+ | moviesInfo | | ...
3 months ago

Recommended number of tables for in a single MYSQL Database

MySQL
Am currently developing an application in Laravel 4. After proper database normalization the required number of tables for my application increased to...
3 months ago

Database organization

MySQL
This isn't much of a coding question as opposed to seeking help on going down the right path. So, I have my users set up with username, password, emai...
2 months ago

Codeigniter Pagination Displaying Too Many Links

MySQL
Using Codeigniter 3 and PHP I have built a web application to display results from a MySQL database. All is working as expected as in the pagination s...
2 months ago

Getting information of registered users

MySQL
I have two php scripts. The first one deals with the registration a user through an android app. Here it is: <?php session_start(); require "init...
2 months ago