UserDG

Hi, I followed your suggestion but the scripts are not working when I add the script in job-filters.php and delete it in `content-job-listing.php.

here’s my js

jQuery(document).ready(function($){
	$(".open-vlist").click(function(){
			var container = $(this).parents(".vlist");
			var answer = container.find(".vlist-p");
			var trigger = container.find(".vlist-t");

			answer.slideToggle(200);

			if (trigger.hasClass("vlist-o")){
				trigger.removeClass("vlist-o");
			} else {
				trigger.addClass("vlist-o");
			}

			if (container.hasClass("vlist-expanded")){
				container.removeClass("vlist-expanded");
			} else {
				container.addClass("vlist-expanded");
			}
	});
});

I tried in child theme, but it’s not working. I also tried in parent theme, and still failed to load custom files. As I checked $dir is the path directory of files, I saw the same variable in the parent theme – function. So I copied it, and changed only the file name and stored the custom js files in assets->js->third

I have some columns that unused and I want to delete it. And the remaining columns, I want to re-arrange the order of columns.

E.g. Let’s say, I have lastname,name,firstname,email,number,subject,middlename,message,test1,test2 columns.

I want to re-arrange the columns like this. lastname,firstname,middlename,email,number,message,name,subject. And delete the test1 and test2 columns.

How to do this in mysql query?

it’s ok now. But i experience new errors: Here’s the link https://bit.ly/2dyWUPW. Password: 12345

This PHP snippet I found in the PHP file that you said. I will copy that right? And paste it to the other PHP file? So the “Apply” button will be duplicate?

<?php if ( candidates_can_apply() ) : ?>
  <?php get_job_manager_template( 'job-application.php' ); ?>
<?php endif; ?>

Which php file should i modify?

But I don’t want to use a shortcode ?? How to do display the data in a table using the hardcoded code? Like my example code above

Do you mean to put the code like this?

require_once(ABSPATH . 'wp-content/plugins/contact-form-7-to-database-extension/CFDBFormIterator.php');
$exp = new CFDBFormIterator();
$exp->export('FormName', array());
while ($row = $exp->nextRow()) {
echo 'Submitted=' . $row['submit_time'] . '<br/>';
...
...
...
}

But there’s anyway to displayed the fieldname and it’s values without using API?

yes, the old and new table have same prefix. I query the new added rows thru phpmyadmin and the data is displayed but in WP UI is not ??

even I do a custom PHP that will display the data from _cf7dbplugin_submits table, the new added row is not displayed too.

yes, i have a table prefix. the old table name have the same name of the new table but still not displayed

it’s always displayed this error: Invalid file type. Supported file types: .doc, .docx & .pdf are only allowed” even the file type is valid.

I tried to do like this..

if(isset($_POST['submit'])){
	$lastName = isset($_POST['lastName']) ? $_POST['lastName'] : '';
	$firstName = isset($_POST['firstName']) ? $_POST['firstName'] : '';
	$middleName = isset($_POST['middleName']) ? $_POST['middleName'] : '';
	$email = isset($_POST['email']) ? $_POST['email'] : '';
	$mobile = isset($_POST['mobile']) ? $_POST['mobile'] : '';
	$filterbyhiringlocation = isset($_POST['filterbyhiringlocation ']) ? $_POST['filterbyhiringlocation '] : '';
	$resume = isset($_POST['resumeFile']) ? $_POST['resumeFile'] : '';
	$position = isset($_POST['jobTitle']) ? $_POST['jobTitle'] : '';
	$message = isset($_POST['message ']) ? $_POST['message '] : '';

	if(!empty($_FILES)){
			//Limit the file size in 1 MB only
			if ($_FILES["resumeFile"]["size"] > 2000000){
				$fileSizeError = "File is too large. Max. upload file size is 2MB";
				$uploadOk = 0;
				exit;
			//doc, docx and pdf files are only allowed
			} else if($fileType != "doc" && $fileType != "docx" && $fileType != "pdf"){
				$fileTypeError = "Invalid file type. Supported file types: .doc, .docx & .pdf are only allowed";
				$uploadOk = 0;
				exit;
			}
		}

	if (!$uploadOk){
		unset($formData['Resume']);
	}

               //Send email
		if (mail($mail_to, $subject, $message_body, $header)){
			ob_start();
			echo "Test";
			echo do_shortcode("[cfdb-save-form-post]");
			exit();
		} else{
			echo "Error";
		}

but it’s not working. The values are not saving in the database

Can I do like this?

if(isset($_POST['submit'])){
	$name = isset($_POST['FName']) ? $_POST['FName'] : '';
	$email = isset($_POST['Email']) ? $_POST['Email'] : '';
	$message = isset($_POST['Message']) ? $_POST['Message'] : '';

if(!empty($_FILES)){
			//Limit the file size in 1 MB only
			if ($_FILES["resumeFile"]["size"] > 2000000){
				$fileSizeError = "File is too large. Max. upload file size is 2MB";
				$uploadOk = 0;
				exit;
			//doc, docx and pdf files are only allowed
			} else if($fileType != "doc" && $fileType != "docx" && $fileType != "pdf"){
				$fileTypeError = "Invalid file type. Supported file types: .doc, .docx & .pdf are only allowed";
				$uploadOk = 0;
				exit;
			} else {
                             echo do_shortcode("[cfdb-save-form-post]");
             }
       }
}

there’s a value in

echo '<pre>';
print_r( $result_position );
echo '</pre>';

can you help me to fix it? please