RSSの内容を呟くアプリを作ってみよう php 8.1.18 netbeans 16 ubuntu-22.04

Twitter API V1.1からV2への変更箇所（つぶやくだけ） pic.twitter.com/CTmRlaE2pt

— 乖離（*´∀｀）🍑😊🐻😾☔🎵🍢🌸💯🗽🇯🇵🗻🏝️🌲🏡🆓🎮🚗🚴💨 (@kai_ri_0001) May 13, 2023

https://developer.twitter.com/en/docs/twitter-api/tweets/manage-tweets/api-reference/post-tweets
POST /2/tweets | Docs | Twitter Developer Platform

(ﾟωﾟ) composerのself-updateは、composer-temp.pharを/usr/local/bin/composerへ上書きするのだが、
rename(/home/ユーザー/.cache/composer/composer-temp.phar,/usr/local/bin/composer): Permission denied
(ﾟωﾟ) と言われて失敗する事がある。 chmod 777 、self-update、chmod 755 をするとself-updateは出来る。
https://pgmemo.tokyo/data/archives/1889.html

-----------下記は2023/04/04 19:58の内容-------------------

ホストのI/Oキャッシュを使う
SSD
を選んでOK。　まぁまぁ速くなった。 pic.twitter.com/BYAgSFJdIe

— 乖離（*´∀｀）🍑😊🐻😾☔🎵🍢🌸💯🗽🇯🇵🗻🏝️🌲🏡🆓🎮🚗🚴💨 (@kai_ri_0001) April 4, 2023

-----------下記は2023/01/03 12:28の内容-------------------
(ﾟωﾟ) 永久凍結を解除でき、ツイッターにログインできた。

永久凍結から復帰できた。
イーロンマスクさんに言ってみるもんだねぇ。 pic.twitter.com/ICOSmV3k7v

— 乖離（*´∀｀）🍑😊🐻😾☔🎵🍢🌸💯🗽🇯🇵🗻🏝️🌲🏡🆓🎮🚗🚴💨 (@kai_ri_0001) January 3, 2023

-----------下記は2022/12/30 7:28の内容-------------------

https://news.yahoo.co.jp/articles/743160be41ecd9cc3925384ed05a235a917f6d5c
【速報】ウェブ版ツイッターで一時世界規模のアクセス障害か
12/29(木) 12:09配信
(ﾟωﾟ) アメリカは2022/12/29 09:40JSTで1万人以上、日本でも発生。
(ﾟωﾟ) ツイッターは保守手順書も作ってないように思える。
(ﾟωﾟ) 認証コードがスマホに届かない事は、まだ直っていない。
https://downdetector.com/status/twitter/

-----------下記は2022/12/29 7:35の内容-------------------

「認証コードがスマホに届かない。ログインのテスト要員として無償でシステム開発に協力した。運用時に機能テストしてるツイッターは、課金する前のベータ版だと思う。 現行のシステム開発の管理者は総入れ替えしたほうがいいよ。」＞イーロンマスクさん。

-----------下記は2022/12/28 8:15の内容-------------------

携帯電話番号やユーザーIDでログインしても、認証コードがSMS経由で届かない。
という事を下記のメールに返信してツイッターのサポートへ伝えた。
ご利用のアカウントで、Twitterルールに違反する不自然な行為が報告されたため、次の手順を実行していただくまで、アカウントが凍結されることをご連絡します。 アカウントにログインするか、iOSまたはAndroidでTwitterアプリを開きます。 アカウントについてのメッセージが表示されるので、[開始] をクリックします。 国/地域を選択し、電話番号を入力します。 [コードを送信] をクリックします。 確認コードが記載されたメッセージがTwitterからお客様宛に送信されます。 画面に受け取ったコードを入力します。確認が送信されます。なお、アカウントのロックが完全に解除されるまで、数分かかる場合があります。 認証後も問題が発生する場合は、発生している問題を詳細に記載してこのメッセージに返信してください。 Twitterルールの違反が繰り返される場合には、アカウントは永久に凍結されますのでご注意ください。 よろしくお願いいたします。 Twitter ref:00DA0000000K0A8.5004w00002aer6Z:ref Help | Privacy Twitter, Inc. 1355 Market Street, Suite 900 San Francisco, CA 94103
-----------下記は2022/12/27 7:54の内容-------------------

下記の異議申し立てを２回くらい送ってみると、永久凍結から凍結になった。
ログインしてみると認証コードが届かない。別サイトの認証コードがSMSに届くことから、ツイッター側に問題がある様に思える。

認証コードが携帯電話に届かない。
を異議申し立て画面から送ってみる。

-----------下記は2022/12/17 7:59の内容-------------------

ツイッター永久凍結に異議申し立てをした。↓

企業や組織のRSSをREST APIを使ってUpdateすれば永久凍結するのであれば、その企業も凍結すべき。私のアカウントだけが凍結するのは差別です。

-----------下記は2022/07/03 10:40の内容-------------------

https://dlvrit.com/
dlvrit.comは、やがて有料になるだろう。

ツイッターのアプリ作成の権限は電話番号とツイッターアカウントがあれば誰でも取得出来るから、RSSの内容を呟くアプリを作ってみようと思う。
久しぶりにNetBeansを起動して、Composerを使ってみるとエラー終了。
phpのライブラリを作ってる人達はComposerを使ってライブラリを配布しており、Composer利用は必須。

https://getcomposer.org/download/
に書いてあるCommand-line installationを実行すると、新しいComposerはcomposer.pharとして生成されるので、/usr/bin/composerに差し替えた。

Composerは動作した。netbeans 12.2は使わないからアンインストールする。uninstall.shの実行はLoginしたユーザーで行う。
ubuntu@ubuntu-VirtualBox:~/netbeans-12.2$ ls -la 合計 1252 drwxrwxr-x 3 ubuntu ubuntu 4096 7月 15 12:36 . drwxr-xr-x 28 ubuntu ubuntu 4096 10月 27 19:38 .. drwxrwxr-x 21 ubuntu ubuntu 4096 10月 27 09:11 netbeans -rwxrwxr-x 1 ubuntu ubuntu 1268736 7月 15 12:36 uninstall.sh ubuntu@ubuntu-VirtualBox:~/netbeans-12.2$ ./uninstall.sh

Apache-NetBeans-12.5-bin-linux-x64.shをLoginしたユーザーで実行して、netbeans 12.5をインストールした。

OSのコマンド（CLI）のSQLite3はDBの中を確認するためにインストールする。PHPのライブラリphp8.0-sqlite3もインストールする。
https://sqlitebrowser.org/
Browser for SQLiteもインストールしておくと便利。Synapticパッケージマネージャーでは、sqlitebrowserというパッケージ名をインストール。

