JQuery Variável ' i d ' desatualizada

Joel Martins · 22 de junho de 2021

Boas

Eu tenho na minha tabela a variável 'id' e ao remover um user a variável 'id' não atualizou.

Como posso fazer para que ela atualize?

Agradeço toda a ajuda possível.

:))

DiF · 22 de junho de 2021

@Joel Martins Seria interessante postar o código para ser analisado. Assim os demais podem lhe ajudar.

Joel Martins · 22 de junho de 2021

@DiF obrigado pela dica.

Aqui está o código:

echo"<div>";
echo"<div id='kt_content_container' class='container'>";
echo"<div class='card'>";
echo"<form action='apps/customers/tableo.php' method='post' >";
echo"<div class='card-body pt-0'>";
echo"<div class='card-title'>";
echo"<div class=' search d-flex align-items-center position-absolute my-1'>
		<span class='svg-icon svg-icon-1 position-absolute ms-6'>
			<svg xmlns='http://www.w3.org/2000/svg' xmlns:xlink='http://www.w3.org/1999/xlink' width='24px' height='24px' viewBox='0 0 24 24' version='1.1'>
				<g stroke='none' stroke-width='1' fill='none' fill-rule='evenodd'>
					<rect x='0' y='0' width='24' height='24'></rect>
					<path d='M14.2928932,16.7071068 C13.9023689,16.3165825 13.9023689,15.6834175 14.2928932,15.2928932 C14.6834175,14.9023689 15.3165825,14.9023689 15.7071068,15.2928932 L19.7071068,19.2928932 C20.0976311,19.6834175 20.0976311,20.3165825 19.7071068,20.7071068 C19.3165825,21.0976311 18.6834175,21.0976311 18.2928932,20.7071068 L14.2928932,16.7071068 Z' fill='#000000' fill-rule='nonzero' opacity='0.3'></path>
					<path d='M11,16 C13.7614237,16 16,13.7614237 16,11 C16,8.23857625 13.7614237,6 11,6 C8.23857625,6 6,8.23857625 6,11 C6,13.7614237 8.23857625,16 11,16 Z M11,18 C7.13400675,18 4,14.8659932 4,11 C4,7.13400675 7.13400675,4 11,4 C14.8659932,4 18,7.13400675 18,11 C18,14.8659932 14.8659932,18 11,18 Z' fill='#000000' fill-rule='nonzero'></path>
				</g>
			</svg>
		</span>
        <input type='text' data-kt-customer-table-filter='search' class='form-control form-control-solid w-250px ps-15' placeholder='Search Customers'>
        </div>";
	echo"<div class='d-flex justify-content-end' data-kt-customer-table-toolbar='base'>";
		echo"<button type='button' class='btn btn-light-primary me-3' data-kt-menu-trigger='click' data-kt-menu-placement='bottom-end' data-kt-menu-flip='top-end'>";
			echo"<span class='svg-icon svg-icon-2'>";
				echo"<svg xmlns='http://www.w3.org/2000/svg' xmlns:xlink='http://www.w3.org/1999/xlink' width='24px' height='24px' viewBox='0 0 24 24' version='1.1'>";
					echo"<g stroke='none' stroke-width='1' fill='none' fill-rule='evenodd'>";
						echo"<rect x='0' y='0' width='24' height='24' />
						<path d='M5,4 L19,4 C19.2761424,4 19.5,4.22385763 19.5,4.5 C19.5,4.60818511 19.4649111,4.71345191 19.4,4.8 L14,12 L14,20.190983 C14,20.4671254 13.7761424,20.690983 13.5,20.690983 C13.4223775,20.690983 13.3458209,20.6729105 13.2763932,20.6381966 L10,19 L10,12 L4.6,4.8 C4.43431458,4.5790861 4.4790861,4.26568542 4.7,4.1 C4.78654809,4.03508894 4.89181489,4 5,4 Z' fill='#000000' />";
					echo"</g>";
				echo"</svg>";
			echo"</span>";
            echo"Filtro</button>";
			echo"<div class='menu menu-sub menu-sub-dropdown w-300px w-md-325px' data-kt-menu='true'>";
			echo"<div class='px-7 py-5'>";
				echo"<div class='fs-4 text-dark fw-bolder'>Filter Options</div>";
			echo"</div>";
			echo"<div class='separator border-gray-200'></div>";
			echo"<div class='px-7 py-5'>";
					echo"<div>";
						echo"<p> <b>Data</b> </p>
						<input type='date' name='valueToSearch' placeholder='Value To Search'>
						<br><br>";
					echo"</div>";

					echo"<div class='d-flex justify-content-end'>";
						echo"<button type='reset' class='btn btn-white btn-active-light-primary me-2' data-kt-menu-dismiss='true' data-kt-customer-table-filter='reset'>Reset</button>
						<button type='submit' name='search' value='Filter' class='btn btn-primary' data-kt-menu-dismiss='true' data-kt-customer-table-filter='filter'>Apply</button>";
					echo"</div>";
				echo"</div>";
			echo"</div>";
		echo"</div>";
		echo"<div class='d-flex justify-content-end align-items-center d-none' data-kt-customer-table-toolbar='selected'>";
			echo"<div class='fw-bolder me-5'>";
                echo"<span class='me-2' data-kt-customer-table-select='selected_count'></span>Selected</div>";
                echo"<button type='button' class='btn btn-danger' data-kt-customer-table-select='delete_selected'>Delete Selected</button>";
            echo"</div>";
		echo"</div>";
    echo"<div class='table-responsive'>";
echo"<table class='table align-middle table-row-dashed fs-6 gy-5 dataTable no-footer' id='kt_customers_table myTable' role='grid'>";
echo"<thead>";
echo"<tr class='text-start text-gray-400 fw-bolder fs-7 text-uppercase gs-0'><th class='w-10px pe-2'><div class='form-check form-check-sm form-check-custom form-check-solid me-3'><input class='form-check-input' type='checkbox' data-kt-check='true' data-kt-check-target='kt_customers_table .form-check-input' value='1' /></div></th><th class='min-w-125px'>id</th><th class='min-w-125px'>Nome</th><th class='min-w-125px'>Website</th><th class='min-w-125px'>Email</th><th class='min-w-125px'>Serviço</th><th class='min-w-125px'>Data</th><th class='min-w-125px'>Montante</th><th class='text-end min-w-70px'>Delete</th></tr>";
echo"</thead>";
while($row = mysqli_fetch_array($search_result)) {
    echo"<tbody class='fw-bold text-gray-600'>
    <tr class='container'>
        <td> <div class='form-check form-check-sm form-check-custom form-check-solid'><input class='form-check-input' type='checkbox' value='1' /></div></td>
        
        <td>{$row['id']}</td>

        <td> {$row['nome']} </td>

        <td> {$row['website']} </td>

        <td> {$row['email']} </td>

        <td> {$row['serv']} </td>

        <td> {$row['data']} </td>

        <td class='text-gray-800 text-hover-primary mb-1'> {$row['montante']} </td>
        <td class='text-end'><div class='menu-item px-3'><button id='delete' alt='delete' .class='menu-link px-3' data-kt-customer-table-filter='delete_row'><b> Delete </b></button></div></td>
    </tr>
</tbody>";
}
echo"</table>";
echo"</div>";
echo"</form>";
echo"</div>";
echo"</div>";