Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>If you have a template file that is parsed where you can output PHP->Smarty assigned variables, something you could do is create a global JS variable in the template, and then use that global variable within your JS as normal.</p> <p>Such as:</p> <p><strong>Template file</strong></p> <pre><code>&lt;script type="text/javascript"&gt; var MyGlobalVar = "{$MyGlobalVar}"; &lt;/script&gt; </code></pre> <p><strong>Global.js file</strong></p> <pre><code>$(document).ready(function(){ $("button").click(function(){ if (MyGlobalVar != '') { $("#div1").html(MyGlobalVar); } else { alert('Error! Error! Abort!'); } }); }); </code></pre> <p>Note, you could output the Global.js file with it being parsed by Smarty (although... this is probably not a great idea) and inject your PHP->Smarty variables this way. This would treat the Global.js included file as a Smarty template. </p> <p>To do so, you would need to use <a href="http://www.smarty.net/docsv2/en/language.function.literal" rel="nofollow noreferrer"><code>{literal}</code></a>, probably name the file with a .php file ending (so it was PHP-parseable), and add a PHP <code>header()</code> call so PHP outputs the file contents to the browser as a Javascript content-type.</p> <p><strong>Global.js</strong></p> <pre><code>&lt;?php header("content-type: text/javascript"); ?&gt; var MyGlobalVar = "{$MyGlobalVar}"; {literal} $(document).ready(function(){ $("button").click(function(){ if (MyGlobalVar != '') { $("#div1").html(MyGlobalVar); } else { alert('Error! Error! Abort!'); } }); }); {/literal} </code></pre> <p>Additionally, on the PHP side, you might want to consider adding slashes to your variable, especially if the JS variable will contain html or other bits of text that will use single/double quotes.</p>
    singulars
    1. This table or related slice is empty.
    1. POUsing smarty variable within a jQuery Function
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USJared Farrish
    1. USJared Farrish
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POUsing smarty variable within a jQuery Function
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COThat works like a CHARM! Very impressive. So my understanding is, if you want to use a smarty variable in JS, you have to pass it to a JS variable on the TPL page while the tpl is being parsed. I am now exploring passing it as a parameter, 'coz i dont like global variable
      singulars
      1. PO
      1. USWilliam Sham
    2. COYes, a Smarty variable is essentially no different from a PHP variable (Smarty compiles to PHP, for instance). All you need is some page to be parsed by your Smarty parser. Also, if this answers your question, please click the outlined arrow next to the question and below the vote count to accept it as the answer. :)
      singulars
      1. PO
      1. USJared Farrish
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload