Its possible to connect Gantt with MYSQL (Phpmyadmin) ??

Gantt
#1

Hello, im having lot of issues for connect the database through MYSQL using Phpmyadmin.

Im trying to create a plugin that connects Gantt with a custom plataform that its not the ordinary CMS.

So im farly limited on that aspect.

This is what im trying to do (not experienced in phpmyadmin) so this is the thing:

[code]function(instance, context) {
var div;

div = $(‘

id=“tester”
’);
div.css(“width”, “100%”);
div.css(“height”, “100%”);
div.css(“cursor”, “pointer”);

gantt.init(“tester”, new Date(2018, 01, 01), new Date(2018, 12, 31));
gantt.load(“https://qzf818.xxxxxxx.com/db_structure.php?server=1&db=qzf818&token=b634991337af81f1653735bdbff71a8b”);

instance.canvas.append(div);
instance.data.div = div;

}[/code]

Im trying to load from the url directly but its not working. I dont know how to connect that mysql database to the page.

Any help will be appeciated.
Many thanks!

#2

Hello sorry for replying this thread i update the code:

I have to upload the files to // custom server because the plataform im using when you upload an asset, its not stored in the /files/andfile.php it creates an automatic link so cant change that:

[code]function(instance, context) {
var div;

div = $(‘

id=“tester”
’);
div.css(“width”, “100%”);
div.css(“height”, “100%”);
div.css(“cursor”, “pointer”);

gantt.init(“tester”, new Date(2018, 01, 01), new Date(2018, 12, 31));
gantt.load("//dd7tel2830j4w.cloudfront.net/f1517595123161x874294243054464500/data.php");

instance.canvas.append(div);
instance.data.div = div;

}[/code]

data.php

[code]<?php

include (’//dd7tel2830j4w.cloudfront.net/f1517594439463x262359400046989300/gantt_connector.php’);

$res=mysql_connect(“qzf818.xxxxxx.com”,“qzf818”,“pl3sv2k01”);
mysql_select_db(“qzf818”);

$gantt = new JSONGanttConnector($res);
$gantt->render_links(“gantt_links”,“id”,“source,target,type”);
$gantt->render_table(
“gantt_tasks”,
“id”,
“start_date,duration,text,progress,sortorder,parent”
);
?>[/code]

gantt_connector.php

[code]<?php

include (‘config.php’);

$gantt = new JSONGanttConnector($res, $dbtype);

$gantt->mix(“open”, 1);
//$gantt->enable_order(“sortorder”);

$gantt->render_links(“gantt_links”, “id”, “source,target,type”);
$gantt->render_table(“gantt_tasks”,“id”,“start_date,duration,text,progress,parent”,"");

?>[/code]

Thanks!

#3

Could you clarify how exactly it doesn’t work?
Please follow these steps to help me to know where is the problem:

  1. When you try to open gannt on a webpage press “F12” to open “Web console” or “Chrome Dev Tools”.
    developers.google.com/web/tools … s/console/
    Notice if there are any messages, especially warnings or errors.

  2. Open “Network” tab in the Web console and check if you have the request status and response content when you load gantt or when you try to do add a task.
    developers.google.com/web/tools … /reference
    Check there is an error message.

  3. After that try enabling logging for the gantt connector according to this instruction:
    docs.dhtmlx.com/connector__php_ … idelogging
    and repeat the error.

In case of errors or warnings, please copy all the text or make a screenshot and post it here.