PHP - MySQL
-
» Marius I am trying to write a Regular Expression that makes sure the characters are all Alpha Numeric, and that accepts other characters as well. I would...
Last post » MarPlo Hi,
Your regex ^ *$ won't match the accented characters. That is \w would match only the English alphabets, digits 0-9 plus the underscore symbol....
-
» Marius I facing a problem about a select query in MySQL.
I have table user, It contains id_user, username and user_time. And user_time is a Date-Time for...
Last post » Admin Hi,
YEAR returns a number like 2015. That will never be equal to a time. You need to test whether the year of user_time is the same as the given...
-
» Marius I have a table with the following columns: id | url | title | company .
Now, I need to delete rows having same url and title.
I want to know if...
Last post » Admin An easy way to do this is to add a UNIQUE index on the columns with duplicate values, using the ALTER statement.
When you write the ALTER statement,...
-
» Marius I have SQL a query like this:
SELECT c.type, SUM( u.account )
FROM contracts c, u_data u
WHERE c.user_id = u.id
GROUP BY c.type;
Now this gives me...
Last post » Admin Hi,
You just have the wrong order for GROUP BY and ORDER BY.
ORDER BY should be added after GROUP BY.
...
GROUP BY c.type;
ORDER BY FIELD( c.type,...
-
» Marius Hi
I have an array in php:
$arr = array(3, 'value 1', 'other value');
And a mysql table with these columns: id | name | data
I want to store...
Last post » Admin Hi
You can store an array in a database into a string with JSON format.
Use json_encode() when you want to insert the array. For example:...
-
» Marius I'm trying to SELECT from a PHP array inside a mysql query.
$sql = SELECT * FROM table WHERE id = $ids ;
$ids has been created by $_POST and...
Last post » Admin Try with IN with implode of the array $id like:
$sql = SELECT * FROM table WHERE id IN ( . implode(',', $ids) . ) ;
- Make sure that $ids is an...
-
» Marius I've written following code to compare a date in a variable with today's date. If the date in a variable is greater than today's date the error...
Last post » Admin You may be meaning 11th Decemeber with 12-11-2014, but strtotime isn't seeing it that way.
If you need to use strtotime() then change the input...
-
» Marius Hello,
I have two tables: A and B. I need to compare their columns to get values of one table that are not in other table.
Table A columns : ID,...
Last post » Admin Hi,
You can use not in :
SELECT *
FROM table_A
WHERE table_id NOT IN (SELECT id from table_B)
-
» Marius I have a subscription system in my website. When the users subscribe, their start date and time is added in mysql table using now() function.
I also...
Last post » Admin The date_add() function is what you're looking for:
DATE_ADD(date,INTERVAL expr unit)
Example
INSERT INTO users
(username, registration_date,...
-
» Marius While executing an INSERT statement with many rows, I want to skip duplicate entries that would otherwise cause failure. After some research, my...
Last post » Admin Hi,
If you just want to skip rows with duplicate values, and no update needed, I think that is proper to use INSERT IGNORE .
If you use INSERT...
-
» Marius Hello,
I have this Select query, I want to select one row from mysql table, where id = $id, and has x_name or y_name 'yes'.
$insert_cat =...
Last post » Admin Hi
The problem is that you didn't separate the conditions with the OR from the id=$id, so to select just the row which has that $id AND 'yes' in any...
-
» Marius Hi
I have this array, and I want to return it as JSON from a PHP script.
$ar = array(
'k0'=> array('a', 'b', 'c'),
'k1'=> array(1, 2, 3)
);...
Last post » MarPlo Hi,
Use json_encode() to encode the data and set the content-type with header('Content-type: application/json');
Anyway, it works fine if you just...
-
» Marius Hi
I have two arrays $a1 and $a2 with various elements.
How can I check which item from $a2 is in $a1? Is there any function, or I have to traverse...
Last post » Admin Hi,
The array_intersect($a2, $a1) function returns the elements of $a2 which are found in $a1.
Also, with the in_array() function you can check if...
-
» Marius I have 2 tables with same column names in my database which are supposed to provide content in 2 languages.
This is how I query for one table (this...
Last post » MarPlo The mysql is confused when you select columns with same name. The solution is to use Alias ( AS ).
$sql = SELECT en.col1 AS c1en, en.col2 AS c2en,...
-
» Marius Hi
Does anyone has a php code to display the elapsed time?
Like: one hour ago, 1 day and 3 hours ago, ...
Thank you.
Last post » Admin Hi
You can use the timeElapsed() function, from this example:
function timeElapsed($t1, $t2 = null) {
/*...
-
» Marius Why in my database, time is of type Timestamp but has no numeric form: 1402008961, but is of the form: 07/25/2014 12:13:45 ?
Last post » MarPlo Hello
Timestamp in MySQL is different from Unix Timestamp, which as you know is a number of seconds starting from 1970.
Timestamp in MySQL is...
Forum permissions
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum