Skip to main content ↑ ↓

Show Posts

This section allows you to view all Show Posts made by this member. Note that you can only see Show Posts made in areas you currently have access to.

Messages - charchi

1
Suggestions / Re: Report Designer Tools
certainly the Achilles heel of this tool. I have been trying for a long time to start working with this tool, but until it has this characteristic, I don't even consider it. I periodically go in to see if the miracle ever works and I see that in an update they include these very necessary features.
2
Suggestions / report customizer
PHPRad is a way to be a very good tool. But it won't be a useful and really usable tool, until a custom report builder is included. To be able to create an invoice or budget template for example. It is vital that I find no explanation that the application does not yet have it among its characteristics. I follow the tool closely and I am wishing I could use it and take advantage of it, but until I have this feature I will not start using it because it doesn't make sense.

Greetings and thank you.
4
Questions / Re: database connection for query sql
Hello, thanks for answering. Well the question is a little generic because I will need to do many sporadic queries to complete features that phprad does not have by default. For example a serious one, adding a button to sort the records to each record I will assign a manual code to it, I want that if I delete a code by clicking on that button, I will reorder all the records, for example if I have 1 2 3 and delete the 2 then 3 becomes 2 and so on. I have the query to do it and it works fine in fact, but as I commented in my problem I have to create the connection to the database before writing the query in the page php file.

Another thing I need to do is when I delete a record that is deleted from that table but before it is copied to another table that I will call casualties rather than a deletion would be to move a record from one table to another.

Surely throughout my development I will need to do more things that phprad does not include by default, so I want to know how I can execute sql queries without previously creating the connection to the database, if not use the one that already has the default.

Greetings and thank you.
5
Questions / database connection for query sql

Hello everyone, I am very new to phprad and there is a question that I cannot clear.
How can I launch custom sql queries without first connecting to the database. For example:

If I launch a sql query like I would be:

$sql = mysqli_query ($mysqli, "SELECT * FROM table");

but in doing so, it tells me that I have no connection to the database. first you would have to create a connection with:

$mysqli = new mysqli ("localhost", "root", "", "database_bd");

to make it work. This is a problem, because when deploying the project on another server with a different ip / DB, it would be necessary to change the connections in all the files where there were custom queries.

How would you do it in phprad so that when launching the custom query it would use the existing connection to the database?

Greetings and thank you.
6
Questions / Re: disable cascade delete

Thanks for your answer. I think I remember reading something you are talking about, but I really don't know how it works. See if someone who has had the opportunity to use this option answers and can explain a bit how to do it. Thank you
7
Questions / disable cascade delete
Hello everyone, I have a question that I cannot solve and that is to avoid cascade deletion. I have 2 tables related by their id which are the customer table and the invoices table. I would like to delete 1 customer not delete the invoices. Does anyone know how it can be disabled?

Greetings and thank you.