Recherche avancée

Sur d’autres sites (8867)

• Anomalie #4354 : Problème de recherche REGEX sur la recherche multiterme, c’est la merde

  10 février 2021, par cedric -

  cf #3930 qui signalait le problème deja

  En complèment donc, en mysql
  

  SELECT * FROM `spip_articles` WHERE `chapo` REGEXP ’règles’ 
  

  
  trouve bien les chapo contenant le mot "règles"
  mais
  

  SELECT * FROM `spip_articles` WHERE `chapo` REGEXP ’regles’ 
  

  ne trouve rien,
  pas plus que
  

  SELECT * FROM `spip_articles` WHERE `chapo` REGEXP ’r.gles’ 
  

  et finalement

  SELECT * FROM `spip_articles` WHERE `chapo` REGEXP ’r..?gles’ 
  

  
  trouve aussi

• Anomalie #3418 : Les tables des plugins ne s’installent pas

  9 mai 2015, par Maïeul Rouquette

  Ma config local

  PHP Version 5.2.17

  System Darwin FTSR22998 12.6.0 Darwin Kernel Version 12.6.0 : Wed Mar 18 16:23:48 PDT 2015 ; root:xnu-2050.48.19 1/RELEASE_X86_64 x86_64
  Build Date Sep 18 2013 13:58:06
  Configure Command ’./configure’ ’—with-mysql=/Applications/MAMP/Library’ ’—with-apxs2=/Applications/MAMP/Library/bin/apxs’ ’—with-gd’ ’—with-jpeg-dir=/Applications/MAMP/Library’ ’—with-png-dir=/Applications/MAMP/Library’ ’—with-zlib’ ’—with-freetype-dir=/Applications/MAMP/Library’ ’—prefix=/Applications/MAMP/bin/php/php5.2.17’ ’—exec-prefix=/Applications/MAMP/bin/php/php5.2.17’ ’—sysconfdir=/Applications/MAMP/bin/php/php5.2.17/conf’ ’—with-soap’ ’—with-config-file-path=/Applications/MAMP/bin/php/php5.2.17/conf’ ’—enable-track-vars’ ’—enable-bcmath’ ’—enable-ftp’ ’—enable-gd-native-ttf’ ’—with-bz2=/usr’ ’—with-ldap’ ’—with-mysqli=/Applications/MAMP/Library/bin/mysql_config’ ’—with-sqlite’ ’—with-ttf’ ’—with-t1lib=/Applications/MAMP/Library’ ’—enable-mbstring=all’ ’—with-curl=/Applications/MAMP/Library’ ’—enable-dbx’ ’—enable-sockets’ ’—enable-bcmath’ ’—with-imap=shared,/Applications/MAMP/Library/lib/imap-2007f’ ’—enable-soap’ ’—with-kerberos’ ’—enable-calendar’ ’—with-pgsql=shared,/Applications/MAMP/Library/pg’ ’—enable-dbase’ ’—enable-exif’ ’—with-libxml-dir=/Applications/MAMP/Library’ ’—with-gettext=shared,/Applications/MAMP/Library’ ’—with-xsl=/Applications/MAMP/Library’ ’—with-pdo-mysql=shared,/Applications/MAMP/Library’ ’—with-pdo-pgsql=shared,/Applications/MAMP/Library/pg’ ’—with-mcrypt=shared,/Applications/MAMP/Library’ ’—with-openssl’ ’—enable-zip’ ’—with-iconv=/Applications/MAMP/Library’
  Server API Apache 2.0 Handler
  Virtual Directory Support disabled
  Configuration File (php.ini) Path /Applications/MAMP/bin/php/php5.2.17/conf
  Loaded Configuration File /Applications/MAMP/bin/php/php5.2.17/conf/php.ini
  Scan this dir for additional .ini files (none)
  additional .ini files parsed (none)
  PHP API 20041225
  PHP Extension 20060613
  Zend Extension 220060519
  Debug Build no
  Thread Safety disabled
  Zend Memory Manager enabled
  IPv6 Support enabled
  Registered PHP Streams https, ftps, compress.zlib, compress.bzip2, php, file, data, http, ftp, zip
  Registered Stream Socket Transports tcp, udp, unix, udg, ssl, sslv3, sslv2, tls
  Registered Stream Filters zlib.*, bzip2.*, convert.iconv.*, string.rot13, string.toupper, string.tolower, string.strip_tags, convert.*, consumed

  Mon test
  1) spip 3.1 svn 22109
  2) pas de plugins/auto mais le flux déclaré
  3) plugin tickets mis manuellement dans plugins
  4) j’active le plugin. Il se "préactive" en entendance les dépendances
  5) lorsque j’installe saisies, le plugin tickets peut bien s’activer
  6) mais les tables n’ont pas été installées

• Youtube-DL file download live progress

  7 février 2015, par roshkattu

  I am using the YoutubeDL library in a project. My environment is based on WINDOWS with XAMPP as the webserver boundle (apache,php,mysql,etc). I am using the youtube-dl.exe file to download the video and then use ffmpeg.exe to convert the video to an MP3 audio file.

  At the moment, I have an issue related to programming : I want to show live a progressbar while the video is downloaded with the youtube-dl.exe file. This exe creates a log file, that is updated while the video is downloaded. So my approach on this was to create a PHP file, that opens, parses the log file and get’s the progress percent, and sends it as a json encoded value to an AJAX function that is called every 100MS. Indeed, if the video is too large, there will be a very high ammount of data while polling the PHP file to get the progress state. And sometimes, the browser either crashes or freezes because of this ajax polling.

  My question is : is there any better approach to do this with PHP/AJAX ? Rathar than poll the file every 100MS, or 50MS ?