there is also now a global/static
Route class that acts like a custom service container of the router object for the application. With that, anywhere in the application you can do this:
(this works with arrays or objects)
$nick = new stdClass();
$nick->name = 'nick';
$jim = new stdClass();
$jim->name = 'jim';
$world = new stdClass();
$world->name = 'world';
$names = [$nick, $jim, $world];
foreach ($names as $name) {
echo '<a href="' . Route::url('hello', $name) . '">' . $name['name'] . '</a>';
}
and that should generate:
<a href="/hello/nick">nick</a>
<a href="/hello/jim">jim</a>
<a href="/hello/world">world</a>
Relationships now support nested/child relationships via a dot notation:
$user = Users::with('posts.comments')->getById(1001);
you can read more about it under the docs here (under Eager-loading) https://pop-php-framework.readthedocs.io/en/latest/user_guide/databases.html#relationships-associations
this is available in
pop-db v5.2.0
use Pop\Pdf\Pdf;
use Pop\Pdf\Document;
use Pop\Pdf\Document\Font;
use Pop\Pdf\Document\Page;
// Create text object
$string = 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Integer nec ligula ligula. Cras at dictum nibh. Nulla pulvinar accumsan arcu vitae vulputate. Cras pretium libero sit amet lobortis sagittis. Aliquam interdum vitae eros ut porttitor. Sed maximus purus vitae metus euismod imperdiet. Aliquam varius ultrices augue ut consequat. Aliquam feugiat ipsum eleifend ipsum vulputate feugiat. In posuere velit id magna porta viverra. Morbi diam mauris, porta eget felis ac, tincidunt malesuada dui. Donec vel urna id elit egestas vestibulum eget ac erat.';
$text = new Page\Text($string, 12);
// Add bounding alignment object
$text->setAlignment(Page\Text\Alignment::createCenter(50, 562, 15));
// Create a page and add the text to it
$page = new Page(Page::LETTER);
$page->addText($text, Font::ARIAL, 50, 650);
// Create a document, add the font to it and then the page
$document = new Document();
$document->addFont(new Font(Font::ARIAL));
$document->addPage($page);
// Pass the document to the Pdf object to build it and output it to HTTP
$pdf = new Pdf();
$pdf->outputToHttp($document);
so the 3 params for the following line of code:
$text->setAlignment(Page\Text\Alignment::createCenter(50, 562, 15));
are
$leftX, $rightX, and $leading
and those set the left and right bounds for the string of text to be contained and centered in.
That's the PDF that was created with that code sample. Let me know if that helps.
FYI, if interested, there's also some experimental DOM/HTML rendering features in Pop PDF as well, but that needs a bit of work to be finished off (namely, I left off working on rendering tables)
And lastly (I think).... what happened to the direct download of the latest versions of Pop PHP Framework? The website references links...but I cannot find a full-source download anywhere.
so to answer the first question, there is nothing directly available for controlling headers/footers in Pop PDF at this time. It's something that could be considered, if kept pretty simple. But the main concern would be that it's something like that would be fairly specific/custom to the PDF you're looking to generate. I've handled it in my own applications by writing a little helper method that would generate all of the header and footer content formatted exactly as I need it to be. But they were fairly complex headers and footers with multiple lines of text, page numbers, images, etc.
And your second question is that, the decision was made about a year ago or so to no longer support or provide to direct download option. It was just one more thing to manage and the stats showed just about everyone using composer these days, so it seemed like a good time to do away with it. Using composer should be the preferred way to get Pop and/or any of its supporting components.
Sorry for the confusion there.
Hi - sure, you can just use the database adapter directly, via basic queries or prepared statements with bound parameters. Check out the docs here: https://pop-php-framework.readthedocs.io/en/latest/user_guide/databases.html#querying-a-database
Hi - sure, you can just use the database adapter directly, via basic queries or prepared statements with bound parameters. Check out the docs here: https://pop-php-framework.readthedocs.io/en/latest/user_guide/databases.html#querying-a-database
Thanks Nick, but is there a way to avoid doing this:
$db = Pop\Db\Db::connect('mysql', $options);I mean, a way to get the default database configuration instead of setting a config here
$application->services()->set('database', [
'call' => 'Pop\Db\Db::connect',
'params' => [
'adapter' => 'mysql',
'options' => $options
]
]);
and then anywhere in your application you can access the DB service like:
$db = $application->services['database'];@nicksagona
well a typical way to go is set the database as a service within the application. Have it wired up one time at the beginning of the app's lifecycle and then call that DB service as you need it. For example, you could have something like:
Ok, agreed...sorry for my insistence, but for example in app\src\Module.php there is:
public function register(Application $application)
{
parent::register($application);
if (isset($this->application->config['database'])) {
$this->initDb($this->application->config['database']);
}
if (null !== $this->application->router()) {
$this->application->router()->addControllerParams(
'*', [
'application' => $this->application,
'request' => new Request(),
'response' => new Response()
]
);
}
return $this;
}I noticed:
$this->application->config['database']is there a way to use something like this in my model?
If you have a DB service registered with the application, you can also access it globally via the static service container class.
Also, the benefit of using the DB Record class, is the DB adapter is registered statically with the Record class and is available globally. Plus the Record class abstracts away a lot of common SQL functionality
via the Active Record pattern (with a little bit of Table Gateway)
well the model would have to be application-aware in order to access that. Either by passing the app object into the model's constructor, or into the method you're calling on the model.
Ok okay, in my case I need to do a complex query with joins to three MySQL VIEWs, which have no ID field. This Active Record implementation I don't think will allow me to do it with the query builder.