get_charset_collate(); $table_name = $wpdb->prefix . 'agenda_virtual'; $sql = "CREATE TABLE $table_name ( ID INT(11) NOT NULL AUTO_INCREMENT, Features VARCHAR(255) NOT NULL, Data VARCHAR(255) NOT NULL, PRIMARY KEY (ID) ) $charset_collate;"; require_once( ABSPATH . 'wp-admin/includes/upgrade.php' ); dbDelta( $sql ); if (isset($_POST['submit'])) { $cor = sanitize_text_field($_POST['cor']); $url = sanitize_text_field($_POST['url']); $position = sanitize_text_field($_POST['position']); $visible = sanitize_text_field($_POST['visible']); $nome_result = $wpdb->get_results("SELECT * FROM $table_name WHERE Features = 'Cor'"); if (count($nome_result) > 0) { $wpdb->update($table_name, array('Data' => esc_html($cor)), array('Features' => 'Cor')); } else { $wpdb->insert($table_name, array('Features' => 'Cor', 'Data' => esc_html($cor))); } $url_result = $wpdb->get_results("SELECT * FROM $table_name WHERE Features = 'URL'"); if (count($url_result) > 0) { $wpdb->update($table_name, array('Data' => esc_html($url)), array('Features' => 'URL')); } else { $wpdb->insert($table_name, array('Features' => 'URL', 'Data' => esc_html($url))); } $position_result = $wpdb->get_results("SELECT * FROM $table_name WHERE Features = 'position'"); if (count($position_result) > 0) { $wpdb->update($table_name, array('Data' => esc_html($position)), array('Features' => 'position')); } else { $wpdb->insert($table_name, array('Features' => 'position', 'Data' => esc_html($position))); } $visible_result = $wpdb->get_results("SELECT * FROM $table_name WHERE Features = 'visible'"); if (count($visible_result) > 0) { $wpdb->update($table_name, array('Data' => esc_html($visible)), array('Features' => 'visible')); } else { $wpdb->insert($table_name, array('Features' => 'visible', 'Data' => esc_html($visible))); } } // código para buscar os valores armazenados na tabela e preencher os campos correspondentes, caso existam $nome_result = $wpdb->get_results( $wpdb->prepare( "SELECT * FROM $table_name WHERE Features = %s", 'Cor' ) ); $cor = ''; if ( count( $nome_result ) > 0 ) { $cor = esc_attr( $nome_result[0]->Data ); } $url_result = $wpdb->get_results( $wpdb->prepare( "SELECT * FROM $table_name WHERE Features = %s", 'URL' ) ); $url = ''; if ( count( $url_result ) > 0 ) { $url = esc_attr( $url_result[0]->Data ); } $position_result = $wpdb->get_results( $wpdb->prepare( "SELECT * FROM $table_name WHERE Features = %s", 'position' ) ); $position = 'inferior_direito'; // definindo "inferior_direito" como padrão if ( count( $position_result ) > 0 ) { $position = esc_attr( $position_result[0]->Data ); } $visible_result = $wpdb->get_results( $wpdb->prepare( "SELECT * FROM $table_name WHERE Features = %s", 'visible' ) ); $visible = ''; if ( count( $visible_result ) > 0 ) { $visible = esc_attr( $visible_result[0]->Data ); } ?>
<?php echo esc_attr('Logo Agenda Virtual'); ?>

Configurar botão

Insira as informações abaixo para exibir o botão da Agenda Virtual em seu site.

Acessar minha conta