then put the item id's on it's respective radio field
<html>
<body>
<form name="input" action="SQLQuery.php" method="post">
<input type="radio" name="tools" value="1" /> Total profit and number sold for Hammers<br />
<input type="radio" name="tools" value="2" /> Total profit and number sold for Wrenches<br />
<input type="radio" name="tools" value="3" /> Total profit and number sold for Pliers<br />
<input type="radio" name="tools" value="4" /> Total profit and number sold for Handsaw<br />
<input type="radio" name="tools" value="total" /> Total value of items in Inventory<br /><br />
<input type="submit" value="Submit">
</form>
<p>
Click the "Submit" button to query the record.
</p>
</body>
</html>
values 1,2,3 and 4 are just a sample id, changed it to the id on your table
depend if you like it, you can do any project without MVC it's not really vital you should do MVC every project, there pros and cons on using MVC but i think the thing i like about MVC is the it's structure and workflow, with MVC your files are organized, you divide logic to your view and you had controllers act as routers, with MVC your co-workers will find eaasy to trace your code, because MVC uses URI to determine which controller and method you use. MVC has clean url, Search Engine Friendly. If you decide to use MVC i recommend Code Igniter, it's a very good MVC, it has helper class that can help lessen your work
no don't make a button for the search list view, it's much better if you just make them clickable, wrap them with anchors <a>, add id to link so upon clicking them, you will be redirected to it's detail view, where there you can display your positive and negative comments
hey flipgothic haha i don't know if you can understand us right but what we are trying to say is, when you insert use the name-values pairs algorithm, what your using now is your just specifying values it's ok but it follow correct order based on your table structure, you must've inserted the values incorrectly in wrong order, ex of pairing name-values query
mysql_query("INSERT INTO Persons (FirstName, LastName, Age) VALUES ('Glenn', 'Quagmire', '33')");
and btw ha ha of course it's gonna return blank if your insert.php is empty you got to put your insert code there and put whatever output you want to display :D
1st you got to create a list view for person, you can list them up using <ul> then have them assign checkboxes each, then assign some id on every checkbox so you can specify which record to delete
unlink works, if it doesn't then there's problem with your path, if you doubt it's functionality, try doing simple test, like unlink(test.php); putting unlink script and test.php into the same directory
glad to help my friend, actually im just really giving you advise, it was really you who solved the problem :) , btw is this problem solved? one way of saying thanks is marking this thread solved :D
btw i find it hard to debug here in my end because of your includes, i don't them files you know, well nevermind i don't know if im helping you but i don't really know what you want to achieve
hey dude, one thing is bugging me, if you use json to return values why are you commenting json_encode($rowsSaved)? and just so you know everything you echo or printf is returned when call ajax
hey dude, i assume you know how to use firebug, try to check firebug's NET tab, and then check your request there, then click on the response tab, to see the response, because you could've error on your revise.php
@cereal ha ha yeah man i already done that setting it in absolute path, then restarting the server, the php for php-cgi works fine, it's PHP scripts. well thanks for the reply anyways, ill try to figure out this myself then :)
basing on the title... want to get inside PHP? then you have to start at the basic, learn the native php then if you want to go advance learn OOP as most of frameworks are OOP
@cereal hey dude thanks for the reply.... yes im using localhost were gonna be developing some php project on nginx soon so i wanna 1st familiarize myself on this, i've managed to run php and mysql now i want to learn how to add virtual host. yes i already done that on the host file, 127.0.0.1gecko.local, actually i know how to create virtual host, but on apache not on nginx. After adding the servername on the hostfile, i updated the nginx.conf file and entered some server block, but i only managed to call the servername which is gecko.local but it's not pointing to the subdirectory i want it to point, it still pointing at the root folder. my directory hierarchy is like this (ill show you an absoulute path) C:/nginx/html/ <----- this is the root right C:/nginx/html/gecko/ <--- this is the directory i want my virtual host to point now on my nginx.conf i added inside the http block
server {
listen 80;
server_name gecko.local;
location / {
root html/gecko; #i also tried absolute path C:/nginx/html/gecko
index index.php;
}
}
i also tried this
server {
listen 80;
server_name gecko.local
index index.php
root html/gecko;
}
your new to PHP? but your doing joomla? for me, going directly to CMS is a bad choice for starters, it's better if you 1st familiarize yourself with the basic and native php before you go advance. joomla is framework and it's coding structure is not just typical function structures you see everyday....joomla is an Object Oriented Framework
Hi guys i need your help, i need to know how run PHP on nginx, i already installed it but it only reads html files not PHP, it will prompt download the php file. Im super new to this and the tutorial on the net's are complicated. btw im using windows 7, so anybody here had experience setting it up on windows?
btw this code only works for that certain pattern article.php/watever/watever, because im also a newbie on htaccess im just still reading right now on the basic parts, maybe the conditional statements in htaccess RewriteCond can do the trick, but i haven't read that part yet :D
