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 - BakermanDK

1
Questions / master/Details- details table - manipulate return page when adding or deleting
Hi

I have this viewpage for the record from the recipe table
then i have another table recipe_ingrediens that i have included as a master data relation to recipe table

When displaying the details for a record from recipe, then i want to be able to add/delete elements to the recipe_ingrediens table seamlessly, so that the user will stay on the viewpage for the detailed recipe record.

Any smart way of accomplishing this?

If anyone can teach me how to do this, and perhaps a few other things - i am open to pay a little for your service
2
Questions / Automatic view of details table
I have a master/data relation on a viewpage. PHPRad autogenerates the chosen field to be a button that toggles the detail list.

I just want the detail list to be shown all the time, with no toggle option.

How to?
4
Questions / SQLSTATE[42000]: Syntax error or access violation: 1066 Not unique table/alias:
Hello,

I am trying to make a master/detail relation - but it fails with below error - how can i troubleshoot?

SQLSTATE[42000]: Syntax error or access violation: 1066 Not unique table/alias: 'recipe_ingrediens'

File
C:\wamp64\www\chocobase2\app\models\PDODb.php On Line 1045

Stack Trace
1 C:\wamp64\www\chocobase2\app\models\PDODb.php(1045): PDOStatement->execute()
2 C:\wamp64\www\chocobase2\app\models\PDODb.php(1079): PDODb->get('choco_recipe', 1, Array)
3 C:\wamp64\www\chocobase2\app\controllers\Choco_recipeController.php(117): PDODb->getOne('choco_recipe', Array)
4 C:\wamp64\www\chocobase2\system\Router.php(196): Choco_recipeController->view('1')
5 C:\wamp64\www\chocobase2\system\Router.php(109): Router->run('choco_recipe/view/1')
6 C:\wamp64\www\chocobase2\index.php(106): Router->init()
5
Questions / Session variables as values to hidden fields
Hi all

Forgive me my noobness.... I'm still learning, and have started development of a small chocolate production database.

For this i have created a multi user database app, where users can register some common things, as well as some individual things like what molds they have in their personal stock.

For that i have created tables for all personal things, and having a field for user_id in these tables.
When i create my formular for the molds add page, i have a hidden field where i want the session user_id to be the value.

But it doesnt seem to work.

How would you approach this