It's not the same without you
Join the community to find out what other Atlassian users are discussing, debating and creating.
I am trying to display results from a MySQL query to the JIRA Database using an HTML macro. The script I put in looked like it should work, however, it doesn't show anything. The page is completely blank. What am i doing wrong?
<script> <?php $con=mysqli_connect("example.com","user","pass","database"); // Check connection if (mysqli_connect_errno()) { echo "Failed to connect to MySQL: " . mysqli_connect_error(); } $result = mysqli_query($con,"SELECT * FROM cwd_user"); echo "<table border='1'> <tr> <th>Firstname</th> <th>Lastname</th> </tr>"; while($row = mysqli_fetch_array($result)) { echo "<tr>"; echo "<td>" . $row['first_name'] . "</td>"; echo "<td>" . $row['last_name'] . "</td>"; echo "</tr>"; } echo "</table>"; mysqli_close($con); ?> </script>
Hi Cole,
as far as I know, you are not able to write php-code within a macro. Maybe you have a look on this add-on?
https://marketplace.atlassian.com/plugins/de.scandio.confluence.plugins.pocketquery/server/pricing
Cheers,
Julian
PHP is a server side language. HTML is client side. You can only put HTML into the HTML macro. If you want to display the results of a SQL query on a Confluence page you should look into a SQL add-on from the marketplace. Another option would be to host your PHP elsewhere and then in the HTML macro do an AJAX call to the PHP page and insert the data into the Confluence page. Confluence has jQuery, so it wouldn't be too hard to setup the AJAX.
Unfortunately, I am unable to purchase any add-ons. I will look into your other suggestion, but I am not too sure how to execute it. I wish it were easier to pull data from the JIRA database.
This community is celebrating its one-year anniversary and Atlassian co-founder Mike Cannon-Brookes has all the feels.
Read moreTo anyone who doubts that Atlassians are a little too obsessed with collaboration, and tools related thereto, let me describe a recent discussion we had (which took place on our internal Confluence, ...
Connect with like-minded Atlassian users at free events near you!
Find a groupConnect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.
Start an AUGYou're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.