Genexys

Forget that I get it now, I wanted to delete the topic but since someone else can face this issue one day I'll explain what to do: You just store your files' path one by one in the the db Ex: Lion.jpeg INSERT INTO table_name (column_name) VALUES ('/dir1/dir2/dir3/Lions.jpeg'); Then let's say a user make a search on your website to find this particular item You just concatenate the user's entry to a select query $query = $PDO->query('SELECT * FROM <table_name> WHERE 'File_path' LIKE '%userInput%'); Then there you go you can use this path ($query) to do whatever you want with

I have a website streaming project going on,but there's one thing that stops me from really starting it "HOW TO ADD FILE PATH INTO A MYSQL DB?" since I know it will slow down the sgbd to directly add the file in a longblob field,I need some help on how to retrieve those file path(manually?) Let's say a user enters 'die hard 4' in the search form,Do I concatenate the user's input to a query like $query = 'SELECT * FROM T_DIRECTORIES WHERE DIRECTORIES LIKE 'user_input%'; Then do 'scandir($query); Since I will name my directories as the files it contains

Thanks! I've already solved the problem which was simply because I have two different directory in which there are extensions ,I just specified the one that appears in phpinfo page and all errors were gone,now I simply need some help to add videos path into mysql db to make a streaming website...well that's not the right section(^^) but since you're the only one that answers me,see you in the coding help section to give me some tips!

Php version : 7.2.24 Os:Linux Mint HttpServer:Apache2 Here it is I have a local web server that I'm trying to handle mysql databases with PDO,but I get "Class pdo not found",php7.2-pdo is installed and activated but not loaded,I think I found where the problem is,pdo's extensions are in different directory than usual "usr/include/php/XXXXX/ext/pdo" where "XXXXX" is a number,but I run a phpinfo page the modules that are loaded are in /etc/php/7.2/apache2/conf.d Even if I make sure that extension_dir points to my extensions files it still doesn't work I need some help to fix that,Thanks in advance!!