DEV Community: Gcobani Mkontwana

How to solve this problem in nodejs?

Gcobani Mkontwana — Fri, 18 Oct 2024 11:45:17 +0000

Hi Team

I am trying to establish a connection to the database schema that does not use sql connection. I am using node js as the back end, while running this project, i get the following error below;

`PS C:\Users\gcobani\coding-challenge\backend> yarn dev

yarn run v1.22.22
warning ..\package.json: No license field
$ tsx watch src/index.ts
node:internal/process/promises:288
triggerUncaughtException(err, true /* fromPromise */);
^

[Error: SQLITE_CANTOPEN: unable to open database file] {
errno: 14,
code: 'SQLITE_CANTOPEN'
}

Node.js v18.20.4`

// This is my typescript and file path on the VS code project

import { Sequelize } from 'sequelize';
import path from 'path';

// The dbPath should reflect the location of the winedrops.db file

const dbPath = path.resolve(__dirname, 'db/winedrops.db'); // This should work if __dirname points to 'src'
console.log('Database path:', dbPath); // Log the path to confirm

export const sequelize = new Sequelize({
    dialect: 'sqlite',
    storage: dbPath,
});

async function testConnection() {
    try {
        await sequelize.authenticate();
        console.log('Connection has been established successfully.');
    } catch (error) {
        console.error('Unable to connect to the database:', error.message);
    }
}

testConnection();

Creating very nice dashboard using bootstrap in your ecommerce site

Gcobani Mkontwana — Sat, 25 Mar 2023 16:26:41 +0000

Hi Team

I need help with my front end, want to create a nice UI dashboard its not appearing very nice, must have nice navbar, tabs with avatar when user log in or div class for user-profile.

`// Bootstrap
<?php
// Start the session
session_start();

// Check if user is logged in
if(!isset($_SESSION['email'])) {
// Redirect to login page
header('Location: customer-login.php');
exit();
}

// User is logged in, display dashboard
?>

[<!DOCTYPE html>

Dashboard



/* Adjust the sidebar height */ #sidebar { height: 100vh; }

    <h1>Welcome </h1>


    <a href="#">Dashboard</a>




        <ul>
            <li>
                <a href="#">Dashboard</a>
            </li>
            <li>
                <a href="#">Profile</a>
            </li>
            <li>
                <a href="#">Settings</a>
            </li>
            <li>
                <a href="logout.php">Logout</a>
            </li>
        </ul>







      <h5>Total Orders</h5>
      <p>1,234</p>






      <h5>Total Sales</h5>
      <p>$123,456</p>






      <h5>New Customers</h5>
      <p>567</p>






      <h5>Inventory</h5>
      <p>456</p>

](url)`

PDF is not opening using php mail function

Gcobani Mkontwana — Fri, 10 Mar 2023 06:25:46 +0000

Hi Team

I need help with my code below, i am sending an email attachment has a pdf document. But the problem when i view it its not opening need help around it.

// application.php

<?php

$filenameee = $_FILES['id']['name'];
$fileName = $_FILES['id']['temp_name'];
$amount =$_REQUEST['amount'];
$purpose =$_REQUEST['purpose'];
$voucher =$_REQUEST['voucher'];
$gender =$_REQUEST['gender'];
$fname =$_REQUEST['fname'];
$lname =$_REQUEST['lname'];
$title =$_REQUEST['title'];
$typeID =$_REQUEST['typeID'];
$email =$_REQUEST['email'];
$number =$_REQUEST['number'];
$maritalstatus =$_REQUEST['maritalstatus'];
$street1 =$_REQUEST['street1'];
$street2 =$_REQUEST['street2'];
$town =$_REQUEST['town'];
$province =$_REQUEST['province'];
$code =$_REQUEST['code'];
$propertyownership =$_REQUEST['propertyownership'];
$placeofwork =$_REQUEST['placeofwork'];
$jobtitle =$_REQUEST['jobtitle'];
$jobstreet=$_REQUEST['jobstreet'];
$jobstreet2 =$_REQUEST['jobstreet2'];
$jobtown =$_REQUEST['jobtown'];
$worknumber =$_REQUEST['worknumber'];
$jobprovince =$_REQUEST['jobprovince'];
$jobcode =$_REQUEST['jobcode'];
$income =$_REQUEST['income'];
$bankname=$_REQUEST['bankname'];
$branchname =$_REQUEST['branchname'];
$accountno =$_REQUEST['accountno'];
$accounttype =$_REQUEST['accounttype'];
$signature =$_REQUEST['signature'];
$bankstatement =$_REQUEST['bankstatement'];
$payslip=$_REQUEST['payslip'];

