Tag: ”)

Mysql query loop, resulting row of one query in where statement of next query

Post author By Full Stack
Post date May 31, 2020
No Comments on Mysql query loop, resulting row of one query in where statement of next query

I have a read only table to calculate relationship between people DROP TABLE IF EXISTS `reference`; CREATE TABLE IF NOT EXISTS `reference` ( `self` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `brother` tinytext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci, `mom` tinytext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci, `wife` tinytext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci, PRIMARY KEY […]

Tags `brother` tinytext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci, `mom` tinytext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci, `wife` tinytext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci, `wife`) VALUES ('aunt', '', ''), '') or die('Could not connect to the database server' . mysqli_connect_error()); $input = 'mom brother wife dad'; $array = explode(, ''); What i am Trying to do Example Input : 'mom brother wife dad' step1 - mom's(self) brother(column_name) is uncle(result) step2 - uncl, '3306'), 'aunt', 'brotherinlaw', 'grandmom', 'granduncle', 'greatgrandmom', 'greatgranduncle', 'greatgreatgranduncle', 'mom', 'motherinlaw', 'root', 'sisterinlaw'), 'uncle', $input); $len = count($array); $row = $array[0]; for ($x = 1; $x < $len; $x++) { $column = $array[$x]; if($column=='brother'||$column=='mom'|, BROTHER, db_name = '', I have a read only table to calculate relationship between people DROP TABLE IF EXISTS `reference`; CREATE TABLE IF NOT EXISTS `reference` (, PRIMARY KEY (`self`), so stop looping and call them aunt's relative My current code <?php $db = new mysqli('localhost', UNIQUE KEY `self` (`self`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; INSERT INTO `reference` (`self`, wife

Linux Mastering Development

Using regular expressions (regex) in sed

Post author By Linux Questions
Post date May 28, 2020
No Comments on Using regular expressions (regex) in sed

This is a specific example of a general subject I fail to grasp. For years, I have used regex and sed to find/replace all occurrences of a string in all the files in a directory recursively, using something like this: #FIND $GLOBALS[‘timechecks’] and REPLACE with completely_different_string shopt -s globstar dotglob; for file in /var/www/**/*; do […]

Tags __LINE__, '.', ''), ''\), " but have not found an explanation of the fact this is even a potential problem. Related question: Why is there no generator that accepts t, [ ]basename[(]__FILE__[)][)][;] REGEX DEBUGGER I used a regex debugger for this example, ]'\'''\''[)][, ]'\''\.'\''[, \'\.\', 6, basename(__FILE__)); REGEX I CAME UP WITH NOT WORKING This is just the sed line from my script with the search regex I came up with, basename$__FILE__$\) PROBLEMS WITH OUTPUT FOR REGEX DEBUGGER: First, but it is not working for me. The debugger is at this link. Here is the regex it shows finding my target string: \$GLOBALS\['timechecks\'\]=, but not in my bash script. The regex looks "wrong" when compared to what I have learned to use for regex in bash with sed The regex from th, I cannot figure out a solution to a particular example. TARGET STRING WHERE I AM STUCK $GLOBALS['timechecks']=addTimeCheck_sparky($GLOBALS[, I cannot fix it I think the basic problem I am clueless about converting valid regex from the debugger to work in bash/sed. I searched for, I have used regex and sed to find/replace all occurrences of a string in all the files in a directory recursively, I tried my regex in the de I don't know why the debugger's regex works when I run it there, number_format(microtime(true), there is something basic about using Regex in bash I have got away without knowing. As a result, This is a specific example of a general subject I fail to grasp. For years, to no avail. \$GLOBALS\['\''timechecks'\''\]=addTimeCheck_sparky[(]$GLOBALS\['\''timechecks'\''\][, using something like this: #FIND $GLOBALS['timechecks'] and REPLACE with completely_different_string shopt -s globstar dotglob; for file in, which shows the regex finding my target string

Mastering Development

importing PHP MySql database

Post author By Full Stack
Post date May 26, 2020
No Comments on importing PHP MySql database

I’m trying to import database to phpmyadmin the error is :- “”Error Static analysis: 3 errors were found during analysis. Variable name was expected. (near ” ” at position 5) Variable name was expected. (near ” ” at position 26) Unrecognized statement type. (near “Host” at position 0) SQL query: Host: localhost (Version: 5.6.16) # […]

Tags `adm_pwd` varchar(255) DEFAULT NULL, `adm_user` varchar(255) DEFAULT NULL, `answe3` varchar(255) DEFAULT NULL, `answer` varchar(255) DEFAULT NULL, `answer1` varchar(255) DEFAULT '', `answer2` varchar(255) DEFAULT NULL, `answer4` varchar(255) DEFAULT NULL, `cat_Id` int(11) DEFAULT NULL, `course` varchar(255) DEFAULT NULL, `datetime` datetime DEFAULT NULL, `datetime_posted` timestamp NULL DEFAULT NULL, `dob` date DEFAULT NULL, `email` varchar(255) DEFAULT NULL, `fname` varchar(255) DEFAULT NULL, `image` varchar(255) DEFAULT NULL, `lname` varchar(255) DEFAULT NULL, `message` text, `mname` varchar(255) DEFAULT NULL, `name` varchar(255) DEFAULT NULL, `password` varchar(255) DEFAULT NULL, `phone` int(1) DEFAULT NULL, `pwd` varchar(255) DEFAULT NULL, `question_name` text, `quiz_Id` int(11) DEFAULT NULL, `sub_content` text, `sub_Id` int(11) DEFAULT NULL, `sub_title` varchar(255) DEFAULT NULL, `subject` varchar(255) DEFAULT NULL, `title` varchar(255) DEFAULT NULL, `topic_Id` int(11) DEFAULT NULL, `uname` varchar(255) DEFAULT NULL, `user_id` int(11) DEFAULT NULL, `username` varchar(255) DEFAULT NULL, `yrlvl` varchar(255) DEFAULT NULL, -11, '', ''), '\r\n'] }, '<iframe src=\"https://www.youtube.com/embed/KmCkQEkeVn8\" width=\"560\" height=\"315\" frameborder=\"0\" allowfullscreen=\"allowfullscree, '<iframe src=\"https://www.youtube.com/embed/zg-J7jVNix0\" width=\"560\" height=\"315\" frameborder=\"0\" allowfullscreen=\"allowfullscree, '098f6bcd4621d373cade4e832627b4f6'), '2'); # # Structure for table "tbl_subtopic" # CREATE TABLE `tbl_subtopic` ( `sub_Id` int(11) NOT NULL AUTO_INCREMENT, '2015-04-30', '2015-05-07', '2015-05-08', '2015-05-16 10:10:49', '2015-05-20', '2015-05-30 08:37:01', '2015-05-31 06:00:53', '2015-05-31 09:46:27', '2015-06-01 07:48:26', '2015-06-01 07:48:56', '21232f297a57a5a743894a0e4a801fc3'); # # Structure for table "tbl_answer" # CREATE TABLE `tbl_answer` ( `ans_Id` int(11) NOT NULL AUTO_IN, '47bce5c74f589f4867dbd57e9ca9f808'), '5e8ff9bf55ba3508199d22e984129be6'), 'asd'); # # Structure for table "tbl_quiz" # CREATE TABLE `tbl_quiz` ( `quiz_Id` int(11) NOT NULL AUTO_INCREMENT, 'asd\r\n', 'asdaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa'), 'asdh@yahoo.com', 'BSCS', 'BSIT', 'd2e16e6ef52a45b7468f1da56bba1953');, 'gfgf', 'lorem', 'lorem'); # # Structure for table "tbl_topic" # CREATE TABLE `tbl_topic` ( `topic_Id` int(11) NOT NULL AUTO_INCREMENT, 'lorems', 'Personal Home Page', 'Personal Hypertext Processor', 'PHP: Hypertext Preprocessor', 'Private Home Page', 'sadas'), 'sample@gmail.com', 'sample\r\n', 'sample\r\n\r\nLorem ipsum dolor sit amet, "Admin", "Female"), "Lorem ipsum dolor sit amet..", "Male", "sa", [ "Lorem ipsum... ", //"Sample" }, \r\n\r\nquis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo\r\n\r\nconsequat. Duis aute irure dolor, \r\nquis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo\r\nconsequat. Duis aute irure dolor in reprehenderit, \r\nquis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo\r\nconsequat. Duis aute irure dolor in reprehenderit in voluptate, 0, 0); # # Structure for table "tbl_contact" # CREATE TABLE `tbl_contact` ( `contact_Id` int(11) NOT NULL AUTO_INCREMENT, 0)\">What does PHP stand for?\r\n', 1, 11); # # Structure for table "tbl_teacher" # CREATE TABLE `tbl_teacher` ( `teacher_Id` int(11) NOT NULL AUTO_INCREMENT, 13, 136, 2, 24, 3, 324, 343, 4, 4); # # Structure for table "tbl_user" # CREATE TABLE `tbl_user` ( `user_Id` int(11) NOT NULL AUTO_INCREMENT, 45], 452, 5, 7, aaa, asd*, Comment text, consectetur adipisicing elit, Content TEXT, description text, fg, gender VARCHAR(255) DEFAULT NULL, I'm trying to import database to phpmyadmin the error is :- ""Error Static analysis: 3 errors were found during analysis. Variable name w, NULL); # # Structure for table "tbl_comment" # CREATE TABLE `tbl_comment` ( `comment_Id` int(11) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`adm_Id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1; # # Data for table "tbl_admin" # INSERT INTO `tbl_admin` VA, PRIMARY KEY (`ans_Id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; # # Data for table "tbl_answer" # # # Structure for table "tbl_category" #, PRIMARY KEY (`cat_Id`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1; # # Data for table "tbl_category" # INSERT INTO `tbl_catego, PRIMARY KEY (`comment_Id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1; # # Data for table "tbl_comment" # INSERT INTO `tbl_com, PRIMARY KEY (`contact_Id`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1; # # Data for table "tbl_contact" # INSERT INTO `tbl_con, PRIMARY KEY (`quiz_Id`) ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1; # # Data for table "tbl_quiz" # INSERT INTO `tbl_quiz` VAL, PRIMARY KEY (`sub_Id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1; # # Data for table "tbl_subtopic" # INSERT INTO `tbl_subtop, PRIMARY KEY (`teacher_Id`) ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1; # # Data for table "tbl_teacher" # INSERT INTO `tbl_tea, PRIMARY KEY (`topic_Id`) ) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=latin1; # # Data for table "tbl_topic" # INSERT INTO `tbl_topic`, PRIMARY KEY (`user_Id`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1; # # Data for table "tbl_user" # INSERT INTO `tbl_user` VAL, Programming, samples, sed do eiusmod\r\n\r\ntempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, sed do eiusmod\r\ntempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, sunt in culpa qui officia deserunt mollit anim id est laborum., sunt in culpa qui officia deserunt mollit anim id est laborum.\r\n\r\n \r\n\r\n<a href=\"http://iwantsourcecodes.c, sunt in culpa qui officia deserunt mollit anim id est laborum.\r\n\r\nLorem ipsum dolor sit amet, test

CMS Joomla Mastering Development

What is the simplest way to clear a group’s cache in Joomla via php, when caching disabled?

Post author By Ask Me
Post date May 21, 2020
No Comments on What is the simplest way to clear a group’s cache in Joomla via php, when caching disabled?

So background: I’m making a caching plugin that clears our site and CDN caches when content is saved. In this instance, I want to clear the site cache for one group. My original attempt looked something like this: $cache = JFactory::getCache(‘cachegroup’); $cache->clear(); That didn’t work. I did some research and saw SharkyKZ in the Joomla […]

Tags ''), 'cachebase' => $conf->get('cache_path', 'caching' => true, 'storage' => $conf->get('cache_handler', $options); $cache->clean('cachegroup'); So I have working code, and Like to know if there is a simpler or superior way to accomplish this., but I would... Like to understand why it works, I want to clear the site cache for one group. My original attempt looked something like this: $cache = JFactory::getCache('cachegroup'); $c, JPATH_SITE . '/cache') ); $cache = JCache::getInstance('', So background: I'm making a caching plugin that clears our site and CDN caches when content is saved. In this instance, so I tried adding $cache->setCaching(1); to both sets of code and that didn't work either. Finally I dug into the Joomla code and looked at

User Help Web Apps

Google custom script times out

Post author By Math Dev
Post date April 29, 2020
No Comments on Google custom script times out

This script is used to download pdf attachments from my starred emails in my gmail and names and sorts them into folders in my google drive. It always times out for whatever reason. Any ideas to adjust it so it can finish quicker? var GMAIL_LABEL = ‘Sales’; var GDRIVE_FILE = ‘sales/$y/$sublabel/$sublabel_$m-$d-$y_$mc_$ac.$ext’; /* ————- no changes […]

Tags ''), 'ac': i, 'd': ('00' + (message.getDate().getDate())).slice(-2), 'domain': message.getFrom().split('@')[1].replace(/[^a-zA-Z]+$/, 'ext': getExtension(attachment.getName()), 'h': ('00' + (message.getDate().getHours())).slice(-2), 'i': ('00' + (message.getDate().getMinutes())).slice(-2), 'm': ('00' + (message.getDate().getMonth()+1)).slice(-2), 'mc': j, 's': ('00' + (message.getDate().getSeconds())).slice(-2), 'y': ('0000' + (message.getDate().getFullYear())).slice(-4), } var file = createFilename(GDRIVE_FILE, // domain part of email 'sublabel': label.getName().substr(GMAIL_LABEL.length+1), b) { return b.length - a.length; }); for(var i=0; i function saveAttachment(attachment, file); } message.unstar(); } }, info) { var keys = Object.keys(info); keys.sort(function(a, info); saveAttachment(attachment, label) { var messages = thread.getMessages(); for(var j=0; j var attachments = message.getAttachments(); for(var i=0; i<attachments.length;, path) { var parts = path.split('/'); var file = parts.pop(); var path = parts.join('/'); var folder = getOrMakeFolder(path); var check = fol, perrun); from += perrun; for(var i=0; i<threads.length; i++) { if(!threads[i].hasStarredMessages()) continue; result.push(threads[i]); }, This script is used to download pdf attachments from my starred emails in my gmail and names and sorts them into folders in my google drive., yet. * * @param {string} path * @return {Folder} */ function getOrMakeFolder(path) { var folder = DriveApp.getRootFolder(); var names = path.

Mastering Development

Optimizing SQL query that measures date difference

Post author By Full Stack
Post date April 28, 2020
No Comments on Optimizing SQL query that measures date difference

I am running an SQL SELECT query that potentially could retrieve thousands and tens of thousands of records. I will keep it concise: I need to get only records whose timestamp does not exceed 30 days ago. I currently have 2 queries. One obviously faster than the other, and I’d like to know if it […]

Tags -11, ''), 'yyyy/MM/dd')) < 30 Would you say the "faster" query is good enough? Is there any wise tricks to further optimize this?, "yyyy-MM-dd", 10, 121) < 30 Absolute trash query: select * from someStatusTable where 1=1 and DATEDIFF(day, 127, 99], and I'd like to know if it could be further optimized. Useful information: Example of how the timestamp looks: 2020-03-30-08_50_26_608156 I c, FORMAT (convert(datetime, FORMAT (getdate(), I am running an SQL SELECT query that potentially could retrieve thousands and tens of thousands of records. I will keep it concise: I need t, left(FN_TIME_STAMP, stuff(FN_TIME_STAMP

Mastering Development

SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘laravel.users’ doesn’t exist

Post author By Full Stack
Post date April 20, 2020
No Comments on SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘laravel.users’ doesn’t exist

I want to use the login implemented by default by laravel. My database isn’t called “laravel” and I don’t want to call it in that way, is there a way to do that and still make it work? By default it asks for the “laravel” database which of course doesn’t exist cause I called my […]

Tags '_').'_database_'), ''), '127.0.0.1'), '3306'), 'cache' => [ 'url' => env('REDIS_URL'), 'charset' => 'utf8', 'charset' => 'utf8mb4', 'collation' => 'utf8mb4_unicode_ci', 'database' => env('DB_DATABASE', 'database' => env('REDIS_CACHE_DB', 'database' => env('REDIS_DB', 'default' => [ 'url' => env('REDIS_URL'), 'engine' => null, 'foreign_key_constraints' => env('DB_FOREIGN_KEYS', 'forge'), 'host' => env('DB_HOST', 'host' => env('REDIS_HOST', 'mysql' => [ 'driver' => 'mysql', 'options' => [ 'cluster' => env('REDIS_CLUSTER', 'options' => extension_loaded('pdo_mysql') ? array_filter([ PDO::MYSQL_ATTR_SSL_CA => env('MYSQL_ATTR_SSL_CA'), 'password' => env('DB_PASSWORD', 'password' => env('REDIS_PASSWORD', 'pgsql' => [ 'driver' => 'pgsql', 'phpredis'), 'port' => env('DB_PORT', 'port' => env('REDIS_PORT', 'prefix_indexes' => true, 'prefix' => env('REDIS_PREFIX', 'sqlsrv' => [ 'driver' => 'sqlsrv', 'sslmode' => 'prefer', 'unix_socket' => env('DB_SOCKET', 'url' => env('DATABASE_URL'), 'username' => env('DB_USERNAME', "1433", "strict": true, ], ];, ]) : [], /* |-------------------------------------------------------------------------- | Database Connections |--------------------------------------, /* |-------------------------------------------------------------------------- | Migration Repository Table |--------------------------------, /* |-------------------------------------------------------------------------- | Redis Databases |-------------------------------------------, 0, 1, 5432, 6379), and advanced key-value store that also | provides a richer body of commands than a typical key-value system | such as APC or Memcached. Larav, database_path('database.sqlite')), examples of configuring each database platform that is | supported by Laravel is shown below to make development simple. | | | All database w, fast', I want to use the login implemented by default by laravel. My database isn't called "laravel" and I don't want to call it in that way, is there a way to do that and still make it work? By default it asks for the "laravel" database which of course doesn't exist cause I called, Laravel, localhost, MYSQL, null, prefix, Redis, schema = "public")//, Str::slug(env('APP_NAME', true, we can determine which of | the migrations on disk haven't actually been run in the database. | */ 'migrations' => 'migrations'

Mastering Development

Json field triggered — No Dialect mapping for JDBC type: 1111 from nativeQuery

Post author By Full Stack
Post date April 18, 2020
No Comments on Json field triggered — No Dialect mapping for JDBC type: 1111 from nativeQuery

I have a native query to select datafrom database, I’m using postgrsql, hibernate and spring boot with java … I’m trying to find an user according to some criterias in where clause but i get the “No Dialect mapping for JDBC type: 1111” error caused by the json field, how can i overcome this error? […]

Tags ', ' ', ''), ') && (regexp_split_to_array(replace(regexp_replace('" + user.getlistOperators() + "', '))"; Query query = em.createNativeQuery(sqlString); List resultats = query.getResultList(); em.close(); the user entity has name is a, "w", ]+', address is an address object and phone is a json object. (for some reasons i need to clean the value of listOperators using regular expressi, age is a number, g, hibernate and spring boot with java ... I'm trying to find an user according to some criterias in where clause but i get the "No Dialect mapp, how can i overcome this error? and this is my code: EntityManager em = entityManagerFactory.createEntityManager(); List resultat = new, I have a native query to select datafrom database, I'm using postgrsql, Thanks in advance, u.activated FROM user as u where "; sqlString += "regexp_split_to_array(replace(regexp_replace(phone->> 'operator', u.address, u.age, u.phone

Database Development

calculate running balance of debit credit using union all

Post author By Jessica Alba
Post date April 14, 2020
No Comments on calculate running balance of debit credit using union all

i’m making account statement for which i need that account balance before today and with each transaction row of debit or credit plus and minus from initial opening balance on the basis debit/credit amount rules…. for this i’m using this approach SELECT ‘1’AS VoucherNo,”AS DocumentDate,’Opening’ AS Description,isnull(SUM(JournalDetials.Debit),0)AS Debit, isnull(SUM(JournalDetials.Credit),0)AS Credit,(isnull(SUM(JournalDetials.Debit),0)-isnull(SUM(JournalDetials.Credit),0))[Balance], ”as JournalTransationStatus FROM JournalDetials INNER […]