marco
5a2482b030
Major version upgrade from 1.0.0 to 2.0.0 including copyright year updates, website URL migration to syspanel.com.br, and comprehensive CSRF token handling improvements. The Twig csrf() helper now returns a complete hidden input field instead of a raw token value, and token generation is now automatic when empty. Session initialization has been centralized in BaseController, and child controllers now properly call parent constructors. CRUD views have been modernized with flexbox layouts and consistent CSRF rendering. Documentation has been expanded with features, requirements, and project structure sections, and donation sections have been added across all pages.
70 lines
2.0 KiB
Plaintext
70 lines
2.0 KiB
Plaintext
<?php $_shouldextend[1]=1; ?>
|
|
|
|
<?php $this->startSection('title', 'Database Usage'); ?>
|
|
|
|
<?php $this->startSection('content'); ?>
|
|
<div class="container mt-5">
|
|
<h1 class="display-4 text-primary">Database Usage</h1>
|
|
<p class="lead">CRUD Example with SysMVC.</p>
|
|
|
|
<p>SysMVC makes it easy to interact with databases through the use of Eloquent ORM. You can easily create, read, update, and delete records in the database using intuitive methods.</p>
|
|
|
|
<h2>CRUD Example</h2>
|
|
<p>Below is a basic example of CRUD operations:</p>
|
|
|
|
<h3>Creating a Record</h3>
|
|
<pre><code>
|
|
$client = new Client();
|
|
$client->name = 'Client Name';
|
|
$client->email = 'email@example.com';
|
|
$client->save();
|
|
</code></pre>
|
|
|
|
<h3>Reading Records</h3>
|
|
<pre><code>
|
|
$clients = Client::all();
|
|
foreach ($clients as $client) {
|
|
echo $client->name;
|
|
}
|
|
</code></pre>
|
|
|
|
<h3>Updating a Record</h3>
|
|
<pre><code>
|
|
$client = Client::find(1);
|
|
$client->name = 'New Name';
|
|
$client->save();
|
|
</code></pre>
|
|
|
|
<h3>Deleting a Record</h3>
|
|
<pre><code>
|
|
$client = Client::find(1);
|
|
$client->delete();
|
|
</code></pre>
|
|
|
|
<p>With these examples, you can see how easy it is to work with databases using SysMVC.</p>
|
|
<br><br>
|
|
|
|
<p>Github: <a href="https://github.com/syspanel/SysMVC.git">https://github.com/syspanel/SysMVC.git</a></p>
|
|
|
|
<br><br>
|
|
|
|
<h2 class="mt-4">Contact</h2>
|
|
<p>If you're interested in SysMVC, get in touch:</p>
|
|
<ul>
|
|
<li>Email: <a href="mailto:syspanel@gmx.com">syspanel@gmx.com</a></li>
|
|
<li>WhatsApp: <a href="https://wa.me/5535992261684" target="_blank">+55 (35) 99226-1684</a></li>
|
|
</ul>
|
|
|
|
<hr class="my-5">
|
|
|
|
<h2 class="mt-4">🙎 Support the Project</h2>
|
|
<p>If you find this project useful, consider supporting its development with a donation via PayPal:</p>
|
|
<p>
|
|
<a href="https://www.paypal.com/donate/?business=marcocosta@gmx.com¤cy_code=USD" target="_blank">
|
|
<img src="https://www.paypalobjects.com/en_US/i/btn/btn_donate_LG.gif" alt="Donate via PayPal">
|
|
</a>
|
|
</p>
|
|
</div>
|
|
<?php $this->stopSection(); ?>
|
|
|
|
<?php if (isset($_shouldextend[1])) { echo $this->runChild('layout'); } ?> |