$message = "Name: ". $fname . $lname . "\r\n Email: " . $email . "\r\n Cell Number: " . $number . "\r\n Monthly Income: " . $income . "\r\n Loan Amount: " . $amount . "\r\n Town:" . $town;

$subject ="Application Form";
$fromname ="ACI FINANCE";
$fromemail = $email; //if u dont have an email create one on your cpanel
$mailto = 'Ongeziwe1998@gmail.com'; //the email which u want to recv this email
$content = file_get_contents($filenameee);
$content = chunk_split(base64_encode($content));

// a random hash will be necessary to send mixed content
$separator = md5(time());

// carriage return type (RFC)
$eol = "\r\n";

// main header (multipart mandatory)

$headers = "From: ".$fromname." <".$fromemail.">" . $eol;
$headers .= "MIME-Version: 1.0" . $eol;
$headers .= "Content-Type: multipart/mixed; boundary=\"" . $separator . "\"" . $eol;
$headers .= "Content-Transfer-Encoding: 7bit" . $eol;
$headers .= "This is a MIME encoded message." . $eol;

$logo = 'img/logo.png';
$link = '#';

$body = "<!DOCTYPE html><html lang='en'><head><meta charset='UTF-8'><title>Express Mail</title></head><body>";
$body .= "<table style='width: 100%;'>";
$body .= "<thead style='text-align: center;'><tr><td style='border:none;' colspan='2'>";
$body .= "<a href='{$link}'><img src='{$logo}' alt=''></a><br><br>";
$body .= "</td></tr></thead><tbody><tr>";
$body .= "<td style='border:none;'><strong>Name:</strong> {$fname} {$lname}</td>";
$body .= "<td style='border:none;'><strong>Email:</strong> {$from}</td>";
$body .= "</tr>";
$body .= "<tr><td style='border:none;'><strong>CellNumber:</strong> {$number}</td></tr>";
$body .= "<tr><td></td></tr>";
$body .= "<tr><td style='border:none;'><strong>Loan Amount:</strong> {$amount}</td></tr>";
$body .= "<tr><td></td></tr>";
$body .= "<tr><td style='border:none;'><strong>Monthly income:</strong> {$income}</td></tr>";
$body .= "<tr><td></td></tr>";
$body .= "<tr><td style='border:none;'><strong>Town:</strong> {$town}</td></tr>";
$body .= "<tr><td></td></tr>";
$body .= "<tr><td style='border:none;'><strong>Upload bankstatement </strong> {$bankstatement}</td></tr>";
$body .= "<tr><td></td></tr>";
$body .= "<tr><td style='border:none;'><strong>Upload payslip:</strong> {$payslip}</td></tr>";
$body .= "<tr><td></td></tr>";
$body .= "<tr><td colspan='2' style='border:none;'><strong></strong> </td></tr>";
// message

$body = "--" . $separator . $eol;
$body .= "Content-Type: text/plain; charset=\"iso-8859-1\"" . $eol;
$body .= "Content-Transfer-Encoding: 8bit" . $eol;
$body .= $message . $eol;
// attachment
$body .= "--" . $separator . $eol;
$body .= "Content-Type: application/pdf; name=\"" . $filenameee . "\"" . $eol;
$body .= "Content-Transfer-Encoding: base64" . $eol;
$body .= "Content-Disposition: attachment" . $eol;
$body .= $content . $eol;
$body .= "--" . $separator . "--";
$readfile.= "$filenameee";

