php - 数据没有上传到mysql

Question

我正在学习如何将 php 脚本集成到 wordpress 中。

我创建了一个函数:

function sollicitatie_formulier() { 
ob_start(); 
include 'scripts/solliciteer-form.php'; 
return ob_get_clean(); 
} 
add_shortcode( 'sollicitatie_formulier', 'sollicitatie_formulier' );

我调用的脚本如下所示:

<?php

global $wpdb; 

if(isset($_POST['btn-upload'])) 
{ 
$table = sollicitaties; 
$file = rand(1000,100000)."-".$_FILES['afile']['name']; 
$file_size = $_FILES['afile']['size']; 
$file_type = $_FILES['afile']['type']; 
$file_loc = $_FILES['afile']['tmp_name']; 
$folder="wp-content/themes/jobify-extended/uploads/"; 
$data = array( 
'voornaam' => $_POST['avoornaam'], 
'familienaam' => $_POST['afamilienaam'], 
'comment' => $_POST['amsg'], 
'afile' => rand(1000,100000)."-".$_FILES['afile']['name'], 
'size' => $_FILES['afile']['size'], 
'type' => $_FILES['afile']['type'], 



); 

// new file size in KB 
$new_size = $file_size/1024; 
// new file size in KB 

// make file name in lower case 
$new_file_name = strtolower($file); 
// make file name in lower case 

$final_file=str_replace(' ','-',$new_file_name); 

$format = array( 
'%s', 
'%s',
'%s',
'%s',
'%s',
'%s',
); 

if(move_uploaded_file($file_loc,$folder.$final_file)) 
{ 
$success=$wpdb->insert( $table, $data, $format,$folder); 
if($success){ 
?> 
<script> 
alert('successfully uploaded'); 
window.location.href='sollicitatie-formulier?success'; 
</script> 
<?php 

} 
} 
} 


else { 
?> 

<form action="" method="post" enctype="multipart/form-data"> 
<label for="voornaam">Voornaam: </label><input type="text" name="avoornaam" required=""> 
<label for="familienaam">Familienaam: </label><input type="text" name="afamilienaam" required=""> 
<label for="comment">bericht: </label><textarea type="text" name="amsg"></textarea> 
<input type="file" name="afile" accept=".pdf, .doc, .docx" /> 
<input type="submit" name="btn-upload" value="upload"</input> 
</form> 

<?php 
if(isset($_GET['success'])) 
{ 
?> 
<label>Kandidaat succesvol toegevoegd... <a href="/bekijk/">click hier om kandidaten te bekijken.</a></label> 
<?php 
} 
else if(isset($_GET['fail'])) 
{ 
?> 
<label>Oeps...een probleem! Probeer opnieuw</label> 
<?php 
} 
else 
{ 
?> 
<label>Try to upload any files(PDF, DOC, DOCX)</label> 

<?php } } 

?>

我的文件被上传到我的文件夹，但没有数据被发送到我的数据库。我试图了解问题所在，但我无法弄清楚。我希望你不介意同时解释我做错了什么，而不仅仅是给出正确答案。

Answer 1

您忘记添加 $wpdb->prefix。

示例

global $wpdb;

$table = $wpdb->prefix.'sollicitaties';