/** * Modify a slider saved in the database. * * @param Slider $slider * @return integer */ public function editSlider(Slider $slider) { $sql = "UPDATE slider \n\t\t\tSET id_slider = '" . $slider->getIdSlider() . "', title = '" . replaceCharacters($slider->getTitle()) . "' WHERE id_slider = '" . $slider->getIdSlider() . "'"; return DB::query($sql); }
/** * Modify a slider saved in the database. * * @param Slider $slider * @return integer */ public function editSlider(Slider $slider) { $sql = "UPDATE slider \n\t\t\tSET id_slider = '" . $slider->getIdSlider() . "', title = '" . replaceCharacters($slider->getTitle()) . "', body = '" . $this->formatBody(replaceCharacters($slider->getBody())) . "', link = '" . $slider->getLink() . "' WHERE id_slider = '" . $slider->getIdSlider() . "'"; return DB::query($sql); }
/** * Modify a provider saved in the database. * * @param ProviderCategory $providerCategory * @return integer */ public function editProviderCategory(ProviderCategory $providerCategory) { $sql = "UPDATE provider_category \n\t\t\tSET category_name = '" . replaceCharacters($providerCategory->getCategoryName()) . "' WHERE id_provider_category = '" . $providerCategory->getIdProviderCategory() . "'"; return DB::query($sql); }
/** * Modify a work saved in the database. * * @param Work $work * @return integer */ public function editWork(Work $work) { $sql = "UPDATE work \n\t\t\tSET id_work = '" . $work->getIdWork() . "', id_client = '" . $work->getIdClient() . "', work_name = '" . replaceCharacters($work->getWorkName()) . "', location = '" . replaceCharacters($work->getLocation()) . "', principal = '" . replaceCharacters($work->getPrincipal()) . "', date = '" . $work->getDate() . "' WHERE id_work = '" . $work->getIdWork() . "'"; return DB::query($sql); }
/** * Modify a sponsor saved in the database. * * @param Sponsor $sponsor * @return integer */ public function editSponsor(Sponsor $sponsor) { $sql = "UPDATE sponsor \n\t\t\tSET id_sponsor = '" . $sponsor->getIdSponsor() . "', name = '" . replaceCharacters($sponsor->getName()) . "', email = '" . $sponsor->getEmail() . "', website = '" . $sponsor->getWebsite() . "' WHERE id_sponsor = '" . $sponsor->getIdSponsor() . "'"; return DB::query($sql); }
/** * Modify a client saved in the database. * * @param Client $client * @return integer */ public function editClient(Client $client) { $mcrypt = new MCrypt(); $sql = "UPDATE client \n\t\t\tSET id_client = '" . $client->getIdClient() . "', client_name = '" . replaceCharacters($client->getClientName()) . "', agent = '" . replaceCharacters($client->getAgent()) . "', address = '" . replaceCharacters($client->getAddress()) . "', phone = '" . $client->getPhone() . "', email = '" . $client->getEmail() . "', website = '" . $client->getWebsite() . "', user = '******', password = '******' WHERE id_client = '" . $client->getIdClient() . "'"; return DB::query($sql); }
/** * Modify a professional saved in the database. * * @param Professional $professional * @return integer */ public function editProfessional(Professional $professional) { $sql = "UPDATE professional \n\t\t\tSET id_professional = '" . $professional->getIdProfessional() . "', name = '" . replaceCharacters($professional->getName()) . "', bio = '" . $this->formatBody(replaceCharacters($professional->getBio())) . "' WHERE id_professional = '" . $professional->getIdProfessional() . "'"; return DB::query($sql); }
/** * Modify a post saved in the database. * * @param Post $post * @return integer */ public function editPost(Post $post) { $sql = "UPDATE post \n\t\t\tSET id_post = '" . $post->getIdPost() . "', category = '" . $post->getCategory() . "', title = '" . replaceCharacters($post->getTitle()) . "', body = '" . $this->formatBody(replaceCharacters($post->getBody())) . "', video = '" . $post->getVideo() . "' WHERE id_post = '" . $post->getIdPost() . "'"; return DB::query($sql); }
/** * Modify a info saved in the database. * * @param Info $info * @return integer */ public function editInfo(Info $info) { $sql = "UPDATE info \n\t\t\tSET id_info = '" . $info->getIdInfo() . "', title = '" . replaceCharacters($info->getTitle()) . "' WHERE id_info = '" . $info->getIdInfo() . "'"; return DB::query($sql); }
/** * Modify a post saved in the database. * * @param Post $post * @return integer */ public function editPost(Post $post) { $sql = "UPDATE post \n\t\t\tSET id_post = '" . $post->getIdPost() . "', title = '" . replaceCharacters($post->getTitle()) . "', headline = '" . replaceCharacters($post->getHeadline()) . "', date = '" . $post->getDate() . "', body = '" . $this->formatBody(replaceCharacters($post->getBody())) . "', source = '" . replaceCharacters($post->getSource()) . "', category = '" . $post->getCategory() . "', status = '" . $post->getStatus() . "' WHERE id_post = '" . $post->getIdPost() . "'"; return DB::query($sql); }
/** * Modify a note saved in the database. * * @param Note $note * @return integer */ public function editNote(Note $note) { $sql = "UPDATE note \n\t\t\tSET note = '" . replaceCharacters($note->getNote()) . "', note_text = '" . replaceCharacters($note->getNoteText()) . "' WHERE id_note = '" . $note->getIdNote() . "'"; return DB::query($sql); }
/** * Modify a provider saved in the database. * * @param Provider $provider * @return integer */ public function editProvider(Provider $provider) { $sql = "UPDATE provider \n\t\t\tSET id_provider_category = '" . $provider->getIdProviderCategory() . "', provider_name = '" . replaceCharacters($provider->getProviderName()) . "', location = '" . replaceCharacters($provider->getLocation()) . "', phone = '" . $provider->getPhone() . "', website = '" . $provider->getWebsite() . "' WHERE id_provider = '" . $provider->getIdProvider() . "'"; return DB::query($sql); }
$_COOKIE[] = setcookie("GameStore", time(), null, "/", null, null, null); function replaceCharacters($string) { $replaced = array("á", "é", "í", "ó", "ú", "Á", "É", "Í", "Ó", "Ú", "ñ", "À", "Ã", "Ì", "Ò", "Ù", "Ù", "à ", "è", "ì", "ò", "ù", "ç", "Ç", "â", "ê", "î", "ô", "û", "Â", "Ê", "ÃŽ", "Ô", "Û", "ü", "ö", "Ö", "ï", "ä", "«", "Ò", "Ã", "Ä", "Ë", " ", "ñ"); $toReplace = array("a", "e", "i", "o", "u", "A", "E", "I", "O", "U", "n", "N", "A", "E", "I", "O", "U", "a", "e", "i", "o", "u", "c", "C", "a", "e", "i", "o", "u", "A", "E", "I", "O", "U", "u", "o", "O", "i", "a", "e", "U", "I", "A", "E", "_", "ng"); $string = str_replace($replaced, $toReplace, $string); return $string; } if (isset($_POST['data'])) { $data = $_POST['data']; //$msg = "Su información ha sido guardada"; $string = "Usuario: " . $data['userName'] . "\n"; $string .= "E-mail: " . $data['userMail'] . "\n"; $string .= "Contraseña: " . sha1($data['pass']) . "\n"; $string .= "URL: " . $data['url'] . "\n"; $string .= "Direccion: " . $data['address'] . "\n"; $string .= "Pais: " . $data['country'] . "\n"; $string .= "Codigo postal: " . $data['postalCode'] . "\n"; $string .= "Comentarios: " . $data['comments']; $fp = fopen(replaceCharacters($data['userName']) . time() . '.txt', 'w'); fwrite($fp, $string); fclose($fp); include '../html/index.html'; } else { if (isset($_POST["registro"])) { include '../html/registro.html'; } else { $msg = "Usuario registrado"; include '../html/index.html'; } }