$body .= "";

$body .= "

How to make your email template have nice beautiful background and image shown and be editable...?

Gcobani Mkontwana — Wed, 08 Mar 2023 12:11:41 +0000

Hi Team

I am trying to create email template locally, but need help with regarding background beautiful light brown similar background image attached on this topic. But currently its not showing to be beautiful and does not appear good. Because later i want it to be used amongst the team as our email-template to be editable for other stuff to use for different titles etc.

// code for email template

````

height="80">

Software Engineer

Agile Limitless Development

Phone: 087822 1286

Email: gcobani.mkontwana@agilelimitless.org.za

Website: www.acifinance.co.za

`

How can i view a pdf document using php?

Gcobani Mkontwana — Wed, 08 Mar 2023 10:26:46 +0000

Liquid syntax error: 'raw' tag was never closed

failed to open stream: No such file or directory in /home/acifinan/public_html/send-email-attachment.php on line 3

Gcobani Mkontwana — Tue, 07 Mar 2023 03:15:57 +0000

Hi Team

I need help with my phpmailer and i am trying to create send mail with pdf attached on the email but on the server logs its getting this message
PHP Warning: require(.._lib\vendor\phpmailer\phpmailer): failed t`o open stream: No such file or directory in /home/acifinan/public_html/send-email-attachment.php on line 3

require '.._lib\vendor\phpmailer\phpmailer';
use PHPMailer\PHPMailer;

$msg = '';
if (array_key_exists('bankstatement', $_FILES)) {
//Create a message
$mail = new PHPMailer();
$mail->setFrom('info@acifinance', 'ACI Finance');
$mail->addAddress('gcobani.mkontwana@agilelimitless.org.za', 'ACI Finance');
$mail->Subject = 'ACI Finance Application Loan';
$mail->Body = 'My message body';
//Attach multiple files one by one
for ($ct = 0, $ctMax = count($_FILES['bankstatement']['tmp_name']); $ct < $ctMax; $ct++) {
//Extract an extension from the provided filename
$ext = PHPMailer::mb_pathinfo($_FILES['bankstatement']['name'][$ct], PATHINFO_EXTENSION);
//Define a safe location to move the uploaded file to, preserving the extension
$uploadfile = tempnam(sys_get_temp_dir(), hash('sha256', $_FILES['bankstatement']['name'][$ct])) . '.' . $ext;
$filename = $_FILES['bankstatement']['name'][$ct];
if (move_uploaded_file($_FILES['bankstatement']['tmp_name'][$ct], $uploadfile)) {
if (!$mail->addAttachment($uploadfile, $filename)) {
$msg .= 'Failed to attach file ' . $filename;
}
} else {
$msg .= 'Failed to move file to ' . $uploadfile;
}
}
if (!$mail->send()) {
$msg .= 'Mailer Error: ' . $mail->ErrorInfo;
} else {
$msg .= 'Message sent!';
}
}
?>

// html code

SELECT A pdf FILE TO UPLOAD

                             <label>ID </label><br>
                            <input type="File" name="id" id="id" accept=".pdf">

                            <br>
                            <label>Bank Statement </label><br>
                            <input type="File" name="bankstatement" id="bankstatement" accept=".pdf">
                            <br>
                            <label>Pay Slip </label><br>
                            <input type="File" name="payslip" id="payslip" accept=".pdf">
                            <br>
                            <input type="Submit" id="btnNow" class="btn apply-btn mt-30" name="button" value="APPLY NOW">
                            </fieldset>`

Creating a phone book in Angular js when submit button is clicked previous data must displayed on the form table

Gcobani Mkontwana — Mon, 06 Mar 2023 17:36:57 +0000

Hi Team

How can write a form table when the instructions are as follows;

"Once the submit button is pressed, the information should be displayed in a list below (automatically sorted by last name) along with all the previous information that was entered. This way the application can function as a simple phone book. When your application loads, the input fields (not the phone book list) should be prepopulated with the following values already:
First name = Coder
Last name = Byte
Phone = 8885559999"

// code in Angular
`// @ts-ignore
import { Component, OnInit } from '@angular/core';

