Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>I wrote an article on this very subject:</p> <p><a href="http://christian.roy.name/blog/install-pear-without-network-no-internet-accessoffline" rel="nofollow">http://christian.roy.name/blog/install-pear-without-network-no-internet-accessoffline</a></p> <p>It will allow you to use the pear command as well.</p> <h3>Create temporary folder that I will get ride of later.</h3> <pre><code>mkdir pear-temp cd pear-temp </code></pre> <h3>Upload all the PEAR packages to that temp folder (using SFTP, FTP, Whatever).</h3> If you use a USB key, then you copy them all like this: <pre><code>cp /mnt/usb/*.tgz ./ </code></pre> <h3>Extract the core packages in a separate folder.</h3> <pre><code>mkdir lib tar x -C lib -zf PEAR-*.tgz tar x -C lib -zf Console_Getopt-*.tgz tar x -C lib -zf Archive_Tar-*.tgz tar x -C lib -zf Structures_Graph-*.tgz </code></pre> <h3>This bash function is to be able to set the include_path joined by colons.</h3> <pre><code>function join() { local IFS=$1 shift echo "$*" } </code></pre> <h3>pear requires output buffering and needs to load all the core packages from the lib folder.</h3> <pre><code>PHPOPT="-d output_buffering=1 -d include_path=.:$(join ':' lib/*)" </code></pre> <h3>First we setup our configuration file.</h3> <pre><code>php $PHPOPT lib/PEAR-*/scripts/pearcmd.php config-create $HOME/ $HOME/.pearrc </code></pre> <h3>Now we install ALL our packages. Make sure you have all the required dependencies as well.</h3> <pre><code>php $PHPOPT lib/PEAR-*/scripts/pearcmd.php install -o -O *.tgz </code></pre> <h3>Cleanup</h3> <pre><code>cd .. rm -Rf pear-temp </code></pre> <h3>Put pear in your path:</h3> <pre><code>PATH="$PATH:$HOME/pear" </code></pre> <h3>Edit your .profile or .bashrc if you want this to be permanent.</h3> <h3>Edit your php.ini too or add it using set_include_path() function, whichever :)</h3> <h3>Drink to sucess!</h3>
    singulars
    1. This table or related slice is empty.
    1. POInstalling PEAR without access to Internet
      singulars
      1. PTQuestion
    1. PTAnswer
    1. This table or related slice is empty.
    1. USroychri
    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. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COThank you so much, you saved me. Your answer is precise and thorough. Could you explain just the last bit with set_include_path, please? Should I add "$HOME/pear" to include_path?
      singulars
      1. PO
      1. USAlsciende
    2. CO@Alsciende I am glad it helped you out :) If you want all your php projects to have access to the PEAR installation, open up your php.ini and append $HOME/pear to the include_path value already there. If there value is currently `include_path = ".:/usr/share/php"` then change it to `include_path = ".:/usr/share/php:/home/yourusername/pear"`. If you only want some project to have access to pear, then in your project's bootstrap add `set_include_path(get_include_path() . PATH_SEPARATOR . '/home/yourusername/pear');`. Make sure you replace yourusername with your own username of course. Enjoy!
      singulars
      1. PO
      1. USroychri
 

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