Ask a question    Sign Up Sign In
  1. Home
  2. html - php empty data record deletion

494 votes
1 answers

html - php empty data record deletion

Get the solution ↓↓↓

There is no problem when the form is sent normally, but when I click on the add-phone button with jquery, input I have an inpute with name sub_phone_ and when I post it, it is saved in the content named sub_email, sub_map and sub_maps which I did not add to the database in php. I want that if there are no email map maps inputs, they should not write them in the database.

database record

[{"title":"1","address":"1","phone":"1","submenu":[{"email":"1","phone":null,"map":null,"maps":null}]}]

if empty
"phone":null,"map":null,"maps":null <<< delete.

HTML

<form action="" method="post" class="formify">
    <div class="tab-pane" id="iletisim">
        <div id="menus">
            <ul id="menu" class="menu">
                <li>
                    <div class="menu-item">
                        <a href="#" class="delete-menu">
                            <i class="fa fa-times"></i>
                        </a>
                        <div class="row">
                            <label class="col-sm-2 col-form-label">title</label>
                            <div class="col-sm-7">
                                <div class="form-group bmd-form-group">
                                    <input class="form-control" type="text" name="title[]" placeholder="title">
                                </div>
                        </div>
                    </div>
                    <div class="row">
                        <label class="col-sm-2 col-form-label">address</label>
                        <div class="col-sm-7">
                            <div class="form-group bmd-form-group">
                                <textarea class="form-control" name="address[]" cols="30" rows="3" placeholder="address""></textarea>
                        </div>
                    </div>
                </div>
                <div class="row">
                    <label class="col-sm-2 col-form-label">Phone</label>
                        <div class="col-sm-7">
                            <div class="form-group bmd-form-group">
                                <input class="form-control" type="text" name="phone[]" placeholder="Phone">
                            </div>
                        </div>
                </div>
            </div>
            <div class="sub-menu">
                <ul class="menu"></ul>
            </div>
            <a href="#" class="btn add-email" data-background-color="warning">Add Email</a>
            <a href="#" class="btn add-phone" data-background-color="warning">Add Phone</a>
            <a href="#" class="btn add-map" data-background-color="warning">Add Map</a>
            </li>
        </ul>
    </div>
</div>
<div class="menu-btn">
    <button type="submit" value="1" name="submit" >Save</button>
</div>
</form>

JQUERY

$(document.body).on('click', '.add-email', function (e) {
    var index = $(this).closest('li').index();
    $(this).prevAll('.sub-menu:last').find('ul').append('<li>\n' +
        '<div class="handle"></div><div class="menu-item">\n' +
        '   <a href="#" class="delete-menu">\n' +
        '       <i class="fa fa-times"></i>\n' +
        '   </a>\n' +
        '   <div class="row">\n' +
        '       <label class="col-sm-2 col-form-label">İletişim Maili</label>\n' +
        '           <div class="col-sm-7">\n' +
        '               <div class="form-group bmd-form-group">\n' +
        '                   <input class="form-control" type="text" name="sub_email_' + index + '[]" '
        + 'placeholder="İletişim Maili">\n' +
        '                </div>\n' +
        '            </div>\n' +
        '        </div>\n' +
        '    </div>\n' +
        '</li>');
    e.preventDefault();
});

$(document.body).on('click', '.add-phone', function (e) {
    var index = $(this).closest('li').index();
    $(this).prevAll('.sub-menu:last').find('ul').append('<li>\n' +
        '<div class="handle"></div><div class="menu-item">\n' +
        '<a href="#" class="delete-menu">\n' +
        '   <i class="fa fa-times"></i>\n' +
        '</a>\n' +
        '   <div class="row">\n' +
        '       <label class="col-sm-2 col-form-label">İletişim 2. Telefon</label>\n' +
        '           <div class="col-sm-7">\n' +
        '               <div class="form-group bmd-form-group">\n' +
        '                   <input class="form-control" type="text" name="sub_phone_' + index + '[]" '
                    + 'placeholder="İletişim 2. Telefon">\n' +
        '               </div>\n' +
        '           </div>\n' +
        '       </div>\n' +
        '   </div>\n' +
        '</li>');
    e.preventDefault();
});

$(document.body).on('click', '.add-map', function (e) {
    var index = $(this).closest('li').index();
    $(this).prevAll('.sub-menu:last').find('ul').append('<li>\n' +
        '<div class="handle"></div><div class="menu-item">\n' +
        '    <a href="#" class="delete-menu">\n' +
        '        <i class="fa fa-times"></i>\n' +
        '    </a>\n' +
        '   <div class="row">\n' +
        '       <label class="col-sm-2 col-form-label">Yol Tarifi URL Adresi</label>\n' +
        '       <div class="col-sm-7">\n' +
        '           <div class="form-group bmd-form-group">\n' +
        '               <input class="form-control" type="text" name="sub_map_' + index + '[]" '
                    + 'placeholder="Yol Tarifi URL Adresi">\n' +
        
        '            </div>\n' +
        '        </div>\n' +
        '     </div>\n' +
        '  </div>\n' +
        '</li>');
    e.preventDefault();
});

