Echo toolbar button names via PHP

Of course, it’s possible to have a single call. For instance, for 3 buttons:
Code: 
procedure ProcedureAll(text, text2, text3: String);
begin
SetUiProp(“Toolbar1BHome”, “Caption”,text);
SetUiProp(“Toolbar1bprint”, “Caption”,text2);
  // and so on
end;
Then in PHP:
exo_runhescriptcom ("UserMain.ProcedureAll|$button1|$button2|$button3");
 
oldteacher said:
Another related question, please…

Is it possible to also link the button to url and have open in users default browser using scripting?

Using this on modal popup and would like to use in scripting if at all possible:

<a href=“heexternal://<?php echo $row[‘supporturl’];?>”><?php echo $row[‘supporttext’];?></a></p>

Sorry for all the scripting questions, just cannot seem to grasp…
Click to expand...
Gilmichel said:
But I really need to pull data from my sqlite database.

Can you publish sqlite path and table content ?

Gilbert
Click to expand...
Thanks for reply @Gilmichel and @gdgsupport

The path to sqlite database is:

$database_name = $_SERVER['DOCUMENT_ROOT'].'/general.db';

The table contents are simple BLOBS:

("CREATE TABLE IF NOT EXISTS misc (contacturl BLOB, supporturl BLOB, supporttext BLOB, abouttext BLOB)");

("INSERT INTO misc (contacturl,supporturl,supporttext,abouttext) VALUES ('http://example.com','http://example.com/support/','Help Desk','About Us')");

Nothing advanced, simply like to echo URL to custom button created with scripting and do so with the heexteranl:// option.
 
heexternal:// should do its job if you give a correct URL… Try to inspect the HTML code output by your PHP page using the Chromium Developer Tools: verify that the
<a href=“heexternal://<?php echo $row[‘supporturl’];?>”><?php echo $row[‘supporttext’];?></a></p>
is correctly output.
 
gdgsupport said:
heexternal:// should do its job if you give a correct URL… Try to inspect the HTML code output by your PHP page using the Chromium Developer Tools: verify that the

<a href=“heexternal://<?php echo $row[‘supporturl’];?>”><?php echo $row[‘supporttext’];?></a></p>

is correctly output.
Click to expand...
Yes, I understand how to use the heexternal and php. Asking this:

Is it possible to also link the button to url and have open in users default browser using hescripting?

Have the button working with custom text, now like to link it to external site and open in users default browser. The question is can this be done in hescript?
 
oldteacher said:
Thanks for reply @Gilmichel and @gdgsupport

The path to sqlite database is:

$database_name = $_SERVER[‘DOCUMENT_ROOT’].‘/general.db’;

The table contents are simple BLOBS:

(“CREATE TABLE IF NOT EXISTS misc (contacturl BLOB, supporturl BLOB, supporttext BLOB, abouttext BLOB)”);

