roberto68

function proceed($mapType){ switch($mapType) { case "showevent" : $("#dropdowns").attr("action", showEvent.html); $("#dropdowns").submit(); window.location.replace("showEvent.html"); break; case "addplace" : $("#dropdowns").attr("action", addPlace.html); $("#dropdowns").submit(); window.location.replace("addPlace.html");break; case "addevent" : $("#dropdowns").attr("action",map.html); $("#dropdowns").submit(); window.location.replace("map.html");break; here's javascript and here is html <input type="button" value="add a place" id="addplace" onclick="proceed(addplace)" /> <input type="button" value="add an event" id="addevent" onclick="proceed(addevent)" /> <input type="button" value="show event" id="showevent" onclick="proceed(showevent)" /> what I want is to post dropdowns form ( form consisting of 4 dropdown lists) to diffenrent page - according to button clicked and redirect to that page after that

thanks actually there should be parnenthesis but after add column, unlike I get an error alter table pictures add column (location_id int not null, foreign key(location_id) references locations (id) on delete cascade on update restrict);

I need to create a foregin key in table pictures that references id from table locations - locations.id - I chcek mariaDB manuals https://mariadb.com/kb/en/mariadb/foreign-keys/ but it says I have error in my syntax still here's my code alter table pictures(add column location_id int not null, foreign key(location_id) references locations (id) on delete cascade on update restrict) what am I doing wrong? and one more question : how to create index in MariaDB cause I haven't been successfull in that too, thanks

I need to do a simple task user selects on Dropdown list - whether to take, or upload picture - and then whole from (the picture is the part of this form is send to php script so it can be saved to Database. so i google a bit but I'm still confused a little. so here's what I'm using //the javascript$("takePhoto").change(function() { // cchek - DDlist state change if(this.checked) { addPhotos(); } }function takeAction(){ $("#addPlace").submit(); }function addPhotos() { var takePicture = document.querySelector("#take-picture"), showPicture = document.querySelector("#show-picture"); if (takePicture && showPicture) { // Set events takePicture.onchange = function (event) { // Get a reference to the taken picture or chosen file var files = event.target.files, file; if (files && files.length > 0) { file = files[0]; try { // Get window.URL object var URL = window.URL || window.webkitURL; // Create ObjectURL var imgURL = URL.createObjectURL(file); // Set img src to ObjectURL showPicture.src = imgURL; // Revoke ObjectURL URL.revokeObjectURL(imgURL); } catch (e) { try { // Fallback if createObjectURL is not supported var fileReader = new FileReader(); fileReader.onload = function (event) { showPicture.src = event.target.result; }; fileReader.readAsDataURL(file); } catch (e) { // var error = document.querySelector("#error"); if (error) { error.innerHTML = "Neither createObjectURL or FileReader are supported"; } } } } }; }} //and finally the php.... $photo=$_POST['take-picture']; <form id="addPlace" action="set_coords.php" enctype="multipart/form-data"> <input type="text" name="location" id="location" visibility="hidden" /> Location: <input name="address" type="text" id="address" /><input type="hidden" name="total" id="total"/> Add Playground photos <select id="uploadType" ><option type="file" name="takePhoto" id="take-picture" accept="image/*"/> <option type="file" id="upload" onclick="upload();">Upload a photo</option> <!-- funckia upload - definovatv global js --> </select> <input type="checkbox" id="photo_boolean" /> </form> is that all I need?