Hi all! Need help. I need to show in one field in the "Site form" value from the database. I love SQL. But I don't know PHP syntax. You will help me, if you show me an example of using "Core 42". 1. Displaying values from a custom database table. 2. Use in a SQL query the values from the form fields ("SELECT n1 FROM table1 WHERE n2 = user_input_value"). 3.
Special case. The Content Type contains a date in format "YYYY-mm-dd"
(this field is already filled in "Site form"). I have to ask the
database: "Dear MySQL, please show me what was in 'YYYY' year! Much
obliged." And also thank you! (Joomla and Seblod latest version)
Thank you for responding! My site will be a service for reporting. The user sends me the information. Every day. The form I already have. Left to do something: The user enters data on the amount of milk production. On the page the user sees: "My milk behind schedule!". How to do it: • Table "a" contains information about milk, added by the user (The content of the table: username, date reporting period, report data). • Table "b" contains a plan in 2015 year for each user. During data entry, as well as when you view the article, data from tables "a" and "b" are shown together.
I'm sorry. The task is simple, but I am not able to explain properly. Table "a" is a seblod article. But let's leave it all. I want a full example of the output values from the database using sql in core 42. Examples on the forum, but the descriptions given are not completely. This is what I found:
05_p_sowed_total — name field in Content type. sowed_total — name field in database. #__svod_plan05 — name database. PrepareContent and PrepareStore is emty.
The answer to question 2. Insert values from other form fields looks like this:
$value = $cck->renderField('fieldName'); The answer to question 3. It's just. In CT to create another calendar with the format "YYYY". Or something like that.
S. I know SQL, css/html, delphi, regexp and other such nonsense. I
created a simple Joomla!-sites since 2007. But I have almost no knowledge of php.
The Seblod project need a good manual.
Hi all! Did it!
I must in the "core 42" use "live value"->"Profile-Adv":
this magic to give the value from the DB, from table advanced profile.
For my task, it's good. (42 outputs the values from the database in accordance with the address of residence of the current user)
This solution was already on the forum, I saw him, but did not understand: