Categories
CMS Mastering Development Wordpress

Use same slug base for Custom Post Type posts, and multiple taxonomy terms

I have done a lot of digging the past few days, and can come close, but not exactly what I need. I’m trying to alter a custom taxonomy/CPT permalink structure to all use the same slug base: /resources/. CPT: ‘resources’ TAX1, non-hierarchical: ‘type’ TAX2, hierarchical: ‘section’ I need the structure to look like this: /resources/ […]

Categories
CMS Drupal Mastering Development

Nested sidebar module [closed]

Is there a Drupal module that will display a sidebar like the one on https://vulkan-tutorial.com? I have a website that has a lot of content that is nested like a textbook or legal codex. Think chapter, section, subsection, sub-subsection, etc. I’d like to be able to display this neatly as a sidebar. Key features include […]

Categories
Mastering Development

How can I remove the blank gap between the footer and the bottom of the page?

I am currently stuck on a problem. There is a gap between the footer and the bottom of the page. Some information and things I tried and didn’t work out: body and html has 0 margin and 0 padding Change the size of the body trying to change the position of the footer probably some […]

Categories
Mastering Development

How to use group by statement on multiple fields in sql?

I have the following tables: StudentProfile in which I have fields RollNumber, Major StudentEnrollment in which I have fields RollNumber, CourseCode, Section, Semester DepartmentFees in which I have fields DepartmentName, Semester, Fees What I’m trying to do it to find the fees a student has to pay in a particular semester. The problem is the […]

Categories
Mastering Development

Postgresql query returns string values between quotation marks ” if it contains any space character or without quotation if it had no space char

so I got this strange issue and I have no idea what’s causing it. We are using Charts.js in PHP to plot some charts. We store the arguments needed to create a chart into a PSQL table to load when needed. My issue lies with the title, group and label parameters which are all string […]

Categories
Mastering Development

Cannot add foreign key constraint error 1215 HY000

I keep getting this error for my ENROLLS table, TAKES table, CONDUCTED_IN table, and EXAM table. when I am uploading my created tables to the database. I am not sure what the problem is can anyone help out? The COURSE, SECTION, CLASS_ROOM, and STUDENT tables were added to the database just fine the others have […]

Categories
Mastering Development

Creating Child Object, Child Constructor Not Used OOP

I’m a beginner to java, and I’m having issues creating an object that is a child of a parent class. I can’t share source code, because it is for a school project; and I don’t want to get dinged for cheating. But, I can write similar code; so that I can gain a fundamental understanding […]

Categories
Linux Mastering Development Ubuntu

PHP/SQLite3 form pre-populated does not update database when hitting submit

Situation: On a web page, the end user is asked to provde a database id. They enter the database id, hit submit, and a pre-populated form appears where they can edit any parts of the record that they need to. They then hit submit and, theoretically, the form updates the SQLite3 database and displays the […]

Categories
Mastering Development

How to store Multidimensional array in Database – using laravel 5.8

I want to save students course information into database courses table. Student can add multiple course, class time and section at a time using a form. Here is details of courses table: **id, nsu_id course, section, class_start, class_end** Form (View) <form method=”POST” action=”/store”> @csrf <div class=”parent”> <div id=”form-set”> <div class=”form-group row”> <label for=”course” class=”col-md-4 col-form-label […]

Categories
Database Development

How to make foreign key reference to column in parent table of specific table

I am using mysql database, by using it I created five tables course, section, subsection, school and school_course without any problems CREATE TABLE `course` ( id BIGINT AUTO_INCREMENT PRIMARY KEY, name VARCHAR(255) ); CREATE TABLE `section` ( id BIGINT AUTO_INCREMENT PRIMARY KEY, name VARCHAR(255), courseId BIGINT NOT NULL, FOREIGN KEY (`courseId`) REFERENCES `course` (`id`) ); […]