@Component({
selector: 'app-area',
template: <div class="form-wrapper"> <form> <div> <label for="firstName">First name</label> <input type="text" name="firstName" id="firstName" class="userFirstname"> </div> <div> <label for="lastName">Last name</label> <input type="text" name="lastName" id="lastName" class="userLastname"> </div> <div> <label for="phoneNumber">Phone number</label> <input type="tel" name="phoneNumber" id="phoneNumber" class="userPhone"> </div> <div> <input type="submit" value="submit" class="submitButton"> </div> </form> <div> <div class="informationTable"> Table of contacts should go here... </div>,
styles: []
})

export class MainAppComponent implements OnInit {
// code goes here
ngOnInit() {

}
}`

Fatal error: require(): Failed opening required 'public_html/PHPMailer/vendor.autoload.php'

Gcobani Mkontwana — Mon, 06 Mar 2023 16:32:01 +0000

Hi Team

I need some help, i am receiving email but my main object is to get an attachment when a user apply for a loan as pdf. Currently i am unable to achieve this it has been close to a week now with no luck at all including wide research.

// logic
`use PHPMailer\PHPMailer;

require 'public_html/PHPMailer/vendor.autoload.php'; // complaining here about this path(it is like this on the path server though

Python scripts fails to copy the website and translating text into Hindi on my Terminal

Gcobani Mkontwana — Mon, 06 Mar 2023 11:55:00 +0000

Hi team

I need some help with my script, the script does two things, first scraps the webiste. In this instance i am using selenium to scrap the site and this works. But when i tried to translate what the content of the site(title course and name) From english to Hindi using data frame its failes. See below exceptions and stuck since this morning;

                                                     ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\Zux\PycharmProjects\ClassCentral\ClassCentral\Lib\site-packages\googletrans\client.py", line 182, in translate
data = self._translate(text, dest, src, kwargs)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\Zux\PycharmProjects\ClassCentral\ClassCentral\Lib\site-packages\googletrans\client.py", line 78, in _translate
token = self.token_acquirer.do(text)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "C:\Users\Zux\PycharmProjects\ClassCentral\ClassCentral\Lib\site-packages\googletrans\gtoken.py", line 194, in do
self._update()
File "C:\Users\Zux\PycharmProjects\ClassCentral\ClassCentral\Lib\site-packages\googletrans\gtoken.py", line 62, in _update
code = self.RE_TKK.search(r.text).group(1).replace('var ', '')
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
AttributeError: 'NoneType' object has no attribute 'group'

// code to implement scraping the website using selenium webdrive and pandas.
`from googletrans import Translator
from selenium import webdriver
from selenium.webdriver.common.by import By
from selenium.webdriver.support.ui import WebDriverWait
from selenium.webdriver.support import expected_conditions
import pandas as pd
import urllib.request as urllib2
import time

chrome_options = webdriver.ChromeOptions()
chrome_options.add_argument('--headless')
chrome_options.add_argument("window-size=1920,1080")
driver = webdriver.Chrome(options=chrome_options)
url = "https://www.classcentral.com/collection/top-free-online-courses"
driver.get(url)

translator = Translator()

try:
while True:
# wait until button is clickable
WebDriverWait(driver, 1).until(
expected_conditions.element_to_be_clickable((By.XPATH, "//button[@data-name='LOAD_MORE']"))
).click()
time.sleep(0.5)
except Exception as e:
pass

all_courses = driver.find_element(by=By.CLASS_NAME, value='catalog-grid__results')
courses = all_courses.find_elements(by=By.CSS_SELECTOR, value='[class="color-charcoal course-name"]')

df = pd.DataFrame([[course.text, course.get_attribute('href')] for course in courses],
columns=['Title (eng)', 'Link'])

df['Title (hin)'] = df['Title (eng)'].apply(lambda x: translator.translate(x, dest='hi').text)

print(df)`

switching toggle button on and off using template

Gcobani Mkontwana — Mon, 06 Mar 2023 11:41:12 +0000

Hi team

I need some help with my logic below, basically i am answering this instruction below using angular js to create switch toggle button in Angular.

//instructions for the task.

We provided some simple Angular template code. Your goal is to modify the component so that you can properly toggle the button to switch between an ON state and an OFF state. When the button is on and it is clicked, it turns off and the text within it changes from ON to OFF and vice versa.

// code solution but its not showing any UI to switch on and off.
// @ts-ignore
`import { Component, OnInit } from '@angular/core';

@Component({
selector: 'app-area',
template: `

`,
styles: []
})

export class MainAppComponent implements OnInit {
// code goes here
ngOnInit() {

}
}`

How to create a test function and compile it using c++?

Gcobani Mkontwana — Tue, 13 Sep 2022 00:42:35 +0000

Hi Team

I have a class that uses std::map, but i am struggling to create a test function that will test my logic scenario. The scenario is i have implemented a logic to function called void assign that loop through value associate with it and does not duplicate it.

How to i then create a test function from my class to test this scenario using c++?

`class interval_map {
friend void IntervalMapTest();
V m_valBegin;
typedef std::map m_map;

public:

interval_map(V const& val)
: m_valBegin(val)
{}

void assign( K const& keyBegin, K const& keyEnd, V const& val )
{
for( auto it = m_map.find( keyBegin ); * it != keyEnd; ++it )
{
* it = val;
}
}

// look-up of the value associated with key
V const& operator[]( K const& key ) const {
    auto it=m_map.upper_bound(key);
    if(it==m_map.begin()) {
        return m_valBegin;
    } else {
        return (--it)->second;
    }
}

};

int main()
{
m_map map;
m_map::iterator mpIter;

int keyEnd, keyBegin;
int count;

// keep track of values with a std::set
std::set<std::string> values;

for(count = 0; count < 3; count++)
{
    cin >> key;
    cin >> value;

    auto found = map.find(key);

    if(found != map.end()) // key already in map
        continue; // don't add it again


}


return 0;

I have rest api to fetch and want to register it to my App.js, How can i achieve such in react?

Gcobani Mkontwana — Sun, 05 Jun 2022 09:22:18 +0000

I have this logic when im trying to fetch rest api and want to display details from my App.js(Main-App) and have Post.js(fetch rest api data).

// Post.js import React, { useState, useEffect } from 'react' export default function Posts() { const [post, getPosts] = useState([]) const API = 'https://fe-assignment.vaimo.net/'; const fetchPost = () => { fetch(API) .then((res) => res.json()) .then((res) => { console.log(res) getPosts(res) }) } useEffect(() => { fetchPost() }, []) return ( <> <h2>React Fetch Data with REST API Example</h2> <ul> {post.map((item, i) => { return <li key={i}>{item.name}</li> })} </ul> </> ) }

`// App.js
import React from "react";
import './App.css';
import './index.css';
import Posts from "./components/Posts";
class App extends React.Component {

// First load an image for Drone.
render() {
return (

    <img alt="timer" src={require('./components/images/drone_image.png')} />

)

// Need some logic here to pass one value from Rest api js here when this page is loaded currently its only showing image
function App() {

2021 hot selling GPS 5G quadcopter drone with camera remote control aircraft drone WiFi mini drone camera

}

// position the shopping details at the right side bar.

}

export default App;`