function php to Plugin Wordpress

Question

i have php code it's for reading excel file (.xlsx) and i want to make plugin for Wordpress ( just a simple plugin ). tested on localhost Wordpress it's work perfectly, but when i uploaded to my site it's not work. when i click submit button just appear blank page.

<form method="post" action="">
Number : <input type="text" name"number" /> </br>
<input type"submit">
</form>




function find(){

    if (isset($_POST['number']) {
    $number = $_POST["number"];

    require_once ( plugin_dir_path(__FILE__). 'includes\classes\PHPExcel.php');
    $tmpfname = ( plugin_dir_path(__FILE__). 'number.xlsx');
    $excelReader = PHPExcel_IOFactory::createReaderForFile($tmpfname);
    $excelObj = $excelReader->load($tmpfname);
    $worksheet = $excelObj->getSheet(0);
    $lastRow = $worksheet->getHighestRow();
    $excel_arr = $worksheet->toArray(null,true,true,true);

        for ($row=1;$row <=$lastRow;$row++){

             if ($excel_arr[$row]["A"] == $number ) {
               echo $excel_arr[$row]["A"];
               break;
             }
        }
   }
}

add_shortcode('show_number', 'find');

The form needs to live inside the shortcode, otherwise there's no reason for the form to display. I'm curious how you got it to display in the first place - how are you accessing / including / referencing this code? — random_user_name
– random_user_name, Commented Aug 19, 2017 at 16:37
already place The form to inside the shortcode but still doesn't work, please see my explanation, i have edited. I do not know, I just see on youtube. I do not really understand about php, I just learned: D — Irfan Fauzi
– Irfan Fauzi, Commented Aug 20, 2017 at 11:43
Hi Irfan - so, you are asking a new question, but within this old / existing question. If the original issue is resolved, then please upvote and / or accept an answer that helped you. Then, if you're now having problems with the Excel doc getting read / outputted, ask a new question about that. — random_user_name
– random_user_name, Commented Aug 20, 2017 at 13:04
No, it is not. The question is very different. It may be the same code for you, but the question is now different. We helped you fix the original problem, and now you've got a new problem with the same shortcode. Please ask a new question. — random_user_name
– random_user_name, Commented Aug 20, 2017 at 13:07

Sunil Sharma · Accepted Answer · 2017-08-19 16:47:14Z

2

Insert HTML form code inside "find()" function. So form show with shortcode "show_number" and and get result.

answered Aug 19, 2017 at 16:47

Sunil Sharma

1742 silver badges9 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Irfan Fauzi Over a year ago

Already done but still load blank page, I think I'm wrong in writing function to read Excel file.

Sunil Sharma · Accepted Answer · 2017-08-21 03:32:23Z

function find(){

    if (isset($_POST['number']) {
    $number = $_POST["number"];

    require_once ( plugin_dir_path(__FILE__). 'includes\classes\PHPExcel.php');
    $tmpfname = ( plugin_dir_path(__FILE__). 'number.xlsx');
    $excelReader = PHPExcel_IOFactory::createReaderForFile($tmpfname);
    $excelObj = $excelReader->load($tmpfname);
    $worksheet = $excelObj->getSheet(0);
    $lastRow = $worksheet->getHighestRow();
    $excel_arr = $worksheet->toArray(null,true,true,true);

        for ($row=1;$row <=$lastRow;$row++){

             if ($excel_arr[$row]["A"] == $number ) {
               echo $excel_arr[$row]["A"];
               break;
             }
        }
   }
   ?>
   <form method="post" action="">
    Number : <input type="text" name"number" /> </br>
    <input type"submit">
    </form>
   <?php
}

add_shortcode('show_number', 'find');
?>

Collectives™ on Stack Overflow

function php to Plugin Wordpress

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related