ubuntu@ubuntu-VirtualBox:/etc/php/8.0/cli$ sudo apt-get install php8.0-sqlite3 パッケージリストを読み込んでいます... 完了 依存関係ツリーを作成しています 状態情報を読み取っています... 完了 以下のパッケージが新たにインストールされます: php8.0-sqlite3 アップグレード: 0 個、新規インストール: 1 個、削除: 0 個、保留: 9 個。 28.3 kB のアーカイブを取得する必要があります。 この操作後に追加で 139 kB のディスク容量が消費されます。 取得:1 http://ppa.launchpad.net/ondrej/php/ubuntu focal/main amd64 php8.0-sqlite3 amd64 8.0.12-1+ubuntu20.04.1+deb.sury.org+1 [28.3 kB] 28.3 kB を 1秒 で取得しました (21.0 kB/s) 以前に未選択のパッケージ php8.0-sqlite3 を選択しています。 (データベースを読み込んでいます ... 現在 162325 個のファイルとディレクトリがインストールされています。) .../php8.0-sqlite3_8.0.12-1+ubuntu20.04.1+deb.sury.org+1_amd64.deb を展開する準備をしています ... php8.0-sqlite3 (8.0.12-1+ubuntu20.04.1+deb.sury.org+1) を展開しています... php8.0-sqlite3 (8.0.12-1+ubuntu20.04.1+deb.sury.org+1) を設定しています ... Creating config file /etc/php/8.0/mods-available/sqlite3.ini with new version Creating config file /etc/php/8.0/mods-available/pdo_sqlite.ini with new version php8.0-fpm (8.0.12-1+ubuntu20.04.1+deb.sury.org+1) のトリガを処理しています ... php8.0-cli (8.0.12-1+ubuntu20.04.1+deb.sury.org+1) のトリガを処理しています ... ubuntu@ubuntu-VirtualBox:/etc/php/8.0/cli$ dpkg --get-selections | grep php libapache2-mod-php8.0 deinstall php-common install php-composer-ca-bundle install php-composer-semver install php-composer-spdx-licenses install php-composer-xdebug-handler install php-curl install php-json-schema install php-mbstring install php-pear install php-psr-container install php-psr-log install php-symfony-console install php-symfony-filesystem install php-symfony-finder install php-symfony-process install php-symfony-service-contracts install php-xdebug install php-xml install php7.4-cli install php7.4-common install php7.4-curl deinstall php7.4-json install php7.4-mbstring install php7.4-opcache install php7.4-readline install php7.4-xml install php8.0 install php8.0-cli install php8.0-common install php8.0-curl install php8.0-fpm install php8.0-mbstring install php8.0-opcache install php8.0-readline install php8.0-sqlite3 install php8.0-xdebug install php8.0-xml install ubuntu@ubuntu-VirtualBox:/etc/php/8.0/cli$
https://it-jog.com/php/warning-sqlite3_column_table_name
＞PHP実行時の警告：PHP Warning: PHP Startup: Unable to load dynamic library 'pdo_sqlite' 〜 undefined symbol: sqlite3_column_table_name
を参考に、rootでmakeしなおしたらワーニングは出なくなった。打ったコマンド履歴を貼っておく。
ubuntu@ubuntu-VirtualBox:~/NetBeansProjects/PhpProject10$ php -version PHP Warning: PHP Startup: Unable to load dynamic library 'pdo_sqlite.so' (tried: /usr/lib/php/20200930/pdo_sqlite.so (/usr/lib/php/20200930/pdo_sqlite.so: undefined symbol: sqlite3_column_table_name), /usr/lib/php/20200930/pdo_sqlite.so.so (/usr/lib/php/20200930/pdo_sqlite.so.so: cannot open shared object file: No such file or directory)) in Unknown on line 0 PHP 8.0.12 (cli) (built: Oct 22 2021 12:34:48) ( NTS ) Copyright (c) The PHP Group Zend Engine v4.0.12, Copyright (c) Zend Technologies with Zend OPcache v8.0.12, Copyright (c), by Zend Technologies with Xdebug v3.1.1, Copyright (c) 2002-2021, by Derick Rethans ########################################################## 　pdo_sqlite.soが無いのか調べてみると、soファイルは有る。 ########################################################## ubuntu@ubuntu-VirtualBox:~/NetBeansProjects/PhpProject10$ ls -la /usr/lib/php/20200930/ 合計 13536 drwxr-xr-x 2 root root 4096 11月 12 08:07 . drwxr-xr-x 8 root root 4096 11月 10 08:24 .. -rw-r--r-- 1 root root 35080 10月 22 21:34 calendar.so -rw-r--r-- 1 root root 14600 10月 22 21:34 ctype.so -rw-r--r-- 1 root root 112904 10月 22 21:34 curl.so -rw-r--r-- 1 root root 288584 11月 2 12:03 dbase.so -rw-r--r-- 1 root root 166152 10月 22 21:34 dom.so -rw-r--r-- 1 root root 92424 10月 22 21:34 exif.so -rw-r--r-- 1 root root 166152 10月 22 21:34 ffi.so -rw-r--r-- 1 root root 6789384 10月 22 21:34 fileinfo.so -rw-r--r-- 1 root root 67848 10月 22 21:34 ftp.so -rw-r--r-- 1 root root 18696 10月 22 21:34 gettext.so -rw-r--r-- 1 root root 51464 10月 22 21:34 iconv.so -rw-r--r-- 1 root root 1041296 10月 22 21:34 mbstring.so -rw-r--r-- 1 root root 1358888 10月 22 21:34 opcache.so -rw-r--r-- 1 root root 121096 10月 22 21:34 pdo.so -rw-r--r-- 1 root root 39176 10月 22 21:34 pdo_sqlite.so -rw-r--r-- 1 root root 284936 10月 22 21:34 phar.so -rw-r--r-- 1 root root 43272 10月 22 21:34 posix.so -rw-r--r-- 1 root root 39176 10月 22 21:34 readline.so -rw-r--r-- 1 root root 18696 10月 22 21:34 shmop.so -rw-r--r-- 1 root root 59656 10月 22 21:34 simplexml.so -rw-r--r-- 1 root root 104712 10月 22 21:34 sockets.so -rw-r--r-- 1 root root 67848 10月 22 21:34 sqlite3.so -rw-r--r-- 1 root root 22792 10月 22 21:34 sysvmsg.so -rw-r--r-- 1 root root 14600 10月 22 21:34 sysvsem.so -rw-r--r-- 1 root root 22792 10月 22 21:34 sysvshm.so -rw-r--r-- 1 root root 35080 10月 22 21:34 tokenizer.so -rw-r--r-- 1 root root 2538256 11月 11 17:09 xdebug.so -rw-r--r-- 1 root root 55560 10月 22 21:34 xml.so -rw-r--r-- 1 root root 35080 10月 22 21:34 xmlreader.so -rw-r--r-- 1 root root 51464 10月 22 21:34 xmlwriter.so -rw-r--r-- 1 root root 39176 10月 22 21:34 xsl.so ubuntu@ubuntu-VirtualBox:~/NetBeansProjects/PhpProject10$ php PHP Warning: PHP Startup: Unable to load dynamic library 'pdo_sqlite.so' (tried: /usr/lib/php/20200930/pdo_sqlite.so (/usr/lib/php/20200930/pdo_sqlite.so: undefined symbol: sqlite3_column_table_name), /usr/lib/php/20200930/pdo_sqlite.so.so (/usr/lib/php/20200930/pdo_sqlite.so.so: cannot open shared object file: No such file or directory)) in Unknown on line 0 ^C ubuntu@ubuntu-VirtualBox:~/NetBeansProjects/PhpProject10$ cd ########################################################### 　最新のsqliteをダウンロードして解凍したディレクトリに来る ########################################################### ubuntu@ubuntu-VirtualBox:~$ cd ダウンロード/ ubuntu@ubuntu-VirtualBox:~/ダウンロード$ ls -la 合計 426492 drwxr-xr-x 4 ubuntu ubuntu 4096 11月 4 11:19 . drwxr-xr-x 28 ubuntu ubuntu 4096 11月 12 11:54 .. -rwxrwxr-x 1 ubuntu ubuntu 431095808 10月 27 19:39 Apache-NetBeans-12.5-bin-linux-x64.sh -rw-rw-r-- 1 ubuntu ubuntu 858 10月 27 19:38 Apache-NetBeans-12.5-bin-linux-x64.sh.asc -rwxr-xr-x 1 ubuntu ubuntu 2268732 10月 27 10:32 composer.phar -rw-r--r-- 1 ubuntu ubuntu 140730 12月 5 2020 package.xml drwxrwxr-x 5 ubuntu ubuntu 4096 11月 4 13:00 sqlite-autoconf-3360000 -rw-rw-r-- 1 ubuntu ubuntu 2977080 11月 4 11:17 sqlite-autoconf-3360000.tar.gz drwxrwxr-x 9 ubuntu ubuntu 4096 12月 14 2020 xdebug-3.0.1 -rw-rw-r-- 1 ubuntu ubuntu 214467 12月 14 2020 xdebug-3.0.1.tgz ubuntu@ubuntu-VirtualBox:~/ダウンロード$ cd sqlite-autoconf-3360000 ubuntu@ubuntu-VirtualBox:~/ダウンロード/sqlite-autoconf-3360000$ ls -la 合計 57660 drwxrwxr-x 5 ubuntu ubuntu 4096 11月 4 13:00 . drwxr-xr-x 4 ubuntu ubuntu 4096 11月 4 11:19 .. drwxrwxr-x 2 ubuntu ubuntu 4096 11月 4 11:31 .deps drwxrwxr-x 2 ubuntu ubuntu 4096 11月 4 11:30 .libs -rw-rw-r-- 1 ubuntu ubuntu 15744 6月 19 03:52 INSTALL -rw-rw-r-- 1 ubuntu ubuntu 37558 11月 4 13:00 Makefile -rw-rw-r-- 1 ubuntu ubuntu 729 6月 19 03:52 Makefile.am -rw-rw-r-- 1 ubuntu ubuntu 547 6月 19 03:52 Makefile.fallback -rw-rw-r-- 1 ubuntu ubuntu 37457 6月 19 03:52 Makefile.in -rw-rw-r-- 1 ubuntu ubuntu 28785 6月 19 03:52 Makefile.msc -rw-rw-r-- 1 ubuntu ubuntu 3558 6月 19 03:52 README.txt -rw-rw-r-- 1 ubuntu ubuntu 7272 6月 19 03:52 Replace.cs -rw-rw-r-- 1 ubuntu ubuntu 372955 6月 19 03:52 aclocal.m4 -rwxr-xr-x 1 ubuntu ubuntu 7333 6月 19 03:52 compile -rwxr-xr-x 1 ubuntu ubuntu 44283 6月 19 03:52 config.guess -rw-rw-r-- 1 ubuntu ubuntu 47140 11月 4 13:00 config.log -rwxrwxr-x 1 ubuntu ubuntu 54700 11月 4 13:00 config.status -rwxr-xr-x 1 ubuntu ubuntu 36136 6月 19 03:52 config.sub -rwxrwxr-x 1 ubuntu ubuntu 481720 6月 19 03:52 configure -rw-rw-r-- 1 ubuntu ubuntu 9225 6月 19 03:52 configure.ac -rwxr-xr-x 1 ubuntu ubuntu 23567 6月 19 03:52 depcomp -rwxr-xr-x 1 ubuntu ubuntu 15155 6月 19 03:52 install-sh -rw-rw-r-- 1 ubuntu ubuntu 974 11月 4 11:30 libsqlite3.la -rwxrwxr-x 1 ubuntu ubuntu 339446 11月 4 13:00 libtool -rw-r--r-- 1 ubuntu ubuntu 324412 6月 19 03:52 ltmain.sh -rwxr-xr-x 1 ubuntu ubuntu 6872 6月 19 03:52 missing -rw-rw-r-- 1 ubuntu ubuntu 687509 6月 19 03:52 shell.c -rwxrwxr-x 1 ubuntu ubuntu 8880680 11月 4 11:31 sqlite3 -rw-rw-r-- 1 ubuntu ubuntu 2644416 11月 4 11:30 sqlite3-shell.o -rw-rw-r-- 1 ubuntu ubuntu 18056672 11月 4 11:31 sqlite3-sqlite3.o -rw-rw-r-- 1 ubuntu ubuntu 8928 6月 19 03:52 sqlite3.1 -rw-rw-r-- 1 ubuntu ubuntu 8312766 6月 19 03:52 sqlite3.c -rw-rw-r-- 1 ubuntu ubuntu 588809 6月 19 03:52 sqlite3.h -rw-rw-r-- 1 ubuntu ubuntu 288 11月 4 11:30 sqlite3.lo -rw-rw-r-- 1 ubuntu ubuntu 17826352 11月 4 11:30 sqlite3.o -rw-rw-r-- 1 ubuntu ubuntu 286 11月 4 13:00 sqlite3.pc -rw-rw-r-- 1 ubuntu ubuntu 267 6月 19 03:52 sqlite3.pc.in -rw-rw-r-- 1 ubuntu ubuntu 1992 6月 19 03:52 sqlite3.rc -rw-rw-r-- 1 ubuntu ubuntu 35437 6月 19 03:52 sqlite3ext.h -rw-rw-r-- 1 ubuntu ubuntu 78 6月 19 03:52 sqlite3rc.h drwxr-xr-x 6 ubuntu ubuntu 4096 6月 19 03:52 tea ubuntu@ubuntu-VirtualBox:~/ダウンロード/sqlite-autoconf-3360000$ more README.txt This package contains: * the SQLite library amalgamation source code file: sqlite3.c * the sqlite3.h and sqlite3ext.h header files that define the C-language interface to the sqlite3.c library file * the shell.c file used to build the sqlite3 command-line shell program * autoconf/automake installation infrastucture for building on POSIX compliant systems * a Makefile.msc, sqlite3.rc, and Replace.cs for building with Microsoft Visual C++ on Windows SUMMARY OF HOW TO BUILD ======================= Unix: ./configure; make Windows: nmake /f Makefile.msc BUILDING ON POSIX ================= The generic installation instructions for autoconf/automake are found in the INSTALL file. The following SQLite specific boolean options are supported: --enable-readline use readline in shell tool [default=yes] --enable-threadsafe build a thread-safe library [default=yes] --enable-dynamic-extensions support loadable extensions [default=yes] The default value for the CFLAGS variable (options passed to the C compiler) includes debugging symbols in the build, resulting in larger binaries than are necessary. Override it on the configure command line like this: $ CFLAGS="-Os" ./configure to produce a smaller installation footprint. Other SQLite compilation parameters can also be set using CFLAGS. For example: $ CFLAGS="-Os -DSQLITE_THREADSAFE=0" ./configure BUILDING WITH MICROSOFT VISUAL C++ ================================== To compile for Windows using Microsoft Visual C++: $ nmake /f Makefile.msc Using Microsoft Visual C++ 2005 (or later) is recommended. Several Windows ##################################################### 　　configureコマンドからは rootで行う。 ##################################################### ubuntu@ubuntu-VirtualBox:~/ダウンロード/sqlite-autoconf-3360000$ sudo bash root@ubuntu-VirtualBox:/home/ubuntu/ダウンロード/sqlite-autoconf-3360000# CFLAGS="-DSQLITE_ENABLE_COLUMN_METADATA=1" ./configure checking for a BSD-compatible install... /usr/bin/install -c checking whether build environment is sane... yes checking for a thread-safe mkdir -p... /usr/bin/mkdir -p checking for gawk... no checking for mawk... mawk checking whether make sets $(MAKE)... yes checking whether make supports nested variables... yes checking for style of include used by make... GNU checking for gcc... gcc checking whether the C compiler works... yes checking for C compiler default output file name... a.out checking for suffix of executables... checking whether we are cross compiling... no checking for suffix of object files... o checking whether we are using the GNU C compiler... yes checking whether gcc accepts -g... yes checking for gcc option to accept ISO C89... none needed checking whether gcc understands -c and -o together... yes checking dependency style of gcc... gcc3 checking for special C compiler options needed for large files... no checking for _FILE_OFFSET_BITS value needed for large files... no checking for gcc... (cached) gcc checking whether we are using the GNU C compiler... (cached) yes checking whether gcc accepts -g... (cached) yes checking for gcc option to accept ISO C89... (cached) none needed checking whether gcc understands -c and -o together... (cached) yes checking dependency style of gcc... (cached) gcc3 checking build system type... x86_64-pc-linux-gnu checking host system type... x86_64-pc-linux-gnu checking how to print strings... printf checking for a sed that does not truncate output... /usr/bin/sed checking for grep that handles long lines and -e... /usr/bin/grep checking for egrep... /usr/bin/grep -E checking for fgrep... /usr/bin/grep -F checking for ld used by gcc... /usr/bin/ld checking if the linker (/usr/bin/ld) is GNU ld... yes checking for BSD- or MS-compatible name lister (nm)... /usr/bin/nm -B checking the name lister (/usr/bin/nm -B) interface... BSD nm checking whether ln -s works... yes checking the maximum length of command line arguments... 1572864 checking how to convert x86_64-pc-linux-gnu file names to x86_64-pc-linux-gnu format... func_convert_file_noop checking how to convert x86_64-pc-linux-gnu file names to toolchain format... func_convert_file_noop checking for /usr/bin/ld option to reload object files... -r checking for objdump... objdump checking how to recognize dependent libraries... pass_all checking for dlltool... no checking how to associate runtime and link libraries... printf %s\n checking for ar... ar checking for archiver @FILE support... @ checking for strip... strip checking for ranlib... ranlib checking command to parse /usr/bin/nm -B output from gcc object... ok checking for sysroot... no checking for a working dd... /usr/bin/dd checking how to truncate binary pipes... /usr/bin/dd bs=4096 count=1 checking for mt... mt checking if mt is a manifest tool... no checking how to run the C preprocessor... gcc -E checking for ANSI C header files... yes checking for sys/types.h... yes checking for sys/stat.h... yes checking for stdlib.h... yes checking for string.h... yes checking for memory.h... yes checking for strings.h... yes checking for inttypes.h... yes checking for stdint.h... yes checking for unistd.h... yes checking for dlfcn.h... yes checking for objdir... .libs checking if gcc supports -fno-rtti -fno-exceptions... no checking for gcc option to produce PIC... -fPIC -DPIC checking if gcc PIC flag -fPIC -DPIC works... yes checking if gcc static flag -static works... yes checking if gcc supports -c -o file.o... yes checking if gcc supports -c -o file.o... (cached) yes checking whether the gcc linker (/usr/bin/ld -m elf_x86_64) supports shared libraries... yes checking whether -lc should be explicitly linked in... no checking dynamic linker characteristics... GNU/Linux ld.so checking how to hardcode library paths into programs... immediate checking whether stripping libraries is possible... yes checking if libtool supports shared libraries... yes checking whether to build shared libraries... yes checking whether to build static libraries... yes checking for fdatasync... yes checking for usleep... yes checking for fullfsync... no checking for localtime_r... yes checking for gmtime_r... yes checking whether strerror_r is declared... yes checking for strerror_r... yes checking whether strerror_r returns char *... no checking editline/readline.h usability... no checking editline/readline.h presence... no checking for editline/readline.h... no checking readline/readline.h usability... no checking readline/readline.h presence... no checking for readline/readline.h... no checking for library containing pthread_create... -lpthread checking for library containing pthread_mutexattr_init... none required checking for library containing dlopen... -ldl checking for whether to support dynamic extensions... yes checking SQL math functions... enabled checking for library containing ceil... -lm checking FTS4 extension... enabled checking FTS3 extension... disabled checking FTS5 extension... enabled checking for library containing log... none required checking JSON functions... enabled checking RTREE extension... enabled checking Session extension... disabled checking Build type... release checking for posix_fallocate... yes checking zlib.h usability... yes checking zlib.h presence... yes checking for zlib.h... yes checking for library containing deflate... -lz checking for library containing system... none required checking that generated files are newer than configure... done configure: creating ./config.status config.status: creating Makefile config.status: creating sqlite3.pc config.status: executing depfiles commands config.status: executing libtool commands ################################################################ 　　rootでmake cleanと、makeと、make install を実行する。 ################################################################ root@ubuntu-VirtualBox:/home/ubuntu/ダウンロード/sqlite-autoconf-3360000# make clean rm -f sqlite3 test -z "libsqlite3.la" || rm -f libsqlite3.la rm -f ./so_locations rm -rf .libs _libs rm -f *.o rm -f *.lo root@ubuntu-VirtualBox:/home/ubuntu/ダウンロード/sqlite-autoconf-3360000# make /bin/bash ./libtool --tag=CC --mode=compile gcc -DPACKAGE_NAME=\"sqlite\" -DPACKAGE_TARNAME=\"sqlite\" -DPACKAGE_VERSION=\"3.36.0\" -DPACKAGE_STRING=\"sqlite\ 3.36.0\" -DPACKAGE_BUGREPORT=\"http://www.sqlite.org\" -DPACKAGE_URL=\"\" -DPACKAGE=\"sqlite\" -DVERSION=\"3.36.0\" -DSTDC_HEADERS=1 -DHAVE_SYS_TYPES_H=1 -DHAVE_SYS_STAT_H=1 -DHAVE_STDLIB_H=1 -DHAVE_STRING_H=1 -DHAVE_MEMORY_H=1 -DHAVE_STRINGS_H=1 -DHAVE_INTTYPES_H=1 -DHAVE_STDINT_H=1 -DHAVE_UNISTD_H=1 -DHAVE_DLFCN_H=1 -DLT_OBJDIR=\".libs/\" -DHAVE_FDATASYNC=1 -DHAVE_USLEEP=1 -DHAVE_LOCALTIME_R=1 -DHAVE_GMTIME_R=1 -DHAVE_DECL_STRERROR_R=1 -DHAVE_STRERROR_R=1 -DHAVE_POSIX_FALLOCATE=1 -DHAVE_ZLIB_H=1 -I. -D_REENTRANT=1 -DSQLITE_THREADSAFE=1 -DSQLITE_ENABLE_MATH_FUNCTIONS -DSQLITE_ENABLE_FTS4 -DSQLITE_ENABLE_FTS5 -DSQLITE_ENABLE_JSON1 -DSQLITE_ENABLE_RTREE -DSQLITE_ENABLE_GEOPOLY -DSQLITE_HAVE_ZLIB -DSQLITE_ENABLE_COLUMN_METADATA=1 -MT sqlite3.lo -MD -MP -MF .deps/sqlite3.Tpo -c -o sqlite3.lo sqlite3.c libtool: compile: gcc -DPACKAGE_NAME=\"sqlite\" -DPACKAGE_TARNAME=\"sqlite\" -DPACKAGE_VERSION=\"3.36.0\" "-DPACKAGE_STRING=\"sqlite 3.36.0\"" -DPACKAGE_BUGREPORT=\"http://www.sqlite.org\" -DPACKAGE_URL=\"\" -DPACKAGE=\"sqlite\" -DVERSION=\"3.36.0\" -DSTDC_HEADERS=1 -DHAVE_SYS_TYPES_H=1 -DHAVE_SYS_STAT_H=1 -DHAVE_STDLIB_H=1 -DHAVE_STRING_H=1 -DHAVE_MEMORY_H=1 -DHAVE_STRINGS_H=1 -DHAVE_INTTYPES_H=1 -DHAVE_STDINT_H=1 -DHAVE_UNISTD_H=1 -DHAVE_DLFCN_H=1 -DLT_OBJDIR=\".libs/\" -DHAVE_FDATASYNC=1 -DHAVE_USLEEP=1 -DHAVE_LOCALTIME_R=1 -DHAVE_GMTIME_R=1 -DHAVE_DECL_STRERROR_R=1 -DHAVE_STRERROR_R=1 -DHAVE_POSIX_FALLOCATE=1 -DHAVE_ZLIB_H=1 -I. -D_REENTRANT=1 -DSQLITE_THREADSAFE=1 -DSQLITE_ENABLE_MATH_FUNCTIONS -DSQLITE_ENABLE_FTS4 -DSQLITE_ENABLE_FTS5 -DSQLITE_ENABLE_JSON1 -DSQLITE_ENABLE_RTREE -DSQLITE_ENABLE_GEOPOLY -DSQLITE_HAVE_ZLIB -DSQLITE_ENABLE_COLUMN_METADATA=1 -MT sqlite3.lo -MD -MP -MF .deps/sqlite3.Tpo -c sqlite3.c -fPIC -DPIC -o .libs/sqlite3.o libtool: compile: gcc -DPACKAGE_NAME=\"sqlite\" -DPACKAGE_TARNAME=\"sqlite\" -DPACKAGE_VERSION=\"3.36.0\" "-DPACKAGE_STRING=\"sqlite 3.36.0\"" -DPACKAGE_BUGREPORT=\"http://www.sqlite.org\" -DPACKAGE_URL=\"\" -DPACKAGE=\"sqlite\" -DVERSION=\"3.36.0\" -DSTDC_HEADERS=1 -DHAVE_SYS_TYPES_H=1 -DHAVE_SYS_STAT_H=1 -DHAVE_STDLIB_H=1 -DHAVE_STRING_H=1 -DHAVE_MEMORY_H=1 -DHAVE_STRINGS_H=1 -DHAVE_INTTYPES_H=1 -DHAVE_STDINT_H=1 -DHAVE_UNISTD_H=1 -DHAVE_DLFCN_H=1 -DLT_OBJDIR=\".libs/\" -DHAVE_FDATASYNC=1 -DHAVE_USLEEP=1 -DHAVE_LOCALTIME_R=1 -DHAVE_GMTIME_R=1 -DHAVE_DECL_STRERROR_R=1 -DHAVE_STRERROR_R=1 -DHAVE_POSIX_FALLOCATE=1 -DHAVE_ZLIB_H=1 -I. -D_REENTRANT=1 -DSQLITE_THREADSAFE=1 -DSQLITE_ENABLE_MATH_FUNCTIONS -DSQLITE_ENABLE_FTS4 -DSQLITE_ENABLE_FTS5 -DSQLITE_ENABLE_JSON1 -DSQLITE_ENABLE_RTREE -DSQLITE_ENABLE_GEOPOLY -DSQLITE_HAVE_ZLIB -DSQLITE_ENABLE_COLUMN_METADATA=1 -MT sqlite3.lo -MD -MP -MF .deps/sqlite3.Tpo -c sqlite3.c -o sqlite3.o >/dev/null 2>&1 mv -f .deps/sqlite3.Tpo .deps/sqlite3.Plo /bin/bash ./libtool --tag=CC --mode=link gcc -D_REENTRANT=1 -DSQLITE_THREADSAFE=1 -DSQLITE_ENABLE_MATH_FUNCTIONS -DSQLITE_ENABLE_FTS4 -DSQLITE_ENABLE_FTS5 -DSQLITE_ENABLE_JSON1 -DSQLITE_ENABLE_RTREE -DSQLITE_ENABLE_GEOPOLY -DSQLITE_HAVE_ZLIB -DSQLITE_ENABLE_COLUMN_METADATA=1 -no-undefined -version-info 8:6:8 -o libsqlite3.la -rpath /usr/local/lib sqlite3.lo -lz -lm -ldl -lpthread libtool: link: gcc -shared -fPIC -DPIC .libs/sqlite3.o -lz -lm -ldl -lpthread -Wl,-soname -Wl,libsqlite3.so.0 -o .libs/libsqlite3.so.0.8.6 libtool: link: (cd ".libs" && rm -f "libsqlite3.so.0" && ln -s "libsqlite3.so.0.8.6" "libsqlite3.so.0") libtool: link: (cd ".libs" && rm -f "libsqlite3.so" && ln -s "libsqlite3.so.0.8.6" "libsqlite3.so") libtool: link: ar cru .libs/libsqlite3.a sqlite3.o ar: `u' modifier ignored since `D' is the default (see `U') libtool: link: ranlib .libs/libsqlite3.a libtool: link: ( cd ".libs" && rm -f "libsqlite3.la" && ln -s "../libsqlite3.la" "libsqlite3.la" ) gcc -DPACKAGE_NAME=\"sqlite\" -DPACKAGE_TARNAME=\"sqlite\" -DPACKAGE_VERSION=\"3.36.0\" -DPACKAGE_STRING=\"sqlite\ 3.36.0\" -DPACKAGE_BUGREPORT=\"http://www.sqlite.org\" -DPACKAGE_URL=\"\" -DPACKAGE=\"sqlite\" -DVERSION=\"3.36.0\" -DSTDC_HEADERS=1 -DHAVE_SYS_TYPES_H=1 -DHAVE_SYS_STAT_H=1 -DHAVE_STDLIB_H=1 -DHAVE_STRING_H=1 -DHAVE_MEMORY_H=1 -DHAVE_STRINGS_H=1 -DHAVE_INTTYPES_H=1 -DHAVE_STDINT_H=1 -DHAVE_UNISTD_H=1 -DHAVE_DLFCN_H=1 -DLT_OBJDIR=\".libs/\" -DHAVE_FDATASYNC=1 -DHAVE_USLEEP=1 -DHAVE_LOCALTIME_R=1 -DHAVE_GMTIME_R=1 -DHAVE_DECL_STRERROR_R=1 -DHAVE_STRERROR_R=1 -DHAVE_POSIX_FALLOCATE=1 -DHAVE_ZLIB_H=1 -I. -D_REENTRANT=1 -DSQLITE_THREADSAFE=1 -DSQLITE_ENABLE_MATH_FUNCTIONS -DSQLITE_ENABLE_FTS4 -DSQLITE_ENABLE_FTS5 -DSQLITE_ENABLE_JSON1 -DSQLITE_ENABLE_RTREE -DSQLITE_ENABLE_GEOPOLY -DSQLITE_HAVE_ZLIB -DSQLITE_ENABLE_EXPLAIN_COMMENTS -DSQLITE_ENABLE_DBPAGE_VTAB -DSQLITE_ENABLE_STMTVTAB -DSQLITE_ENABLE_DBSTAT_VTAB -DSQLITE_ENABLE_COLUMN_METADATA=1 -MT sqlite3-shell.o -MD -MP -MF .deps/sqlite3-shell.Tpo -c -o sqlite3-shell.o `test -f 'shell.c' || echo './'`shell.c mv -f .deps/sqlite3-shell.Tpo .deps/sqlite3-shell.Po gcc -DPACKAGE_NAME=\"sqlite\" -DPACKAGE_TARNAME=\"sqlite\" -DPACKAGE_VERSION=\"3.36.0\" -DPACKAGE_STRING=\"sqlite\ 3.36.0\" -DPACKAGE_BUGREPORT=\"http://www.sqlite.org\" -DPACKAGE_URL=\"\" -DPACKAGE=\"sqlite\" -DVERSION=\"3.36.0\" -DSTDC_HEADERS=1 -DHAVE_SYS_TYPES_H=1 -DHAVE_SYS_STAT_H=1 -DHAVE_STDLIB_H=1 -DHAVE_STRING_H=1 -DHAVE_MEMORY_H=1 -DHAVE_STRINGS_H=1 -DHAVE_INTTYPES_H=1 -DHAVE_STDINT_H=1 -DHAVE_UNISTD_H=1 -DHAVE_DLFCN_H=1 -DLT_OBJDIR=\".libs/\" -DHAVE_FDATASYNC=1 -DHAVE_USLEEP=1 -DHAVE_LOCALTIME_R=1 -DHAVE_GMTIME_R=1 -DHAVE_DECL_STRERROR_R=1 -DHAVE_STRERROR_R=1 -DHAVE_POSIX_FALLOCATE=1 -DHAVE_ZLIB_H=1 -I. -D_REENTRANT=1 -DSQLITE_THREADSAFE=1 -DSQLITE_ENABLE_MATH_FUNCTIONS -DSQLITE_ENABLE_FTS4 -DSQLITE_ENABLE_FTS5 -DSQLITE_ENABLE_JSON1 -DSQLITE_ENABLE_RTREE -DSQLITE_ENABLE_GEOPOLY -DSQLITE_HAVE_ZLIB -DSQLITE_ENABLE_EXPLAIN_COMMENTS -DSQLITE_ENABLE_DBPAGE_VTAB -DSQLITE_ENABLE_STMTVTAB -DSQLITE_ENABLE_DBSTAT_VTAB -DSQLITE_ENABLE_COLUMN_METADATA=1 -MT sqlite3-sqlite3.o -MD -MP -MF .deps/sqlite3-sqlite3.Tpo -c -o sqlite3-sqlite3.o `test -f 'sqlite3.c' || echo './'`sqlite3.c mv -f .deps/sqlite3-sqlite3.Tpo .deps/sqlite3-sqlite3.Po /bin/bash ./libtool --tag=CC --mode=link gcc -D_REENTRANT=1 -DSQLITE_THREADSAFE=1 -DSQLITE_ENABLE_MATH_FUNCTIONS -DSQLITE_ENABLE_FTS4 -DSQLITE_ENABLE_FTS5 -DSQLITE_ENABLE_JSON1 -DSQLITE_ENABLE_RTREE -DSQLITE_ENABLE_GEOPOLY -DSQLITE_HAVE_ZLIB -DSQLITE_ENABLE_EXPLAIN_COMMENTS -DSQLITE_ENABLE_DBPAGE_VTAB -DSQLITE_ENABLE_STMTVTAB -DSQLITE_ENABLE_DBSTAT_VTAB -DSQLITE_ENABLE_COLUMN_METADATA=1 -o sqlite3 sqlite3-shell.o sqlite3-sqlite3.o -lz -lm -ldl -lpthread libtool: link: gcc -D_REENTRANT=1 -DSQLITE_THREADSAFE=1 -DSQLITE_ENABLE_MATH_FUNCTIONS -DSQLITE_ENABLE_FTS4 -DSQLITE_ENABLE_FTS5 -DSQLITE_ENABLE_JSON1 -DSQLITE_ENABLE_RTREE -DSQLITE_ENABLE_GEOPOLY -DSQLITE_HAVE_ZLIB -DSQLITE_ENABLE_EXPLAIN_COMMENTS -DSQLITE_ENABLE_DBPAGE_VTAB -DSQLITE_ENABLE_STMTVTAB -DSQLITE_ENABLE_DBSTAT_VTAB -DSQLITE_ENABLE_COLUMN_METADATA=1 -o sqlite3 sqlite3-shell.o sqlite3-sqlite3.o -lz -lm -ldl -lpthread root@ubuntu-VirtualBox:/home/ubuntu/ダウンロード/sqlite-autoconf-3360000# make install make[1]: ディレクトリ '/home/ubuntu/ダウンロード/sqlite-autoconf-3360000' に入ります /usr/bin/mkdir -p '/usr/local/lib' /bin/bash ./libtool --mode=install /usr/bin/install -c libsqlite3.la '/usr/local/lib' libtool: install: /usr/bin/install -c .libs/libsqlite3.so.0.8.6 /usr/local/lib/libsqlite3.so.0.8.6 libtool: install: (cd /usr/local/lib && { ln -s -f libsqlite3.so.0.8.6 libsqlite3.so.0 || { rm -f libsqlite3.so.0 && ln -s libsqlite3.so.0.8.6 libsqlite3.so.0; }; }) libtool: install: (cd /usr/local/lib && { ln -s -f libsqlite3.so.0.8.6 libsqlite3.so || { rm -f libsqlite3.so && ln -s libsqlite3.so.0.8.6 libsqlite3.so; }; }) libtool: install: /usr/bin/install -c .libs/libsqlite3.lai /usr/local/lib/libsqlite3.la libtool: install: /usr/bin/install -c .libs/libsqlite3.a /usr/local/lib/libsqlite3.a libtool: install: chmod 644 /usr/local/lib/libsqlite3.a libtool: install: ranlib /usr/local/lib/libsqlite3.a libtool: finish: PATH="/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/snap/bin:/sbin" ldconfig -n /usr/local/lib ---------------------------------------------------------------------- Libraries have been installed in: /usr/local/lib If you ever happen to want to link against installed libraries in a given directory, LIBDIR, you must either use libtool, and specify the full pathname of the library, or use the '-LLIBDIR' flag during linking and do at least one of the following: - add LIBDIR to the 'LD_LIBRARY_PATH' environment variable during execution - add LIBDIR to the 'LD_RUN_PATH' environment variable during linking - use the '-Wl,-rpath -Wl,LIBDIR' linker flag - have your system administrator add LIBDIR to '/etc/ld.so.conf' See any operating system documentation about shared libraries for more information, such as the ld(1) and ld.so(8) manual pages. ---------------------------------------------------------------------- /usr/bin/mkdir -p '/usr/local/bin' /bin/bash ./libtool --mode=install /usr/bin/install -c sqlite3 '/usr/local/bin' libtool: install: /usr/bin/install -c sqlite3 /usr/local/bin/sqlite3 /usr/bin/mkdir -p '/usr/local/include' /usr/bin/install -c -m 644 sqlite3.h sqlite3ext.h '/usr/local/include' /usr/bin/mkdir -p '/usr/local/share/man/man1' /usr/bin/install -c -m 644 sqlite3.1 '/usr/local/share/man/man1' /usr/bin/mkdir -p '/usr/local/lib/pkgconfig' /usr/bin/install -c -m 644 sqlite3.pc '/usr/local/lib/pkgconfig' make[1]: ディレクトリ '/home/ubuntu/ダウンロード/sqlite-autoconf-3360000' から出ます root@ubuntu-VirtualBox:/home/ubuntu/ダウンロード/sqlite-autoconf-3360000# php ^C root@ubuntu-VirtualBox:/home/ubuntu/ダウンロード/sqlite-autoconf-3360000# php --version PHP 8.0.12 (cli) (built: Oct 22 2021 12:34:48) ( NTS ) Copyright (c) The PHP Group Zend Engine v4.0.12, Copyright (c) Zend Technologies with Zend OPcache v8.0.12, Copyright (c), by Zend Technologies with Xdebug v3.1.1, Copyright (c) 2002-2021, by Derick Rethans root@ubuntu-VirtualBox:/home/ubuntu/ダウンロード/sqlite-autoconf-3360000#
https://www.php.net/manual/ja/function.curl-exec.php
＞例1 ウェブページの取得
を参考にコーディングする。
RSSのXMLはテキストファイルへ書き出し、simplexml_load_file関数へ渡す。
https://www.php.net/manual/ja/function.ob-start.php
(ﾟωﾟ) 動きそうな物が出来たのでソースを公開しておきます。consumerKeyの辺りは自分の値に置き換えて下さい。
ubuntu@u2204:~/NetBeansProjects/PhpProject10$ ls -la 合計 14392 drwxrwxr-x 5 ubuntu ubuntu 4096 7月 29 05:24 . drwxrwxr-x 4 ubuntu ubuntu 4096 6月 15 2022 .. -rw-rw-r-- 1 ubuntu ubuntu 707 6月 15 2022 ConsumerKeyP.php drwxrwxr-x 2 ubuntu ubuntu 4096 7月 18 06:21 RSS -rw-rw-r-- 1 ubuntu ubuntu 279 6月 15 2022 composer.json -rw-rw-r-- 1 ubuntu ubuntu 5574 6月 15 2022 composer.lock -rwxrwxr-x 1 ubuntu ubuntu 115 6月 15 2022 index.bash -rw-rw-r-- 1 ubuntu ubuntu 242 6月 15 2022 index.php -rw-rw-r-- 1 ubuntu ubuntu 240 7月 14 08:37 main.php -rw-rw-r-- 1 ubuntu ubuntu 246 7月 3 09:19 main_debug.php -rw-rw-r-- 1 ubuntu ubuntu 14577664 7月 29 05:24 mysqlitedb.db -rw-rw-r-- 1 ubuntu ubuntu 65536 6月 15 2022 mysqlitedb.db.backup drwxrwxr-x 4 ubuntu ubuntu 4096 6月 15 2022 nbproject -rw-rw-r-- 1 ubuntu ubuntu 13265 7月 4 19:05 rss.php -rw-rw-r-- 1 ubuntu ubuntu 9240 7月 18 06:20 rss2twi.php -rw-rw-r-- 1 ubuntu ubuntu 535 7月 4 17:41 rss2twi_debug.php -rw-rw-r-- 1 ubuntu ubuntu 2390 6月 15 2022 state_transition.php drwxrwxr-x 4 ubuntu ubuntu 4096 6月 15 2022 vendor ubuntu@u2204:~/NetBeansProjects/PhpProject10$ cat index.bash #!/usr/bin/bash st=$((60*15)) while [ 1 ]; do php ./rss2twi.php echo "`date` : sleep = $st " sleep $st done ubuntu@u2204:~/NetBeansProjects/PhpProject10$ cat rss2twi.php <?php require 'rss.php'; require 'ConsumerKeyP.php'; //コンシューマーキー等 $myNameStr = 'kai_ri_0001'; // 自分 // phpinfo() ; $r = new rss(); // test function $r->test_isNewHizuke(); $r->setValues("https://www.jpcert.or.jp/rss/jpcert.rdf", "jpcert_rss.xml", $arConsumerKey[$myNameStr], $arConsumerSecret[$myNameStr], $arAccessToken[$myNameStr], $arAccessTokenSecret[$myNameStr]); $r->TwiOAuth(); $r->create_table(); $r->rss1(); $r->setUrlFile("https://www.rieti.go.jp/jp/rss/index.rdf", "rieti_go_jp_rss.xml"); $r->rss1(); $r->setUrlFile("https://jvn.jp/rss/jvn.rdf", "jvn_rss.xml"); $r->rss1(); $r->setUrlFile("https://www.ntt-east.co.jp/rss/release.rdf", "ntt-east_rss.xml"); $r->rss1(); $r->setUrlFile("https://www.docomo.ne.jp/info/rss/whatsnew.rdf", "nttdocomo_rss.xml"); $r->rss1(); $r->setUrlFile("https://www.docomo.ne.jp/info/rss/news_release.rdf", "nttdocomo_news_rss.xml"); $r->rss1(); $r->setUrlFile("https://www.soumu.go.jp/news.rdf", "soumu_rss.xml"); $r->rss1(); $r->setUrlFile("https://www.mlit.go.jp/topics.rdf", "mlit_rss.xml"); $r->rss1(); $r->setUrlFile("https://www.mlit.go.jp/pressrelease.rdf", "mlit_pressrelease_rss.xml"); $r->rss1(); $r->setUrlFile("https://group.ntt/jp/newsrelease/rss/release.rdf", "ntt_group_rss.xml"); $r->rss1(); $r->setUrlFile("https://www.nikon-image.com/news/rss/index.rdf", "nikon_rss.xml"); $r->rss1(); $r->setUrlFile("https://www.honda.co.jp/rss/hotnews.xml", "honda_rss.xml"); $r->rss1(); $r->setUrlFile("https://www.ffpri.affrc.go.jp/topics.xml", "ffpri_topics_rss.xml"); $r->rss1(); $r->setUrlFile("https://www.ffpri.affrc.go.jp/event.xml", "ffpri_event_rss.xml"); $r->rss1(); $r->setUrlFile("https://www.ffpri.affrc.go.jp/saizensen.xml", "ffpri_saizensen_rss.xml"); $r->rss1(); $r->setUrlFile("https://www.mhlw.go.jp/stf/news.rdf", "mhlw_rss.xml"); $r->rss1(); $r->setUrlFile("https://www.mitsubishielectric.co.jp/feed/news.xml", "mitsubishi_denki_rss.xml"); $r->rss1(); $r->setUrlFile("http://feeds.cnn.co.jp/rss/cnn/cnn.rdf", "cnn_kokusai_rss.xml"); $r->rss1(); $r->setUrlFile("https://www.pref.fukushima.lg.jp/rss/10/sec-11-152.xml", "fukushima_Forestry_lg_rss.xml"); $r->rss1(); $r->setUrlFile("https://www.pref.shizuoka.jp/a_content/common/shinchaku.xml", "shizuoka_shinchaku_rss.xml"); $r->rss1(); $r->setUrlFile("https://corporate.jp.sharp/news/rss.xml", "sharp_rss.xml"); $r->rss1(); $r->setUrlFile("https://www.jcp.or.jp/akahata/index.rdf", "jcp_akahata_rss.xml"); $r->rss1(); //予定がRSSに書かれており、新着との区別がつかない。サイト運営に問い合わせ中。2022.01.07 //$r->setUrlFile("https://www.e-stat.go.jp/news/rss/xml?refTarget=0101&haisinType=0101&category=all", "e-stat_rss.xml"); //$r->rss1(); $r->setUrlFile("https://blog.avast.com/jp/rss.xml", "avast_rss.xml"); $r->rss2(); $r->setUrlFile("https://blogs.windows.com/japan/feed/", "windowsBlog_rss.xml"); $r->rss2(); $r->setUrlFile("https://blogs.windows.com/windows-insider/feed", "microsoft_windows-insider_rss.xml"); $r->rss2(); $r->setUrlFile("https://support.microsoft.com/ja-jp/feed/rss/6ae59d69-36fc-8e4d-23dd-631d98bf74a9", "microsoft_windows10_rss.xml"); $r->rss2(); $r->setUrlFile("https://support.microsoft.com/ja-jp/feed/rss/b3b7449f-c02b-4758-7c18-7fdf5f29a1cd", "microsoft_excel_rss.xml"); $r->rss2(); $r->setUrlFile("https://support.microsoft.com/ja-jp/feed/rss/6a88efa5-712b-9e99-f1b9-368dc2d81f2e", "microsoft_IE_rss.xml"); $r->rss2(); $r->setUrlFile("https://support.microsoft.com/ja-jp/feed/rss/5d4715e7-a9c9-378e-3f83-fd410db4ef0a", "microsoft_Defender_rss.xml"); $r->rss2(); $r->setUrlFile("https://support.microsoft.com/ja-jp/feed/rss/a77ee9b7-b6b6-aa08-d7b9-887ebe228207", "microsoft_Edge_rss.xml"); $r->rss2(); $r->setUrlFile("https://support.microsoft.com/ja-jp/feed/rss/029dceb2-58a4-5a51-90fe-a66b7669017d", "microsoft_Teams_rss.xml"); $r->rss2(); $r->setUrlFile("https://www.maff.go.jp/rss.xml", "maff_rss.xml"); $r->rss2(); $r->setUrlFile("https://www.alsok.co.jp/rss/news.xml", "alsok_rss.xml"); $r->rss2(); $r->setUrlFile("http://feeds.trendmicro.com/TM-Securityblog/", "trendmicro_rss.xml"); $r->rss2(); $r->setUrlFile("http://feeds.trendmicro.com/jp/SupportNews", "trendmicro_SupportNews_rss.xml"); $r->rss2(); $r->setUrlFile("https://blog.kaspersky.co.jp/feed/", "kaspersky_rss.xml"); $r->rss2(); $r->setUrlFile("https://www.ntt-west.co.jp/newscms/news/rss.xml", "ntt-west_rss.xml"); $r->rss2(); $r->setUrlFile("https://www.ntt.com/index/rss.xml", "ntt_Communications_rss.xml"); $r->rss2(); $r->setUrlFile("https://rss.itmedia.co.jp/rss/2.0/news_security.xml", "itmedia_security_rss.xml"); $r->rss2(); $r->setUrlFile("https://www.kantei.go.jp/index-jnews.rdf", "kantei_rss.xml"); $r->rss2(); $r->setUrlFile("https://www.fsa.go.jp/fsaNewsListAll_rss2.xml", "fsa_rss.xml"); $r->rss2(); $r->setUrlFile("https://www.westjr.co.jp/press/article/index.xml", "westjr_rss.xml"); $r->rss2(); $r->setUrlFile("https://news.yahoo.co.jp/rss/topics/it.xml", "yahoo_IT_topics_rss.xml"); $r->rss2(); $r->setUrlFile("https://news.yahoo.co.jp/rss/media/ftaiwan/all.xml", "yahoo_ftaiwan_rss.xml"); $r->rss2(); $r->setUrlFile("https://news.yahoo.co.jp/rss/media/tenki/all.xml", "yahoo_tenki_rss.xml"); $r->rss2(); $r->setUrlFile("https://news.panasonic.com/press/news/rss/index.xml", "yahoo_tenki_rss.xml"); $r->rss2(); $r->setUrlFile("https://www.daihatsu.com/jp/rss.xml", "daihatsu_rss.xml"); $r->rss2(); $r->setUrlFile("https://news.yahoo.co.jp/rss/media/driverweb/all.xml", "yahoo_driverweb_rss.xml"); $r->rss2(); $r->setUrlFile("https://news.yahoo.co.jp/rss/media/gendaibiz/all.xml", "yahoo_gendaibiz_rss.xml"); $r->rss2(); $r->setUrlFile("https://news.yahoo.co.jp/rss/media/sangyo/all.xml", "yahoo_sangyo_rss.xml"); $r->rss2(); $r->setUrlFile("https://news.yahoo.co.jp/rss/media/norimono/all.xml", "yahoo_norimono_rss.xml"); $r->rss2(); $r->setUrlFile("https://news.samsung.com/global/feed", "samsung_rss.xml"); $r->rss2(); $r->setUrlFile("https://www.pref.tokushima.lg.jp/file/rss/ippannokata_kyoiku_index.rss", "tokushima_ippannokata_kyoiku_rss.xml"); $r->rss2(); $r->setUrlFile("https://www.pref.tokushima.lg.jp/file/rss/ippannokata_sangyo_index.rss", "tokushima_ippannokata_sangy_rss.xml"); $r->rss2(); $r->setUrlFile("https://www.pref.tokushima.lg.jp/file/rss/ippannokata_bosai_index.rss", "tokushima_ippannokata_bosai_rss.xml"); $r->rss2(); $r->setUrlFile("https://www.pref.tokushima.lg.jp/file/rss/jigyoshanokata_kurashi_index.rss", "tokushima_jigyoshanokata_kurashi_rss.xml"); $r->rss2(); $r->setUrlFile("https://www.pref.tokushima.lg.jp/file/rss/jigyoshanokata_kyoiku_index.rss", "tokushima_jigyoshanokata_kyoiku_rss.xml"); $r->rss2(); $r->setUrlFile("https://www.pref.tokushima.lg.jp/file/rss/jigyoshanokata_bosai_index.rss", "tokushima_jigyoshanokata_bosai_rss.xml"); $r->rss2(); $r->setUrlFile("https://www.pref.tokushima.lg.jp/file/rss/kenseijoho_soshiki_kendoseibibu_index.rss", "tokushima_kenseijoho_soshiki_kendoseibibu_rss.xml"); $r->rss2(); $r->setUrlFile("https://jp.fujitsu.com/rss/pr.rss", "fujitsu_rss.xml"); $r->rss2(); $r->setUrlFile("https://global.toyota/export/jp/allnews_rss.xml", "toyota_rss.xml"); $r->rss2(); $r->setUrlFile("https://global.canon/ja/rssfeed/news/index.xml", "canon_rss.xml"); $r->rss2(); $r->setUrlFile("https://amazon-press.jp/Top-Navi/RSS.html", "amazon_press_rss.xml"); $r->rss2(); $r->setUrlFile("https://www.iij.ad.jp/rss-temp/press/index.xml", "iij_rss.xml"); $r->rss2(); $r->setUrlFile("https://www.murata.com/ja-jp/news/rssfeed", "murata_rss.xml"); $r->rss2(); $r->setUrlFile("https://www.nintendo.co.jp/news/whatsnew.xml", "nintendo_rss.xml"); $r->rss2(); $r->setUrlFile("https://www.tron.org/ja/feed/", "tron_rss.xml"); $r->rss2(); $r->setUrlFile("https://www.sony.com/ja/SonyInfo/News/Press/data/pressrelease_group.xml", "sony_group_rss.xml"); $r->rss2(); $r->setUrlFile("https://www.sony.jp/xml/index.xml", "sony_rss.xml"); $r->rss2(); $r->setUrlFile("https://www.nikon.co.jp/rss/feeds/news.rss", "nikon_news_rss.xml"); $r->rss2(); $r->setUrlFile("https://feeds.feedburner.com/VideoCardzcom", "VideoCardzcom_rss.xml"); $r->rss2(); $r->setUrlFile("https://www.epochtimes.jp/nimpart.xml", "epochtimes_rss.xml"); $r->rss2(); $r->setUrlFile("https://www.mt-pharma.co.jp/rss/feed.php/release.xml", "TanabeMitsubishi_rss.xml"); $r->rss2(); $r->setUrlFile("https://www.nipponsanso-hd.co.jp/rss.aspx?moduleid=860&portalid=0", "nipponsanso_rss.xml"); $r->rss2(); $r->setUrlFile("https://www.mhi.com/jp/rss/mhi_news.xml", "mitsubishi_jyuko_rss.xml"); $r->rss2(); $r->setUrlFile("https://www.uvex-safety.com/blog/feed/", "uvex-safety_rss.xml"); $r->rss2(); $r->setUrlFile("https://ja.blog.documentfoundation.org/feed/", "LibreOffice_ja_blog_rss.xml"); $r->rss2(); $r->setUrlFile("https://feed.infoq.com/jp", "InfoQ_ja_rss.xml"); $r->rss2(); $r->setUrlFile("https://www.aljazeera.com/xml/rss/all.xml", "aljazeera_rss.xml"); $r->rss2(); $r->setUrlFile("http://feeds.afpbb.com/rss/afpbb/afpbbnews", "afpbbnews_rss.xml"); $r->rss2(); $r->setUrlFile("https://www.meti.go.jp/ml_index_release_atom.xml", "panasonic_atom_rss.xml"); $r->atom4287(); $r->setUrlFile("https://www.denso.com/jp/ja/news/newsroom/rssnews/", "DENSO_atom_rss.xml"); $r->atom4287(); $r->close_db(); exit(); ?> ubuntu@u2204:~/NetBeansProjects/PhpProject10$ cat rss.php <?php require "vendor/autoload.php"; use Abraham\TwitterOAuth\TwitterOAuth; /** * Description of rss * * @author ubuntu */ class rss { //put your code here private $rssURL = null; private $rssFile = null; private SQLite3 $db; private $consumerKey = null; private $consumerSecret = null; private $accessToken = null; private $accessTokenSecret = null; private TwitterOAuth $oAuth; private $link = null; private $hizuke = null; public $isTwitterPost = true; public function setValues($url, $file, $ck, $cs, $at, $ats) { $this->setUrlFile($url,$file); $this->consumerKey = $ck; $this->consumerSecret = $cs; $this->accessToken = $at; $this->accessTokenSecret = $ats; } public function setUrlFile($url, $file) { $this->rssURL = $url; $this->rssFile = './RSS/' . $file; } // rss version="1.0" public function rss1() { $this->DownLoad(); $class_name = 'SimpleXMLElement'; //----- Load xml file ------- $sxml = simplexml_load_file($this->rssFile, $class_name, 0, 'http://purl.org/rss/1.0/', false); print "--------- SELECT result ---------\n"; foreach ($sxml->item as $i) { $this->hizuke = $this->getHizuke($i); if ($this->dbUpdate($i)) { $this->twitterPost($i); //------- twitter statuses/update ------- } } } // rss version="2.0" public function rss2() { $this->DownLoad(); $class_name = 'SimpleXMLElement'; //----- Load xml file ------- $sxml = simplexml_load_file($this->rssFile, $class_name, 0, null, true); print "--------- SELECT result ---------\n"; foreach ($sxml->channel->item as $i) { $this->hizuke = $this->getHizuke($i); if ($this->dbUpdate($i)) { $this->twitterPost($i); //------- twitter statuses/update ------- } } } // atomが対応してるサイト // https://www.meti.go.jp/ml_index_release_atom.xml public function atom4287() { // https://datatracker.ietf.org/doc/html/rfc4287 $this->DownLoad(); $class_name = 'SimpleXMLElement'; //----- Load xml file ------- $sxml = simplexml_load_file($this->rssFile, $class_name, 0, 'http://www.w3.org/2005/Atom', false); print "--------- SELECT result ---------\n"; foreach ($sxml->entry as $i) { if ($this->dbUpdate($i)) { $this->twitterPost($i); //------- twitter statuses/update ------- } } } private function setLink($i) { if (isset($i->link)) { $this->link = $i->link->__toString(); if (strstr($this->link, 'http')) { return; // RSS Version 1.0 or 2.0 } if (isset($i->link->attributes()->href)) { $this->link = $i->link->attributes()->href->__toString(); return; // Atom } return; } } private function getHizuke($i) { if (isset($i->pubDate)) { // RSS Version 2.0 return $i->pubDate; } $idc = $i->children('http://purl.org/dc/elements/1.1/', false); if (isset($idc->date)) { return $idc->date; // RSS Version 1.0 } if (isset($i->updated)) { $hizuke = $i->updated->__toString(); return $hizuke; // Atom } } private function isNewHizuke($d, $r) {// db , rss $timeD = strtotime($d); if ($timeD === false) { return false;//　RSSに時刻の要素が無い } $timeR = strtotime($r); if ($timeR === false) { return false;//　RSSに時刻の要素が無い } if ($timeD >= $timeR) { return false; } return true; } public function test_isNewHizuke() {//日付の書き方毎にテストしているとキリがない。 if ($this->isNewHizuke("Fri, 03 Dec 2021 14:02:56 +0900", "Fri, 17 Dec 2021 15:07:42 +0900")) { print "isNewHizuke 1/3 ok RSSの日付が新しい Fri, 17 Dec 2021 15:07:42 +0900\n"; } else { print "isNewHizuke 1/3 NG\n"; } if ($this->isNewHizuke("Fri, 17 Dec 2021 15:07:42 +0900", "Fri, 03 Dec 2021 14:02:56 +0900")) { print "isNewHizuke 2/3 NG\n"; } else { print "isNewHizuke 2/3 ok RSSの日付が古い\n"; } if ($this->isNewHizuke("Fri, 03 Dec 2021 14:02:56 +0900", "Fri, 03 Dec 2021 14:02:56 +0900")) { print "isNewHizuke 3/3 NG\n"; } else { print "isNewHizuke 3/3 ok 同じ日付\n"; } if ($this->isNewHizuke("2021-12-22T03:30:00Z", "2021-12-22T03:31:00Z")) { print "isNewHizuke 1/3 ok RSSの日付が新しい 2021-12-22T03:31:00Z\n"; } else { print "isNewHizuke 1/3 NG\n"; } if ($this->isNewHizuke("2021-12-22T03:31:00Z", "2021-12-22T03:30:00Z")) { print "isNewHizuke 2/3 NG\n"; } else { print "isNewHizuke 2/3 ok RSSの日付が古い\n"; } if ($this->isNewHizuke("2021-12-22T03:30:00Z", "2021-12-22T03:30:00Z")) { print "isNewHizuke 3/3 NG\n"; } else { print "isNewHizuke 3/3 ok 同じ日付\n"; } if ($this->isNewHizuke("Mon, 15 Nov 2021 20:00:51 +0000", "Mon, 15 Nov 2021 20:00:52 +0000")) { print "isNewHizuke 1/3 ok RSSの日付が新しい Mon, 15 Nov 2021 20:00:52 +0000\n"; } else { print "isNewHizuke 1/3 NG\n"; } if ($this->isNewHizuke("Mon, 15 Nov 2021 20:00:52 +0000", "Mon, 15 Nov 2021 20:00:51 +0000")) { print "isNewHizuke 2/3 NG\n"; } else { print "isNewHizuke 2/3 ok RSSの日付が古い\n"; } if ($this->isNewHizuke("Mon, 15 Nov 2021 20:00:51 +0000", "Mon, 15 Nov 2021 20:00:51 +0000")) { print "isNewHizuke 3/3 NG\n"; } else { print "isNewHizuke 3/3 ok 同じ日付\n"; } if ($this->isNewHizuke("2021-12-31T20:43:18.000Z", "2021-12-31T20:43:19.000Z")) { print "isNewHizuke 1/3 ok RSSの日付が新しい 2021-12-31T20:43:18.000Z\n"; } else { print "isNewHizuke 1/3 NG\n"; } if ($this->isNewHizuke("2021-12-31T20:43:18.000Z", "2021-12-31T20:43:17.000Z")) { print "isNewHizuke 2/3 NG\n"; } else { print "isNewHizuke 2/3 ok RSSの日付が古い\n"; } if ($this->isNewHizuke("2021-12-31T20:43:17.000Z", "2021-12-31T20:43:17.000Z")) { print "isNewHizuke 3/3 NG\n"; } else { print "isNewHizuke 3/3 ok 同じ日付\n"; } if ($this->isNewHizuke("Tue, 28 Dec 2021 15:30:00 JST", "Tue, 28 Dec 2021 15:30:01 JST")) { print "isNewHizuke 1/3 ok RSSの日付が新しい Tue, 28 Dec 2021 15:30:01 JST\n"; } else { print "isNewHizuke 1/3 NG\n"; } if ($this->isNewHizuke("Tue, 28 Dec 2021 15:30:02 JST", "Tue, 28 Dec 2021 15:30:01 JST")) { print "isNewHizuke 2/3 NG\n"; } else { print "isNewHizuke 2/3 ok RSSの日付が古い\n"; } if ($this->isNewHizuke("Tue, 28 Dec 2021 15:30:02 JST", "Tue, 28 Dec 2021 15:30:02 JST")) { print "isNewHizuke 3/3 NG\n"; } else { print "isNewHizuke 3/3 ok 同じ日付\n"; } print "isNewHizuke 単体テスト終了\n"; } private function isFuture() { // 2022.01.08 当functionはe-stat限定。 if( ! strstr( $this->link,"www.e-stat.go.jp")){ return false; } $now = time();//1970 年 1 月 1 日 00:00:00 GMT からの通算秒。 $rssDate = strtotime($this->hizuke); if( $now < $rssDate ){ return true; } return false; } public function create_table() { // https://www.php.net/manual/ja/sqlite3.construct.php $this->db = new SQLite3('mysqlitedb.db'); // open Database $this->db->enableExceptions(true); // テーブル名の一覧を取得 $sql = 'select name from sqlite_master where type="table";'; $ret = $this->db->query($sql); $tableName = null; while ($row = $ret->fetchArray()) { if ($row['name'] == 'rss') { // rssテーブルが作成されていた $tableName = $row['name']; break; } } if ($tableName != 'rss') { // rssテーブルがない $sql = 'CREATE TABLE rss (title TEXT, link TEXT PRIMARY KEY, date TEXT);'; $ret = $this->db->exec($sql); } } private function dbUpdate_20211210($i, $hizuke) { $sql = 'INSERT INTO rss VALUES ("' . htmlspecialchars($i->title, ENT_QUOTES) . '","' . $i->link . '","' . $hizuke . '");'; $this->db->enableExceptions(true); try { $this->db->query($sql); } catch (Exception $e) { print date("Y-m-d H:i:s") . " " . $this->smallMSG($e, $e->getMessage()) . ":" . $sql . "\n"; return false; // 登録済みURLがあれば、つぶやかない。 } return true; } private function dbQuery($sql) { try { $this->db->query($sql); } catch (Exception $e) { print date("Y-m-d H:i:s") . " " . $this->smallMSG($e, $e->getMessage()) . ":" . $sql . "\n"; return false; } return true; // DB更新　呟く } private function dbUpdate($i) { $this->setLink($i); $this->hizuke = $this->getHizuke($i); if( $this->isFuture()){ return false; } $sqls = 'SELECT * FROM rss WHERE link ="' . $this->link . '";'; try { $result = $this->db->query($sqls); } catch (Exception $e) { print date("Y-m-d H:i:s") . " " . $this->smallMSG($e, $e->getMessage()) . ":" . $sqls . "\n"; return false; // SELECTが失敗した。 } $data = $result->fetchArray(); if (false === $data) {// 新規のデータ $sqli = 'INSERT INTO rss VALUES ("' . htmlspecialchars($i->title, ENT_QUOTES) . '","' . $this->link . '","' . $this->hizuke . '");'; return $this->dbQuery($sqli); } else { if ($this->isNewHizuke($data['date'], $this->hizuke)) { $sqlu = 'UPDATE rss SET date = "' . $this->hizuke . '" WHERE link ="' . $this->link . '";'; return $this->dbQuery($sqlu); } print $data['date'] . " " . $data['title'] . " " . $data['link'] . "\n"; } return false; // 自信ない場合はfalseで呟かない。 } public function close_db() { $ret = $this->db->close(); return; } private function DownLoad() { $ch = curl_init(); curl_setopt($ch, CURLOPT_URL, $this->rssURL); curl_setopt($ch, CURLOPT_HEADER, false); $fh = fopen($this->rssFile, 'w'); curl_setopt($ch, CURLOPT_FILE, $fh); curl_setopt($ch, CURLOPT_HTTPHEADER, [ 'User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Firefox/102.0', 'Accept: text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,*/*;q=0.8' // Accept-Language: ja,en-US;q=0.7,en;q=0.3 // Accept-Encoding: gzip, deflate, br // Alt-Used: blogs.windows.com // Connection: keep-alive // Upgrade-Insecure-Requests: 1 // Sec-Fetch-Dest: document // Sec-Fetch-Mode: navigate // Sec-Fetch-Site: none // Sec-Fetch-User: ?1 // TE: trailers ]); curl_setopt($ch, CURLOPT_FOLLOWLOCATION, true); curl_exec($ch); // URLのRSSの内容を取得 curl_close($ch); // cURL リソースを閉じ、システムリソースを解放します fclose($fh); } public function TwiOAuth() { $this->oAuth = new TwitterOAuth($this->consumerKey, $this->consumerSecret, $this->accessToken, $this->accessTokenSecret); $this->oAuth->setTimeouts(40, 60); // ここまでの処理に通信（ TwitterOAuth::request ）は行われなかった。2021.10.28 } private function twitterPost($i) { if( ! $this->isTwitterPost ){ return ; } $len = strlen($i->title); if( 170 < $len ){ $i->title = substr( $i->title , 0, 170); } $statusStr = $i->title . " " . $this->hizuke . " " . $this->link . " RSSNEWS001"; $resMixed = $this->oAuth->post('statuses/update', array( 'status' => $statusStr)); if (isset($resMixed->errors)) { print(date("Y-m-d H:i:s") . " " . $statusStr . "\n"); print_r($resMixed); exit(1); //エラー終了 } print "post statuses/update:" . $statusStr . "\n"; } private function smallMSG($e, $msg) { if (false === strpos($msg, 'UNIQUE constraint failed', 0)) { return $e->getMessage(); } else { return '<UNIQUE>'; } } } ?>ubuntu@u2204:~/NetBeansProjects/PhpProject10$

