Databases
StackOverflow2013
Postsdbo
POAccessing SQL Database from a seperate directory
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POAccessing SQL Database from a seperate directory
    primarykey
    data
    text
    <p>I am coding a website which links into the service desk software that I am using. The name of the service desk package is OTRS. The name of the parent directory for the software is named"OTRS", within this directory there are 3 directories "Apache", "mysql" and "OTRS". OTRS holds the .pl files associated with the service desk software. "mysql" holds the databases for the OTRS and any custom database that are created. The "Apache" directory holds custom user-made webpages.</p> <p>Within the "Apache" directory under "htdocs" I would like to create a page which displays how many open tickets are in the service desk. So far I have written the following:</p> <pre><code>&lt;body height: 100%; width: 490px;&gt; &lt;?php //mysql conector $con = mysql_connect("localhost","otrs","xxxxxxx"); if (!$con) { die('Could not connect: ' . mysql_error()); } mysql_select_db("dashboard", $con); ?&gt; &lt;div id="hig9tv"&gt; &lt;center&gt;&lt;p&gt; &lt;table id='higtable2' border="1" cellspacing="2" cellpadding="2"&gt; &lt;?php $result = mysql_query("SELECT * FROM news"); $num=mysql_numrows($result); $i=$num-1; while ($i != -1) { $f1=mysql_result($result,$i,"text"); $f2=mysql_result($result,$i,"time"); $f3=mysql_result($result,$i,"date"); ?&gt; &lt;tr&gt; &lt;td&gt;&lt;font face="Arial, Helvetica, sans-serif"&gt;&lt;?php echo $f1; ?&gt;&lt;/font&gt;&lt;/td&gt;&lt;/tr&gt; &lt;tr&gt; &lt;td width='80px'&gt;&lt;font face="Arial, Helvetica, sans-serif"&gt;&lt;div id="tiny"&gt;&lt;?php echo "$f3 $f2" ; ?&gt;&lt;/div&gt;&lt;/font&gt;&lt;hr&gt;&lt;/td&gt; &lt;/tr&gt; &lt;?php $i--; } ?&gt; &lt;/table&gt; &lt;/p&gt;&lt;/center&gt; &lt;/div&gt; &lt;/body&gt; </code></pre> <p>However nothing is displayed in the div when I open the page. The data is stored in the "mySQL" directory under </p> <blockquote> <p>mysql/data</p> </blockquote> <p>is there anyway to link into the database stored in this directory from the Apache?</p> <p>Thanks</p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. USBen Newton
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. COYou don't have to think about where the Database-Server saves your Database! When the Database-Server is running you can choose any Database which is linked to the Database-Server. Also have a view on this topic [mysql_fetch_assoc()](http://php.net/manual/en/function.mysql-fetch-assoc.php) it gives you an easier way of handling data you've fetched out of your Database.
      singulars
      1. POAccessing SQL Database from a seperate directory
      1. USrauchmelder
    2. CO`The data is stored in the "mySQL" directory under` are these `.sql` files?
      singulars
      1. POAccessing SQL Database from a seperate directory
      1. USAlexP
    3. CO@AlexP the files in the my sql directory are in a sub-directory's by database name, the database files I am after are in a directory labelled "dashboard". The files within this directory are .FRM, MYD, MYI. Each table has on each of these file types.
      singulars
      1. POAccessing SQL Database from a seperate directory
      1. USBen Newton
 

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