(“INSERT INTO misc (contacturl,supporturl,supporttext,abouttext) VALUES (‘http://example.com’,‘http://example.com/support/','Help Desk’,‘About Us’)”);

Nothing advanced, simply like to echo URL to custom button created with scripting and do so with the heexteranl:// option.
Click to expand...
To create and verify your database with php, you can do the following :
$database_name = $_SERVER[‘DOCUMENT_ROOT’].‘/general.db’;
if(!file_exists($database_name)){
$db = new SQLite3($database_name);
$set = “”;
$set .=‘PRAGMA foreign_keys = ON;’;
$set .=‘PRAGMA encoding = UTF-8;’;
file_put_contents($set, $database_name) ;
$result = $db->exec(“CREATE TABLE IF NOT EXISTS misc(
contacturl TEXT,
supporturl TEXT,
supporttext TEXT,
abouttext TEXT
)”);
$result = $db->exec(“INSERT INTO misc (contacturl,supporturl,supporttext,abouttext)
VALUES (‘http://example.com’,‘http://example.com/support/','Help Desk’,‘About Us’)”);
$db->close();
}
$db = new SQLite3($database_name);
$result = $db->query(‘SELECT * FROM misc’);
while ($row = $result->fetchArray()) {
foreach($row as $k => $v){
echo <pre>.$k ." = ". $v.</pre>;
}
}
$db->close();
Click to expand...
Then to echo url do like follow
$db = new SQLite3($database_name);
$result = $db->query(‘SELECT * FROM misc’);
while ($row = $result->fetchArray()) {
$contacturl = $row[‘contacturl’];
$supporturl = $row[‘supporturl’];
}
$db->close();
echo $contacturl;
echo $supporturl;
Click to expand...
 
Last edited:
Hello,

Is it possible to do the same replacement with image, button color, background color and more like we can do it with caption’s text on buttons ?

Thank-you !
 
Last edited:
Gilmichel said:
Is it possible to do the same replacement with image, button color, background color and more like we can do it with caption’s text on buttons ?
Click to expand...
One solution, for icon image change on button :
procedure PImage(text: String);
begin
SetUiProp(“Ribbon1BHome”, “ImageIndex”, text);
end;
Click to expand...
Then :
echo exo_runhescriptcom(‘UserMain.PImage|0’,‘’);
Click to expand...
If you change 0 for 1 see the effect when testing your app.
 
Last edited:
Gilmichel said:
If you change 0 for 1 see the effect when testing your app.
Click to expand...
Now, what i am trying to do is to replace a TImage (in toolbar) with one locate in Data’s folder, is it possible ?

Example :
procedure PLogo(text: String);
begin
SetUiProp(“Ribbon1Logo”, “Picture”, text);
end;
Click to expand...
Then:
$img = ‘src image path>’;
echo exo_runhescriptcom(‘LangMain.PLogo|$img’,‘’);
Click to expand...
It is not replacing the picture that way !
 
Last edited:
oldteacher said:
Now if I could just make a button URL changeable and target the users default browser…
Click to expand...
This you should be able to create it when you setup action for your button.
First create an hescript procedure, and then configure your button action using hescript to choose the one you just created:

Hescript:
procedure LoadURL;
begin
ExecuteHTMLScript(“loadurl()”, “JavaScript”);
end;
Click to expand...
In your principal .php page add the following
<?php
$url = “your url”;
?>
Click to expand...
Then add this javascript:
<script>
function loadurl() {
window.location=“heexternal://<?php echo $url; ?>”
}
</script>
Click to expand...
 
Last edited:
Gilmichel said:
Hescript:

procedure LoadURL;

begin

ExecuteHTMLScript(“loadurl()”, “JavaScript”);

end;

In your principal .php page add the following

<?php

$url = “your url”;

?>

Then add this javascript:

<script>

function loadurl() {

window.location=“heexternal://<?php echo $url; ?>”

}

</script>
Click to expand...
Brilliant @Gilmichel ! I will give this a try later and let you know. Appreciate you sharing the knowledge.
 
@Gilmichel Could not wait and had to try adding url to toolbar button…

Cannot get past the error PHP Error: PHP Parse error: syntax error, unexpected ‘heexternal’ (T_STRING)

Script is in footer so not sure why of error like above. Will have to wait until later to test further, got to go to church: )

EDIT: Above issue was due to copy and paste from forum, strange characters caused error.

But not working, error in dev console says loadurl is not defined.
 
Last edited:
gdgsupport said:
Try to move it to header of your HTML page
Click to expand...
I had tried that (sorry should have mentioned) and still get loadurl is not defined.

Currently have the $url = "http://google.com"; at very top of page and script in header but no go.
 
oldteacher said:
I had tried that (sorry should have mentioned) and still get loadurl is not defined.
Click to expand...
Can you show how do you write the javascript function concerned ?

Also, try to copy paste, before to use it in your script, in notepad the code I have showed you and then, in notepad, replace the double quote if necessary. Then copy the code from notepad and paste it in your script.
And don’t forget to use https and not http for your url !
 
Last edited:
Thanks for response @Gilmichel

I have added the code as you provided:
Code: 
Added Hescript:

    procedure LoadURL;
    begin
    ExecuteHTMLScript("loadurl()", "JavaScript");
    end;

At the very top of my page (before everything else):

    <?php
    $url = "http://google.com";
    ?>

In my header:

    
    function loadurl() {
    window.location="heexternal://<?php echo $url; ?>"
    }
Had to remove the scrip tags as forum now forbids and shows 403 error popup, but the opening and closing tags are in place.
Gilmichel said:
Also, try to copy paste, before to use it in your script, in notepad the code I have showed you and then, in notepad, replace the double quote if necessary. Then copy the code from notepad and paste it in your script.

And don’t forget to use https and not http for your url !
Click to expand...
Not sure how https for URL would help to solve the undefined loadurl() issue, but tried it to be sure and no change. Still get the loadurl() undefined error when clicking the toolbar button.

EDIT UPDATE: As usual, my problem your code works fine… Somehow the function loadurl() in script got converted to function loadUrl(). Guessing plugin for my notepad++ auto assumed I want the capital U. Sorry for the hassle and thank you very much @Gilmichel !
 
Last edited:
oldteacher said:
function loadurl() {
window.location=“heexternal://<?php echo $url; ?>”
}
Click to expand...
Javascript function must be set between two folowing tags :
<script>

</script>
 
Last edited:
Gilmichel said:
Javascript function must be set between two folowing tags :

<script>

</script>
Click to expand...
Yes, I got that. Think you missed:
oldteacher said:
Had to remove the scrip tags as forum now forbids and shows 403 error popup, but the opening and closing tags are in place.
Click to expand...
@gdgsupport Is it a security risk to allow script tags wrapped in the preformatted feature? Only way to prevent foreign characters best I can tell.

Anyway, got it working as described above. Use notepad++ and one of the plugins converted function loadUrl() to function loadUrl() (notice the capital U). All good and appreciate your help much.
 
Last edited:
You must log in or register to reply here.
Back
Top