$(document.body).on('click', '.add-maps', function (e) {
    var index = $(this).closest('li').index();
    $(this).prevAll('.sub-menu:last').find('ul').append('<li>\n' +
        '<div class="handle"></div><div class="menu-item">\n' +
        '   <a href="#" class="delete-menu">\n' +
        '       <i class="fa fa-times"></i>\n' +
        '   </a>\n' +
        '   <div class="row">\n' +
        '       <label class="col-sm-2 col-form-label">Map Görseli URL Adresi</label>\n' +
        '       <div class="col-sm-7">\n' +
        '           <div class="form-group bmd-form-group">\n' +
        '               <input class="form-control" type="text" name="sub_maps_' + index + '[]" '
                    + 'placeholder="Map Görseli URL Adresi">\n' +
        '           </div>\n' +
        '       </div>\n' +
        '   </div>\n' +
        '</div>\n' +
        '</li>');
    e.preventDefault();
});

PHP

if (post('submit')) {

    $menu = [];
    $menu_title = post('menu_title');
    if (!$menu_title) {
        $error = 'Menü Başlığını Belirtin!';
    } elseif (count(array_filter(post('title'))) == 0) {
        $error = 'En Az Bir Menü İçeriği Girmeniz Gerekiyor!';
    } else {

        $address = post('address');
        $phone = post('phone');
        foreach (post('title') as $key => $title) {
            $arr = [
                'title' => $title,
                'address' => $address[$key],
                'phone' => $phone[$key],
            ];
            if (post('sub_email_' . $key)) {
                $submenu = [];
                $subphone = post('sub_phone_' . $key);
                $submap = post('sub_map_'.$key);
                $submaps = post('sub_maps_'.$key);
                foreach (post('sub_email_' . $key) as $k => $subemail) {
                    $submenu[] = [
                        'email' => $subemail,
                        'phone' => $subphone[$k],
                        'map' => $submap[$k],
                        'maps' => $submaps[$k]

                    ];
                }

                $arr['submenu'] = $submenu;
            }
            $menu[] = $arr;
        }

        $query = $db->prepare('INSERT INTO menu SET menu_title = :menu_title, menu_content = :menu_content');
        $result = $query->execute([
            'menu_title' => $menu_title,
            'menu_content' => json_encode($menu)
        ]);



224
votes

Answer

Solution:

You can Try following code.

  foreach (post('title') as $key => $title) {
        $arr = [
            'title' => $title,
            'address' => $address[$key],
            'phone' => $phone[$key],
        ];
        if (post('sub_email_' . $key) != null) {
            if (post('sub_email_' . $key)) {
                $submenu = [];
                $subphone = post('sub_phone_' . $key);
                $submap = post('sub_map_' . $key);
                $submaps = post('sub_maps_' . $key);
                foreach (post('sub_email_' . $key) as $k => $subemail) {
                    if (($subphone[$k] != null) && ($submap[$k] != null) && ($submaps[$k] != null)) {
                        $submenu[] = [
                            'email' => $subemail,
                            'phone' => $subphone[$k],
                            'map' => $submap[$k],
                            'maps' => $submaps[$k]
                        ];
                    }
                }
                if (count($submenu) > 0) {
                    $arr['submenu'] = $submenu;
                }
            }
        }

        $menu[] = $arr;
    }

    $result=DB::table('menu')
          ->insert([
            'menu_title' =>$menu_title,//your menu title here
            'menu_content' => json_encode($menu)  
          ]);

I hope it's works for you.

Write your answer



Share solution ↓

Additional Information:
Link To Source
People are also looking for solutions of the problem: warning: a non-numeric value encountered in

Didn't find the answer?

Our community is visited by hundreds of web development professionals every day. Ask your question and get a quick answer for free.

Similar questions

Find the answer in similar questions on our website.

546 php - Save data to two different tables in CakePHP 3
204 php,mysql,html - Display SQL query(conjunction) properly in HTML
514 html - IN PHP , how to have datagrid or gridview
344 php - Using JQuery UI's sortable('serialize') after loading data in via .load();
481 html - PHP JSON generation problems
468 Including a html form in a php script
675 PHP + SQL - Using SQL Server 'Create To' scripts to create tables through PHP
407 Is this an acceptable way to autoload html pages with php?
631 php - Database Error mysqli_init()
495 php - How to read value from HTML text input?

Write quick answer

Do you know the answer to this question? Write a quick response to it. With your help, we will make our community stronger.





About the technologies asked in this question

PHP

PHP (from the English Hypertext Preprocessor - hypertext preprocessor) is a scripting programming language for developing web applications. Supported by most hosting providers, it is one of the most popular tools for creating dynamic websites. The PHP scripting language has gained wide popularity due to its processing speed, simplicity, cross-platform, functionality and distribution of source codes under its own license.
https://www.php.net/


JQuery

JQuery is arguably the most popular JavaScript library with so many features for modern development. JQuery is a fast and concise JavaScript library created by John Resig in 2006. It is a cross-platform JavaScript library designed to simplify client-side HTML scripting. Over 19 million websites are currently using jQuery! Companies like WordPress, Facebook, Google, IBM and many more rely on jQuery to provide a kind of web browsing experience.
https://jquery.com/


HTML

HTML (English "hyper text markup language" - hypertext markup language) is a special markup language that is used to create sites on the Internet. Browsers understand html perfectly and can interpret it in an understandable way. In general, any page on the site is html-code, which the browser translates into a user-friendly form. By the way, the code of any page is available to everyone.
https://www.w3.org/html/

Welcome to programmierfrage.com

programmierfrage.com is a question and answer site for professional web developers, programming enthusiasts and website builders. Site created and operated by the community. Together with you, we create a free library of detailed answers to any question on programming, web development, website creation and website administration.

Get answers to specific questions

Ask about the real problem you are facing. Describe in detail what you are doing and what you want to achieve.

Help Others Solve Their Issues

Our goal is to create a strong community in which everyone will support each other. If you find a question and know the answer to it, help others with your knowledge.