I have a question about the Entity Framework.
Here in the company where I work, the tables are generated in the database without any relationship, until the fields that will be foreign keys are created,
the whole relationship is done by EDMX...
I am writing an HTML file with part of a page, to be used later by HTMLDocX in generating a .docx file % (see this question related).
To write ob_start and ob_get_clean use to put the content in a variable:
ob_start();...
My system has a grid with order items coming from the database.
data.
Well, I need to change the order items, add one more item, or even remove.
Get the information in json and put it on the grid.
I can interact in JsonStore...
I have a question about how best to create a table so that every action in a record is saved, thus creating a history of it. I have the following table, but I do not know if it is the best one.
create table sispro_historico_processo (
id_h...
The code below aims to select a database record and save it in a variable for later use of the data:
#!/bin/bash
dbName='basedados'
dbUser='utilizador'
dbPass='password'
row=$(echo "select file_id, file from catalogue__pdf_file WHERE is_conv...
In the site where I work, I use the following query to display in Portuguese the dates that are stored in the database:
$conn->exec("SET lc_time_names = 'pt_PT'");
However, I discovered that the site will become bilingual (Portuguese a...
I'm having trouble inserting input data from a dynamic input. My procedure only inserts once, it follows my code where I get the data:
$ddd = $_POST['ddd'];
$userid = $_POST['userid'];
$idusuario = $_POST['idusuario'];
$telefo...
Assuming the following query where we are selecting values, grouping them and then re-grouping the result:
SELECT
CONCAT (b.label, '|', b.slug)
FROM (
SELECT
group_concat(name SEPARATOR '$') AS label,
group_concat(slug...
I'm working with a database that contains all tickets registered in the otrs of the company where I work.
I want to do a query where I return all tickets that were open in May.
The problem is that a ticket can be opened and closed...
I am studying how best to store some images of users that are registered to my system.
I found 3 ways to resolve this issue: Save to a local directory , Save as BLOB and Save as Base64 .
I would like to know the pros and cons of these...