Search Results for "sql server query builder"

Advanced data tables using Laravel, Livewire, Tailwind CSS, and Alpine JS. It is possible to take full control over your table, you can define a builder method using whatever query you like, using your own joins, groups, etc., and then name your columns using your normal SQL syntax. If you want to give your users the ability to pin specific records to be able to, for example, compare them with each other, you can use the CanPinRecords trait. Ensure to have at least one Checkbox Column so the user can select records.

Please watch the video till 18m:00s / screenshots below for easy installation steps. This video is taken from my other project, with many similarities and some naming differences. After installation, login to the Administrator Page with : Username : root Password : change_this and look at the team1 database and the sample_table in it, from all aspects. You can now create your own tables/forms. Also, login into the team1 user page ( from homepage ) with : Username : team1...

This is a component to create dinamic database queries from a check list view. You can set a db object (views/tables/etc) to select columns to be shown in the main checklist to build a query based in the check selection. Add dinamic (sql) or static HTML selects to filter results through wheres with few lines. Create dinamic XLSX reports easily (XLSXWritter)

PBL (aka PHP Bug lost) is a simple one-file script for use in any php websites that offers a console for debug and monitoring on your broser. It's based on FirePHP and PHP Quick Profiler. You can send log messages to the console, view SQL Querys, memory usage, list of user and server vars, files included, automatic detection of ajax request (like FireBug)... etc. Also PBL can send emails to the admin when a sql query fail or the app are using more memory or time that allowed. You can configure this. PBL don't have dependencies. It automatically generate all the HTML, JS and CSS code for show the console on your browser.

akLib - small lib for PHP. Project moved here https://github.com/azat/akLib!

Github repository: https://github.com/miguelaxcar/PHP-MSSQL-Server-Admin Web based tool written in PHP by Luiz Miguel Axcar to build and run queries on a remote or local MSSQL (Microsoft SQL Server). Support for SQL code highlight (!), table browser, field browser, TOP records, most used tables, CSV results export, etc. Most tested in SQL 2000 version. If you find some issue ther let me know and I help you fixing it.