■過去プログ、参考URL、作業ログ
(ﾟωﾟ) arConsumerKey変数の宣言等は過去記事を検索。
ubuntu-20.04 ツイッターのアプリをPHPで作ってみよう
日付: 6/08/2020 02:03:00 午後

ubuntu-20.04-desktop-amd64.iso にphp8.0をインストール。NetbeansでFinish Debugger Sessionできない時の対処
日付: 7/15/2021 09:22:00 午前

https://www.irasutoya.com/2016/01/blog-post_551.html
頭の悪い青い鳥のイラスト | かわいいフリー素材集 いらすとや

dBaseはSQLが使えなかった。列名だけ割り当てたdbfファイルを作成しただけで使うのをやめる。LibeOffice Baseはdbfファイルに対応していた。
https://www.php.net/manual/ja/book.dbase.php
インストール作業のコマンド履歴を貼っておく。
############################################################# # # dbaseのインストール方法は、phpのホームページに書いてある。 # ############################################################# buntu@ubuntu-VirtualBox:~/NetBeansProjects/PhpProject8$ sudo pecl install dbase [sudo] ubuntu のパスワード: downloading dbase-7.1.1.tgz ... Starting to download dbase-7.1.1.tgz (37,583 bytes) ..........done: 37,583 bytes 18 source files, building running: phpize Configuring for: PHP Api Version: 20200930 Zend Module Api No: 20200930 Zend Extension Api No: 420200930 building in /tmp/pear/temp/pear-build-rootBYKkpy/dbase-7.1.1 running: /tmp/pear/temp/dbase/configure --with-php-config=/usr/bin/php-config checking for grep that handles long lines and -e... /usr/bin/grep checking for egrep... /usr/bin/grep -E checking for a sed that does not truncate output... /usr/bin/sed checking for pkg-config... /usr/bin/pkg-config checking pkg-config is at least version 0.9.0... yes checking for cc... cc checking whether the C compiler works... yes checking for C compiler default output file name... a.out checking for suffix of executables... checking whether we are cross compiling... no checking for suffix of object files... o checking whether we are using the GNU C compiler... yes checking whether cc accepts -g... yes checking for cc option to accept ISO C89... none needed checking how to run the C preprocessor... cc -E checking for icc... no checking for suncc... no checking for system library directory... lib checking if compiler supports -R... no checking if compiler supports -Wl,-rpath,... yes checking build system type... x86_64-pc-linux-gnu checking host system type... x86_64-pc-linux-gnu checking target system type... x86_64-pc-linux-gnu checking for PHP prefix... /usr checking for PHP includes... -I/usr/include/php/20200930 -I/usr/include/php/20200930/main -I/usr/include/php/20200930/TSRM -I/usr/include/php/20200930/Zend -I/usr/include/php/20200930/ext -I/usr/include/php/20200930/ext/date/lib checking for PHP extension directory... /usr/lib/php/20200930 checking for PHP installed headers prefix... /usr/include/php/20200930 checking if debug is enabled... no checking if zts is enabled... no checking for gawk... no checking for nawk... nawk checking if nawk is broken... no checking whether to enable dbase support... yes, shared checking how to print strings... printf checking for a sed that does not truncate output... (cached) /usr/bin/sed checking for fgrep... /usr/bin/grep -F checking for ld used by cc... /usr/bin/ld checking if the linker (/usr/bin/ld) is GNU ld... yes checking for BSD- or MS-compatible name lister (nm)... /usr/bin/nm -B checking the name lister (/usr/bin/nm -B) interface... BSD nm checking whether ln -s works... yes checking the maximum length of command line arguments... 1572864 checking how to convert x86_64-pc-linux-gnu file names to x86_64-pc-linux-gnu format... func_convert_file_noop checking how to convert x86_64-pc-linux-gnu file names to toolchain format... func_convert_file_noop checking for /usr/bin/ld option to reload object files... -r checking for objdump... objdump checking how to recognize dependent libraries... pass_all checking for dlltool... no checking how to associate runtime and link libraries... printf %s\n checking for ar... ar checking for archiver @FILE support... @ checking for strip... strip checking for ranlib... ranlib checking for gawk... (cached) nawk checking command to parse /usr/bin/nm -B output from cc object... ok checking for sysroot... no checking for a working dd... /usr/bin/dd checking how to truncate binary pipes... /usr/bin/dd bs=4096 count=1 checking for mt... mt checking if mt is a manifest tool... no checking for ANSI C header files... yes checking for sys/types.h... yes checking for sys/stat.h... yes checking for stdlib.h... yes checking for string.h... yes checking for memory.h... yes checking for strings.h... yes checking for inttypes.h... yes checking for stdint.h... yes checking for unistd.h... yes checking for dlfcn.h... yes checking for objdir... .libs checking if cc supports -fno-rtti -fno-exceptions... no checking for cc option to produce PIC... -fPIC -DPIC checking if cc PIC flag -fPIC -DPIC works... yes checking if cc static flag -static works... yes checking if cc supports -c -o file.o... yes checking if cc supports -c -o file.o... (cached) yes checking whether the cc linker (/usr/bin/ld -m elf_x86_64) supports shared libraries... yes checking whether -lc should be explicitly linked in... no checking dynamic linker characteristics... GNU/Linux ld.so checking how to hardcode library paths into programs... immediate checking whether stripping libraries is possible... yes checking if libtool supports shared libraries... yes checking whether to build shared libraries... yes checking whether to build static libraries... no configure: patching config.h.in configure: creating ./config.status config.status: creating config.h config.status: executing libtool commands running: make /bin/bash /tmp/pear/temp/pear-build-rootBYKkpy/dbase-7.1.1/libtool --mode=compile cc -I. -I/tmp/pear/temp/dbase -I/tmp/pear/temp/pear-build-rootBYKkpy/dbase-7.1.1/include -I/tmp/pear/temp/pear-build-rootBYKkpy/dbase-7.1.1/main -I/tmp/pear/temp/dbase -I/usr/include/php/20200930 -I/usr/include/php/20200930/main -I/usr/include/php/20200930/TSRM -I/usr/include/php/20200930/Zend -I/usr/include/php/20200930/ext -I/usr/include/php/20200930/ext/date/lib -DHAVE_CONFIG_H -g -O2 -c /tmp/pear/temp/dbase/dbf_head.c -o dbf_head.lo libtool: compile: cc -I. -I/tmp/pear/temp/dbase -I/tmp/pear/temp/pear-build-rootBYKkpy/dbase-7.1.1/include -I/tmp/pear/temp/pear-build-rootBYKkpy/dbase-7.1.1/main -I/tmp/pear/temp/dbase -I/usr/include/php/20200930 -I/usr/include/php/20200930/main -I/usr/include/php/20200930/TSRM -I/usr/include/php/20200930/Zend -I/usr/include/php/20200930/ext -I/usr/include/php/20200930/ext/date/lib -DHAVE_CONFIG_H -g -O2 -c /tmp/pear/temp/dbase/dbf_head.c -fPIC -DPIC -o .libs/dbf_head.o /bin/bash /tmp/pear/temp/pear-build-rootBYKkpy/dbase-7.1.1/libtool --mode=compile cc -I. -I/tmp/pear/temp/dbase -I/tmp/pear/temp/pear-build-rootBYKkpy/dbase-7.1.1/include -I/tmp/pear/temp/pear-build-rootBYKkpy/dbase-7.1.1/main -I/tmp/pear/temp/dbase -I/usr/include/php/20200930 -I/usr/include/php/20200930/main -I/usr/include/php/20200930/TSRM -I/usr/include/php/20200930/Zend -I/usr/include/php/20200930/ext -I/usr/include/php/20200930/ext/date/lib -DHAVE_CONFIG_H -g -O2 -c /tmp/pear/temp/dbase/dbf_rec.c -o dbf_rec.lo libtool: compile: cc -I. -I/tmp/pear/temp/dbase -I/tmp/pear/temp/pear-build-rootBYKkpy/dbase-7.1.1/include -I/tmp/pear/temp/pear-build-rootBYKkpy/dbase-7.1.1/main -I/tmp/pear/temp/dbase -I/usr/include/php/20200930 -I/usr/include/php/20200930/main -I/usr/include/php/20200930/TSRM -I/usr/include/php/20200930/Zend -I/usr/include/php/20200930/ext -I/usr/include/php/20200930/ext/date/lib -DHAVE_CONFIG_H -g -O2 -c /tmp/pear/temp/dbase/dbf_rec.c -fPIC -DPIC -o .libs/dbf_rec.o /bin/bash /tmp/pear/temp/pear-build-rootBYKkpy/dbase-7.1.1/libtool --mode=compile cc -I. -I/tmp/pear/temp/dbase -I/tmp/pear/temp/pear-build-rootBYKkpy/dbase-7.1.1/include -I/tmp/pear/temp/pear-build-rootBYKkpy/dbase-7.1.1/main -I/tmp/pear/temp/dbase -I/usr/include/php/20200930 -I/usr/include/php/20200930/main -I/usr/include/php/20200930/TSRM -I/usr/include/php/20200930/Zend -I/usr/include/php/20200930/ext -I/usr/include/php/20200930/ext/date/lib -DHAVE_CONFIG_H -g -O2 -c /tmp/pear/temp/dbase/dbf_misc.c -o dbf_misc.lo libtool: compile: cc -I. -I/tmp/pear/temp/dbase -I/tmp/pear/temp/pear-build-rootBYKkpy/dbase-7.1.1/include -I/tmp/pear/temp/pear-build-rootBYKkpy/dbase-7.1.1/main -I/tmp/pear/temp/dbase -I/usr/include/php/20200930 -I/usr/include/php/20200930/main -I/usr/include/php/20200930/TSRM -I/usr/include/php/20200930/Zend -I/usr/include/php/20200930/ext -I/usr/include/php/20200930/ext/date/lib -DHAVE_CONFIG_H -g -O2 -c /tmp/pear/temp/dbase/dbf_misc.c -fPIC -DPIC -o .libs/dbf_misc.o /bin/bash /tmp/pear/temp/pear-build-rootBYKkpy/dbase-7.1.1/libtool --mode=compile cc -I. -I/tmp/pear/temp/dbase -I/tmp/pear/temp/pear-build-rootBYKkpy/dbase-7.1.1/include -I/tmp/pear/temp/pear-build-rootBYKkpy/dbase-7.1.1/main -I/tmp/pear/temp/dbase -I/usr/include/php/20200930 -I/usr/include/php/20200930/main -I/usr/include/php/20200930/TSRM -I/usr/include/php/20200930/Zend -I/usr/include/php/20200930/ext -I/usr/include/php/20200930/ext/date/lib -DHAVE_CONFIG_H -g -O2 -c /tmp/pear/temp/dbase/dbf_ndx.c -o dbf_ndx.lo libtool: compile: cc -I. -I/tmp/pear/temp/dbase -I/tmp/pear/temp/pear-build-rootBYKkpy/dbase-7.1.1/include -I/tmp/pear/temp/pear-build-rootBYKkpy/dbase-7.1.1/main -I/tmp/pear/temp/dbase -I/usr/include/php/20200930 -I/usr/include/php/20200930/main -I/usr/include/php/20200930/TSRM -I/usr/include/php/20200930/Zend -I/usr/include/php/20200930/ext -I/usr/include/php/20200930/ext/date/lib -DHAVE_CONFIG_H -g -O2 -c /tmp/pear/temp/dbase/dbf_ndx.c -fPIC -DPIC -o .libs/dbf_ndx.o /bin/bash /tmp/pear/temp/pear-build-rootBYKkpy/dbase-7.1.1/libtool --mode=compile cc -I. -I/tmp/pear/temp/dbase -I/tmp/pear/temp/pear-build-rootBYKkpy/dbase-7.1.1/include -I/tmp/pear/temp/pear-build-rootBYKkpy/dbase-7.1.1/main -I/tmp/pear/temp/dbase -I/usr/include/php/20200930 -I/usr/include/php/20200930/main -I/usr/include/php/20200930/TSRM -I/usr/include/php/20200930/Zend -I/usr/include/php/20200930/ext -I/usr/include/php/20200930/ext/date/lib -DHAVE_CONFIG_H -g -O2 -c /tmp/pear/temp/dbase/dbase.c -o dbase.lo libtool: compile: cc -I. -I/tmp/pear/temp/dbase -I/tmp/pear/temp/pear-build-rootBYKkpy/dbase-7.1.1/include -I/tmp/pear/temp/pear-build-rootBYKkpy/dbase-7.1.1/main -I/tmp/pear/temp/dbase -I/usr/include/php/20200930 -I/usr/include/php/20200930/main -I/usr/include/php/20200930/TSRM -I/usr/include/php/20200930/Zend -I/usr/include/php/20200930/ext -I/usr/include/php/20200930/ext/date/lib -DHAVE_CONFIG_H -g -O2 -c /tmp/pear/temp/dbase/dbase.c -fPIC -DPIC -o .libs/dbase.o /bin/bash /tmp/pear/temp/pear-build-rootBYKkpy/dbase-7.1.1/libtool --mode=compile cc -I. -I/tmp/pear/temp/dbase -I/tmp/pear/temp/pear-build-rootBYKkpy/dbase-7.1.1/include -I/tmp/pear/temp/pear-build-rootBYKkpy/dbase-7.1.1/main -I/tmp/pear/temp/dbase -I/usr/include/php/20200930 -I/usr/include/php/20200930/main -I/usr/include/php/20200930/TSRM -I/usr/include/php/20200930/Zend -I/usr/include/php/20200930/ext -I/usr/include/php/20200930/ext/date/lib -DHAVE_CONFIG_H -g -O2 -c /tmp/pear/temp/dbase/gregor.c -o gregor.lo libtool: compile: cc -I. -I/tmp/pear/temp/dbase -I/tmp/pear/temp/pear-build-rootBYKkpy/dbase-7.1.1/include -I/tmp/pear/temp/pear-build-rootBYKkpy/dbase-7.1.1/main -I/tmp/pear/temp/dbase -I/usr/include/php/20200930 -I/usr/include/php/20200930/main -I/usr/include/php/20200930/TSRM -I/usr/include/php/20200930/Zend -I/usr/include/php/20200930/ext -I/usr/include/php/20200930/ext/date/lib -DHAVE_CONFIG_H -g -O2 -c /tmp/pear/temp/dbase/gregor.c -fPIC -DPIC -o .libs/gregor.o /bin/bash /tmp/pear/temp/pear-build-rootBYKkpy/dbase-7.1.1/libtool --mode=link cc -shared -I/tmp/pear/temp/pear-build-rootBYKkpy/dbase-7.1.1/include -I/tmp/pear/temp/pear-build-rootBYKkpy/dbase-7.1.1/main -I/tmp/pear/temp/dbase -I/usr/include/php/20200930 -I/usr/include/php/20200930/main -I/usr/include/php/20200930/TSRM -I/usr/include/php/20200930/Zend -I/usr/include/php/20200930/ext -I/usr/include/php/20200930/ext/date/lib -DHAVE_CONFIG_H -g -O2 -o dbase.la -export-dynamic -avoid-version -prefer-pic -module -rpath /tmp/pear/temp/pear-build-rootBYKkpy/dbase-7.1.1/modules dbf_head.lo dbf_rec.lo dbf_misc.lo dbf_ndx.lo dbase.lo gregor.lo libtool: link: cc -shared -fPIC -DPIC .libs/dbf_head.o .libs/dbf_rec.o .libs/dbf_misc.o .libs/dbf_ndx.o .libs/dbase.o .libs/gregor.o -g -O2 -Wl,-soname -Wl,dbase.so -o .libs/dbase.so libtool: link: ( cd ".libs" && rm -f "dbase.la" && ln -s "../dbase.la" "dbase.la" ) /bin/bash /tmp/pear/temp/pear-build-rootBYKkpy/dbase-7.1.1/libtool --mode=install cp ./dbase.la /tmp/pear/temp/pear-build-rootBYKkpy/dbase-7.1.1/modules libtool: install: cp ./.libs/dbase.so /tmp/pear/temp/pear-build-rootBYKkpy/dbase-7.1.1/modules/dbase.so libtool: install: cp ./.libs/dbase.lai /tmp/pear/temp/pear-build-rootBYKkpy/dbase-7.1.1/modules/dbase.la libtool: finish: PATH="/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/snap/bin:/sbin" ldconfig -n /tmp/pear/temp/pear-build-rootBYKkpy/dbase-7.1.1/modules ---------------------------------------------------------------------- Libraries have been installed in: /tmp/pear/temp/pear-build-rootBYKkpy/dbase-7.1.1/modules If you ever happen to want to link against installed libraries in a given directory, LIBDIR, you must either use libtool, and specify the full pathname of the library, or use the '-LLIBDIR' flag during linking and do at least one of the following: - add LIBDIR to the 'LD_LIBRARY_PATH' environment variable during execution - add LIBDIR to the 'LD_RUN_PATH' environment variable during linking - use the '-Wl,-rpath -Wl,LIBDIR' linker flag - have your system administrator add LIBDIR to '/etc/ld.so.conf' See any operating system documentation about shared libraries for more information, such as the ld(1) and ld.so(8) manual pages. ---------------------------------------------------------------------- Build complete. Don't forget to run 'make test'. running: make INSTALL_ROOT="/tmp/pear/temp/pear-build-rootBYKkpy/install-dbase-7.1.1" install Installing shared extensions: /tmp/pear/temp/pear-build-rootBYKkpy/install-dbase-7.1.1/usr/lib/php/20200930/ running: find "/tmp/pear/temp/pear-build-rootBYKkpy/install-dbase-7.1.1" | xargs ls -dils 806664 4 drwxr-xr-x 3 root root 4096 11月 2 12:03 /tmp/pear/temp/pear-build-rootBYKkpy/install-dbase-7.1.1 806672 4 drwxr-xr-x 3 root root 4096 11月 2 12:03 /tmp/pear/temp/pear-build-rootBYKkpy/install-dbase-7.1.1/usr 806673 4 drwxr-xr-x 3 root root 4096 11月 2 12:03 /tmp/pear/temp/pear-build-rootBYKkpy/install-dbase-7.1.1/usr/lib 806674 4 drwxr-xr-x 3 root root 4096 11月 2 12:03 /tmp/pear/temp/pear-build-rootBYKkpy/install-dbase-7.1.1/usr/lib/php 806675 4 drwxr-xr-x 2 root root 4096 11月 2 12:03 /tmp/pear/temp/pear-build-rootBYKkpy/install-dbase-7.1.1/usr/lib/php/20200930 794423 284 -rwxr-xr-x 1 root root 288584 11月 2 12:03 /tmp/pear/temp/pear-build-rootBYKkpy/install-dbase-7.1.1/usr/lib/php/20200930/dbase.so Build process completed successfully Installing '/usr/lib/php/20200930/dbase.so' install ok: channel://pecl.php.net/dbase-7.1.1 configuration option "php_ini" is not set to php.ini location You should add "extension=dbase.so" to php.ini ubuntu@ubuntu-VirtualBox:~/NetBeansProjects/PhpProject8$ ls -la /usr/lib/php/20200930/dbase.so -rw-r--r-- 1 root root 288584 11月 2 12:03 /usr/lib/php/20200930/dbase.so ubuntu@ubuntu-VirtualBox:~/NetBeansProjects/PhpProject8$ ############################################################# # # CLIのPHPのiniファイルの置き場所を確認する方法 # ############################################################# root@ubuntu-VirtualBox:/etc/php/8.0/cli# php --ini Configuration File (php.ini) Path: /etc/php/8.0/cli Loaded Configuration File: /etc/php/8.0/cli/php.ini Scan for additional .ini files in: /etc/php/8.0/cli/conf.d Additional .ini files parsed: /etc/php/8.0/cli/conf.d/10-opcache.ini, /etc/php/8.0/cli/conf.d/10-pdo.ini, /etc/php/8.0/cli/conf.d/15-xml.ini, /etc/php/8.0/cli/conf.d/20-calendar.ini, /etc/php/8.0/cli/conf.d/20-ctype.ini, /etc/php/8.0/cli/conf.d/20-curl.ini, /etc/php/8.0/cli/conf.d/20-dom.ini, /etc/php/8.0/cli/conf.d/20-exif.ini, /etc/php/8.0/cli/conf.d/20-ffi.ini, /etc/php/8.0/cli/conf.d/20-fileinfo.ini, /etc/php/8.0/cli/conf.d/20-ftp.ini, /etc/php/8.0/cli/conf.d/20-gettext.ini, /etc/php/8.0/cli/conf.d/20-iconv.ini, /etc/php/8.0/cli/conf.d/20-mbstring.ini, /etc/php/8.0/cli/conf.d/20-phar.ini, /etc/php/8.0/cli/conf.d/20-posix.ini, /etc/php/8.0/cli/conf.d/20-readline.ini, /etc/php/8.0/cli/conf.d/20-shmop.ini, /etc/php/8.0/cli/conf.d/20-simplexml.ini, /etc/php/8.0/cli/conf.d/20-sockets.ini, /etc/php/8.0/cli/conf.d/20-sysvmsg.ini, /etc/php/8.0/cli/conf.d/20-sysvsem.ini, /etc/php/8.0/cli/conf.d/20-sysvshm.ini, /etc/php/8.0/cli/conf.d/20-tokenizer.ini, /etc/php/8.0/cli/conf.d/20-xdebug.ini, /etc/php/8.0/cli/conf.d/20-xmlreader.ini, /etc/php/8.0/cli/conf.d/20-xmlwriter.ini, /etc/php/8.0/cli/conf.d/20-xsl.ini ############################################################# # # dbaseを使うから921行目辺りに、extension行を追加する。 # ############################################################# root@ubuntu-VirtualBox:/etc/php/8.0/cli# diff php.ini.20210702 php.ini 921a922 > extension=dbase.so root@ubuntu-VirtualBox:/etc/php/8.0/cli#

https://www.sqlite.org/draft/chronology.html
History Of SQLite Releases