Note that you can also output JSON data by using the ExecuteJSON($sql). Including the relevant PHPMaker scripts and initializing them: ExecuteHTML($sql) // Execute a SQL and show as HTML table ?>Īnd then writing your SQL Queries to output the data as the above example demonstrates. Once that’s done then you can integrate your external application with the PHPMaker application by:

First off you need to generate your PHP Project. This uses principals from the custom php file feature of PHPMaker. Here’s a basic tutorial on integrating you PHP app with PHPMaker. PHPMaker 2023 - The Best PHP Code Generator Support Registered users are entitled to 6 months free email support. In Phpmaker it doesn't work.PHPMaker Tutorial: Integrating external PHP with PHPMaker and then use $r1 to get the information from the database. $res = mysqli_query($connection, $ReadSql) Field level filter Click 'Products' and then click the 'Filter' icon next to 'Product Name'. I used to do them as follow on simple php: Click 'Orders', then click the 'Query Builder' button on top. I don't want to get ExecuteHtml but i just need to have all fields of the database based on the query and use them on the custom file design and structure. Using PHPMaker you can instantly create web sites that allow users to view, edit, search, add and delete records on the web. I have read probably mos of the threads in here but seems that I am missing something and I can't do what I want. PHPMaker is a powerful automation tool that can generate a full set of PHP scripts quickly from MySQL, PostgreSQL, Microsoft SQL Server, Oracle and SQLite databases. Now I don't know how to fetch the results. $sql='SELECT * FROM fatura, artikuj, brande, fatura_artikuj, klient, kursikembimit, monedha, transportues, tvsh, njesi Code: Select all $db = &DbHelper() // Create instance of the database helper class by DbHelper() (for main database) or DbHelper('') (for linked databases) where is database variable name

Phpmaker database helper