Created
May 9, 2013 19:02
-
-
Save kalebrozo/5549701 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?xml version="1.0" encoding="UTF-8"?> | |
<buildpath> | |
<buildpathentry kind="src" path=""/> | |
<buildpathentry kind="con" path="org.eclipse.php.core.LANGUAGE"/> | |
</buildpath> |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
RewriteEngine On | |
# Some hosts may require you to use the `RewriteBase` directive. | |
# If you need to use the `RewriteBase` directive, it should be the | |
# absolute physical path to the directory that contains this htaccess file. | |
# | |
# RewriteBase / | |
RewriteCond %{REQUEST_FILENAME} !-f | |
RewriteRule ^ index.php [QSA,L] |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
restfull |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?xml version="1.0" encoding="UTF-8"?> | |
<project version="4"> | |
<component name="CompilerConfiguration"> | |
<option name="DEFAULT_COMPILER" value="Javac" /> | |
<resourceExtensions /> | |
<wildcardResourcePatterns> | |
<entry name="!?*.java" /> | |
<entry name="!?*.form" /> | |
<entry name="!?*.class" /> | |
<entry name="!?*.groovy" /> | |
<entry name="!?*.scala" /> | |
<entry name="!?*.flex" /> | |
<entry name="!?*.kt" /> | |
<entry name="!?*.clj" /> | |
</wildcardResourcePatterns> | |
<annotationProcessing> | |
<profile default="true" name="Default" enabled="false"> | |
<processorPath useClasspath="true" /> | |
</profile> | |
<profile default="false" name="Maven default annotation processors profile" enabled="true"> | |
<sourceOutputDir name="target/generated-sources/annotations" /> | |
<sourceTestOutputDir name="target/generated-test-sources/test-annotations" /> | |
<outputRelativeToContentRoot value="true" /> | |
<processorPath useClasspath="true" /> | |
<module name="Servico" /> | |
</profile> | |
</annotationProcessing> | |
</component> | |
</project> | |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<component name="CopyrightManager"> | |
<settings default=""> | |
<module2copyright /> | |
</settings> | |
</component> |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?xml version="1.0" encoding="UTF-8"?> | |
<project version="4"> | |
<component name="Encoding" useUTFGuessing="true" native2AsciiForPropertiesFiles="false" /> | |
</project> | |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?xml version="1.0" encoding="UTF-8"?> | |
<project version="4"> | |
<component name="JavaDocConfiguration_1.0.2"> | |
<GENERAL> | |
<MODE>UPDATE</MODE> | |
<OVERRIDDEN_METHODS>false</OVERRIDDEN_METHODS> | |
<LEVELS> | |
<LEVEL>FIELD</LEVEL> | |
<LEVEL>TYPE</LEVEL> | |
<LEVEL>METHOD</LEVEL> | |
</LEVELS> | |
<VISIBILITIES> | |
<VISIBILITY>PROTECTED</VISIBILITY> | |
<VISIBILITY>PUBLIC</VISIBILITY> | |
</VISIBILITIES> | |
</GENERAL> | |
<TEMPLATES> | |
<CLASSES> | |
<CLASS> | |
<KEY>^.*(public|protected|private)*.+interface\s+\w+.*</KEY> | |
<VALUE>/**\n | |
* The interface $name.\n | |
*/</VALUE> | |
</CLASS> | |
<CLASS> | |
<KEY>^.*(public|protected|private)*.+enum\s+\w+.*</KEY> | |
<VALUE>/**\n | |
* The enum $name.\n | |
*/</VALUE> | |
</CLASS> | |
<CLASS> | |
<KEY>^.*(public|protected|private)*.+class\s+\w+.*</KEY> | |
<VALUE>/**\n | |
* The type $name.\n | |
*/</VALUE> | |
</CLASS> | |
<CLASS> | |
<KEY>.+</KEY> | |
<VALUE>/**\n | |
* The type $name.\n | |
*/</VALUE> | |
</CLASS> | |
</CLASSES> | |
<CONSTRUCTORS> | |
<CONSTRUCTOR> | |
<KEY>.+</KEY> | |
<VALUE>/**\n | |
* Instantiates a new $name.\n | |
#if(!$element.parameterList.parameters.isEmpty()) | |
*\n | |
#end | |
#foreach($parameter in $element.parameterList.parameters) | |
* @param $parameter.name the $paramNames[$parameter.name]\n | |
#end | |
#if(!$element.throwsList.referenceElements.isEmpty()) | |
*\n | |
#end | |
#foreach($exception in $element.throwsList.referenceElements) | |
* @throws $exception.referenceName the $exceptionNames[$exception.referenceName]\n | |
#end | |
*/</VALUE> | |
</CONSTRUCTOR> | |
</CONSTRUCTORS> | |
<METHODS> | |
<METHOD> | |
<KEY>^.*(public|protected|private)*\s*.*(\w(\s*<.+>)*)+\s+get\w+\s*\(.*\).+</KEY> | |
<VALUE>/**\n | |
* Gets $partName.\n | |
#if(!$element.parameterList.parameters.isEmpty()) | |
*\n | |
#end | |
#foreach($parameter in $element.parameterList.parameters) | |
* @param $parameter.name the $paramNames[$parameter.name]\n | |
#end | |
#if($isNotVoid) | |
*\n | |
* @return the $partName\n | |
#end | |
#if(!$element.throwsList.referenceElements.isEmpty()) | |
*\n | |
#end | |
#foreach($exception in $element.throwsList.referenceElements) | |
* @throws $exception.referenceName the $exceptionNames[$exception.referenceName]\n | |
#end | |
*/</VALUE> | |
</METHOD> | |
<METHOD> | |
<KEY>^.*(public|protected|private)*\s*.*(void|\w(\s*<.+>)*)+\s+set\w+\s*\(.*\).+</KEY> | |
<VALUE>/**\n | |
* Sets $partName.\n | |
#if(!$element.parameterList.parameters.isEmpty()) | |
*\n | |
#end | |
#foreach($parameter in $element.parameterList.parameters) | |
* @param $parameter.name the $paramNames[$parameter.name]\n | |
#end | |
#if($isNotVoid) | |
*\n | |
* @return the $partName\n | |
#end | |
#if(!$element.throwsList.referenceElements.isEmpty()) | |
*\n | |
#end | |
#foreach($exception in $element.throwsList.referenceElements) | |
* @throws $exception.referenceName the $exceptionNames[$exception.referenceName]\n | |
#end | |
*/</VALUE> | |
</METHOD> | |
<METHOD> | |
<KEY>^.*((public\s+static)|(static\s+public))\s+void\s+main\s*\(\s*String\s*(\[\s*\]|\.\.\.)\s+\w+\s*\).+</KEY> | |
<VALUE>/**\n | |
* The entry point of application.\n | |
#if(!$element.parameterList.parameters.isEmpty()) | |
*\n | |
#end | |
* @param $element.parameterList.parameters[0].name the input arguments\n | |
#if(!$element.throwsList.referenceElements.isEmpty()) | |
*\n | |
#end | |
#foreach($exception in $element.throwsList.referenceElements) | |
* @throws $exception.referenceName the $exceptionNames[$exception.referenceName]\n | |
#end | |
*/</VALUE> | |
</METHOD> | |
<METHOD> | |
<KEY>.+</KEY> | |
<VALUE>/**\n | |
* $name#if($partName.isEmpty()) $return#end.\n | |
#if(!$element.parameterList.parameters.isEmpty()) | |
*\n | |
#end | |
#foreach($parameter in $element.parameterList.parameters) | |
* @param $parameter.name the $paramNames[$parameter.name]\n | |
#end | |
#if($isNotVoid) | |
*\n | |
* @return the $return\n | |
#end | |
#if(!$element.throwsList.referenceElements.isEmpty()) | |
*\n | |
#end | |
#foreach($exception in $element.throwsList.referenceElements) | |
* @throws $exception.referenceName the $exceptionNames[$exception.referenceName]\n | |
#end | |
*/</VALUE> | |
</METHOD> | |
</METHODS> | |
<FIELDS> | |
<FIELD> | |
<KEY>^.*(public|protected|private)*.+static.*(\w\s\w)+.+</KEY> | |
<VALUE>/**\n | |
* The constant $element.getName().\n | |
*/</VALUE> | |
</FIELD> | |
<FIELD> | |
<KEY>^.*(public|protected|private)*.*(\w\s\w)+.+</KEY> | |
<VALUE>/**\n | |
* The $name.\n | |
*/</VALUE> | |
</FIELD> | |
<FIELD> | |
<KEY>.+</KEY> | |
<VALUE>/**\n | |
* The $name.\n | |
*/</VALUE> | |
</FIELD> | |
</FIELDS> | |
</TEMPLATES> | |
</component> | |
<component name="MavenProjectsManager"> | |
<option name="originalFiles"> | |
<list> | |
<option value="$PROJECT_DIR$/pom.xml" /> | |
</list> | |
</option> | |
</component> | |
<component name="ProjectRootManager" version="2" languageLevel="JDK_1_6" assert-keyword="true" jdk-15="true"> | |
<output url="file://$PROJECT_DIR$/out" /> | |
</component> | |
<component name="masterDetails"> | |
<states> | |
<state key="ProjectJDKs.UI"> | |
<settings> | |
<splitter-proportions> | |
<option name="proportions"> | |
<list> | |
<option value="0.2" /> | |
</list> | |
</option> | |
</splitter-proportions> | |
</settings> | |
</state> | |
</states> | |
</component> | |
</project> | |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?xml version="1.0" encoding="UTF-8"?> | |
<project version="4"> | |
<component name="ProjectModuleManager"> | |
<modules> | |
<module fileurl="file://$PROJECT_DIR$/Servico.iml" filepath="$PROJECT_DIR$/Servico.iml" /> | |
</modules> | |
</component> | |
</project> | |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<component name="DependencyValidationManager"> | |
<state> | |
<option name="SKIP_IMPORT_STATEMENTS" value="false" /> | |
</state> | |
</component> |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?xml version="1.0" encoding="UTF-8"?> | |
<project version="4"> | |
<component name="Palette2"> | |
<group name="Swing"> | |
<item class="com.intellij.uiDesigner.HSpacer" tooltip-text="Horizontal Spacer" icon="/com/intellij/uiDesigner/icons/hspacer.png" removable="false" auto-create-binding="false" can-attach-label="false"> | |
<default-constraints vsize-policy="1" hsize-policy="6" anchor="0" fill="1" /> | |
</item> | |
<item class="com.intellij.uiDesigner.VSpacer" tooltip-text="Vertical Spacer" icon="/com/intellij/uiDesigner/icons/vspacer.png" removable="false" auto-create-binding="false" can-attach-label="false"> | |
<default-constraints vsize-policy="6" hsize-policy="1" anchor="0" fill="2" /> | |
</item> | |
<item class="javax.swing.JPanel" icon="/com/intellij/uiDesigner/icons/panel.png" removable="false" auto-create-binding="false" can-attach-label="false"> | |
<default-constraints vsize-policy="3" hsize-policy="3" anchor="0" fill="3" /> | |
</item> | |
<item class="javax.swing.JScrollPane" icon="/com/intellij/uiDesigner/icons/scrollPane.png" removable="false" auto-create-binding="false" can-attach-label="true"> | |
<default-constraints vsize-policy="7" hsize-policy="7" anchor="0" fill="3" /> | |
</item> | |
<item class="javax.swing.JButton" icon="/com/intellij/uiDesigner/icons/button.png" removable="false" auto-create-binding="true" can-attach-label="false"> | |
<default-constraints vsize-policy="0" hsize-policy="3" anchor="0" fill="1" /> | |
<initial-values> | |
<property name="text" value="Button" /> | |
</initial-values> | |
</item> | |
<item class="javax.swing.JRadioButton" icon="/com/intellij/uiDesigner/icons/radioButton.png" removable="false" auto-create-binding="true" can-attach-label="false"> | |
<default-constraints vsize-policy="0" hsize-policy="3" anchor="8" fill="0" /> | |
<initial-values> | |
<property name="text" value="RadioButton" /> | |
</initial-values> | |
</item> | |
<item class="javax.swing.JCheckBox" icon="/com/intellij/uiDesigner/icons/checkBox.png" removable="false" auto-create-binding="true" can-attach-label="false"> | |
<default-constraints vsize-policy="0" hsize-policy="3" anchor="8" fill="0" /> | |
<initial-values> | |
<property name="text" value="CheckBox" /> | |
</initial-values> | |
</item> | |
<item class="javax.swing.JLabel" icon="/com/intellij/uiDesigner/icons/label.png" removable="false" auto-create-binding="false" can-attach-label="false"> | |
<default-constraints vsize-policy="0" hsize-policy="0" anchor="8" fill="0" /> | |
<initial-values> | |
<property name="text" value="Label" /> | |
</initial-values> | |
</item> | |
<item class="javax.swing.JTextField" icon="/com/intellij/uiDesigner/icons/textField.png" removable="false" auto-create-binding="true" can-attach-label="true"> | |
<default-constraints vsize-policy="0" hsize-policy="6" anchor="8" fill="1"> | |
<preferred-size width="150" height="-1" /> | |
</default-constraints> | |
</item> | |
<item class="javax.swing.JPasswordField" icon="/com/intellij/uiDesigner/icons/passwordField.png" removable="false" auto-create-binding="true" can-attach-label="true"> | |
<default-constraints vsize-policy="0" hsize-policy="6" anchor="8" fill="1"> | |
<preferred-size width="150" height="-1" /> | |
</default-constraints> | |
</item> | |
<item class="javax.swing.JFormattedTextField" icon="/com/intellij/uiDesigner/icons/formattedTextField.png" removable="false" auto-create-binding="true" can-attach-label="true"> | |
<default-constraints vsize-policy="0" hsize-policy="6" anchor="8" fill="1"> | |
<preferred-size width="150" height="-1" /> | |
</default-constraints> | |
</item> | |
<item class="javax.swing.JTextArea" icon="/com/intellij/uiDesigner/icons/textArea.png" removable="false" auto-create-binding="true" can-attach-label="true"> | |
<default-constraints vsize-policy="6" hsize-policy="6" anchor="0" fill="3"> | |
<preferred-size width="150" height="50" /> | |
</default-constraints> | |
</item> | |
<item class="javax.swing.JTextPane" icon="/com/intellij/uiDesigner/icons/textPane.png" removable="false" auto-create-binding="true" can-attach-label="true"> | |
<default-constraints vsize-policy="6" hsize-policy="6" anchor="0" fill="3"> | |
<preferred-size width="150" height="50" /> | |
</default-constraints> | |
</item> | |
<item class="javax.swing.JEditorPane" icon="/com/intellij/uiDesigner/icons/editorPane.png" removable="false" auto-create-binding="true" can-attach-label="true"> | |
<default-constraints vsize-policy="6" hsize-policy="6" anchor="0" fill="3"> | |
<preferred-size width="150" height="50" /> | |
</default-constraints> | |
</item> | |
<item class="javax.swing.JComboBox" icon="/com/intellij/uiDesigner/icons/comboBox.png" removable="false" auto-create-binding="true" can-attach-label="true"> | |
<default-constraints vsize-policy="0" hsize-policy="2" anchor="8" fill="1" /> | |
</item> | |
<item class="javax.swing.JTable" icon="/com/intellij/uiDesigner/icons/table.png" removable="false" auto-create-binding="true" can-attach-label="false"> | |
<default-constraints vsize-policy="6" hsize-policy="6" anchor="0" fill="3"> | |
<preferred-size width="150" height="50" /> | |
</default-constraints> | |
</item> | |
<item class="javax.swing.JList" icon="/com/intellij/uiDesigner/icons/list.png" removable="false" auto-create-binding="true" can-attach-label="false"> | |
<default-constraints vsize-policy="6" hsize-policy="2" anchor="0" fill="3"> | |
<preferred-size width="150" height="50" /> | |
</default-constraints> | |
</item> | |
<item class="javax.swing.JTree" icon="/com/intellij/uiDesigner/icons/tree.png" removable="false" auto-create-binding="true" can-attach-label="false"> | |
<default-constraints vsize-policy="6" hsize-policy="6" anchor="0" fill="3"> | |
<preferred-size width="150" height="50" /> | |
</default-constraints> | |
</item> | |
<item class="javax.swing.JTabbedPane" icon="/com/intellij/uiDesigner/icons/tabbedPane.png" removable="false" auto-create-binding="true" can-attach-label="false"> | |
<default-constraints vsize-policy="3" hsize-policy="3" anchor="0" fill="3"> | |
<preferred-size width="200" height="200" /> | |
</default-constraints> | |
</item> | |
<item class="javax.swing.JSplitPane" icon="/com/intellij/uiDesigner/icons/splitPane.png" removable="false" auto-create-binding="false" can-attach-label="false"> | |
<default-constraints vsize-policy="3" hsize-policy="3" anchor="0" fill="3"> | |
<preferred-size width="200" height="200" /> | |
</default-constraints> | |
</item> | |
<item class="javax.swing.JSpinner" icon="/com/intellij/uiDesigner/icons/spinner.png" removable="false" auto-create-binding="true" can-attach-label="true"> | |
<default-constraints vsize-policy="0" hsize-policy="6" anchor="8" fill="1" /> | |
</item> | |
<item class="javax.swing.JSlider" icon="/com/intellij/uiDesigner/icons/slider.png" removable="false" auto-create-binding="true" can-attach-label="false"> | |
<default-constraints vsize-policy="0" hsize-policy="6" anchor="8" fill="1" /> | |
</item> | |
<item class="javax.swing.JSeparator" icon="/com/intellij/uiDesigner/icons/separator.png" removable="false" auto-create-binding="false" can-attach-label="false"> | |
<default-constraints vsize-policy="6" hsize-policy="6" anchor="0" fill="3" /> | |
</item> | |
<item class="javax.swing.JProgressBar" icon="/com/intellij/uiDesigner/icons/progressbar.png" removable="false" auto-create-binding="true" can-attach-label="false"> | |
<default-constraints vsize-policy="0" hsize-policy="6" anchor="0" fill="1" /> | |
</item> | |
<item class="javax.swing.JToolBar" icon="/com/intellij/uiDesigner/icons/toolbar.png" removable="false" auto-create-binding="false" can-attach-label="false"> | |
<default-constraints vsize-policy="0" hsize-policy="6" anchor="0" fill="1"> | |
<preferred-size width="-1" height="20" /> | |
</default-constraints> | |
</item> | |
<item class="javax.swing.JToolBar$Separator" icon="/com/intellij/uiDesigner/icons/toolbarSeparator.png" removable="false" auto-create-binding="false" can-attach-label="false"> | |
<default-constraints vsize-policy="0" hsize-policy="0" anchor="0" fill="1" /> | |
</item> | |
<item class="javax.swing.JScrollBar" icon="/com/intellij/uiDesigner/icons/scrollbar.png" removable="false" auto-create-binding="true" can-attach-label="false"> | |
<default-constraints vsize-policy="6" hsize-policy="0" anchor="0" fill="2" /> | |
</item> | |
</group> | |
</component> | |
</project> | |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?xml version="1.0" encoding="UTF-8"?> | |
<project version="4"> | |
<component name="VcsDirectoryMappings"> | |
<mapping directory="" vcs="" /> | |
</component> | |
</project> | |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?xml version="1.0" encoding="UTF-8"?> | |
<projectDescription> | |
<name>Servico</name> | |
<comment></comment> | |
<projects> | |
</projects> | |
<buildSpec> | |
<buildCommand> | |
<name>org.eclipse.wst.validation.validationbuilder</name> | |
<arguments> | |
</arguments> | |
</buildCommand> | |
<buildCommand> | |
<name>org.eclipse.dltk.core.scriptbuilder</name> | |
<arguments> | |
</arguments> | |
</buildCommand> | |
<buildCommand> | |
<name>org.eclipse.wst.common.project.facet.core.builder</name> | |
<arguments> | |
</arguments> | |
</buildCommand> | |
</buildSpec> | |
<natures> | |
<nature>org.eclipse.wst.common.project.facet.core.nature</nature> | |
<nature>org.eclipse.php.core.PHPNature</nature> | |
</natures> | |
</projectDescription> |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
eclipse.preferences.version=1 | |
include_path=0;/Servico |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?xml version="1.0" encoding="UTF-8"?> | |
<faceted-project> | |
<fixed facet="php.core.component"/> | |
<fixed facet="php.component"/> | |
<installed facet="php.core.component" version="1"/> | |
<installed facet="php.component" version="5.4"/> | |
</faceted-project> |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?php | |
require '../Slim/Slim/Slim.php'; | |
\Slim\Slim::registerAutoloader(); | |
$app = new \Slim\Slim(); | |
$app->response()->header('Content-Type', 'application/json;charset=utf-8'); | |
$app->get('/', function () { | |
echo "SlimProdutos"; | |
}); | |
$app->get('/categorias','getCategorias'); | |
$app->get('/categoria/:id','getCategoria'); | |
$app->post('/produtos','addProduto'); | |
$app->post('/categorias','addCategoria'); | |
$app->get('/produtos/:id','getProduto'); | |
$app->post('/produtos/:id','saveProduto'); | |
$app->delete('/produtos/:id','deleteProduto'); | |
$app->get('/produtos','getProdutos'); | |
$app->run(); | |
function getConn() | |
{ | |
return new PDO('mysql:host=localhost;dbname=usu_calebev','calebev','2743cny', | |
array(PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8") | |
); | |
} | |
function getCategorias() | |
{ | |
$stmt = getConn()->query("SELECT * FROM categorias"); | |
$categorias = $stmt->fetchAll(PDO::FETCH_OBJ); | |
echo "{categorias:".json_encode($categorias)."}"; | |
} | |
function addCategoria() | |
{ | |
$request = \Slim\Slim::getInstance()->request(); | |
//$produto = json_decode($request->postBody()); | |
$produto = json_decode(json_encode($_POST)); | |
$sql = "INSERT INTO categorias (nome) values (:nome) "; | |
$conn = getConn(); | |
$stmt = $conn->prepare($sql); | |
$stmt->bindParam("nome",$produto->nome); | |
$stmt->execute(); | |
$produto->id = $conn->lastInsertId(); | |
echo json_encode($produto); | |
} | |
function getCategoria($id) | |
{ | |
$conn = getConn(); | |
$sql = "SELECT * FROM categorias WHERE id=:id"; | |
$stmt = $conn->prepare($sql); | |
$stmt->bindParam("id",$id); | |
$stmt->execute(); | |
$categoria = $stmt->fetchObject(); | |
echo json_encode($categoria); | |
} | |
function addProduto() | |
{ | |
$request = \Slim\Slim::getInstance()->request(); | |
//$produto = json_decode($request->postBody()); | |
$produto = json_decode(json_encode($_POST)); | |
$sql = "INSERT INTO produtos (nome,preco,dataInclusao,idCategoria) values (:nome,:preco,:dataInclusao,:idCategoria) "; | |
$conn = getConn(); | |
$stmt = $conn->prepare($sql); | |
$stmt->bindParam("nome",$produto->nome); | |
$stmt->bindParam("preco",$produto->preco); | |
$stmt->bindParam("dataInclusao",$produto->dataInclusao); | |
$stmt->bindParam("idCategoria",$produto->idCategoria); | |
$stmt->execute(); | |
$produto->id = $conn->lastInsertId(); | |
echo json_encode($produto); | |
} | |
function getProduto($id) | |
{ | |
$conn = getConn(); | |
$sql = "SELECT * FROM produtos WHERE id=:id"; | |
$stmt = $conn->prepare($sql); | |
$stmt->bindParam("id",$id); | |
$stmt->execute(); | |
$produto = $stmt->fetchObject(); | |
//categoria | |
$sql = "SELECT * FROM categorias WHERE id=:id"; | |
$stmt = $conn->prepare($sql); | |
$stmt->bindParam("id",$produto->idCategoria); | |
$stmt->execute(); | |
$produto->categoria = $stmt->fetchObject(); | |
echo json_encode($produto); | |
} | |
function saveProduto($id) | |
{ | |
$request = \Slim\Slim::getInstance()->request(); | |
$produto = json_decode($request->getBody()); | |
$sql = "UPDATE produtos SET nome=:nome,preco=:preco,dataInclusao=:dataInclusao,idCategoria=:idCategoria WHERE id=:id"; | |
$conn = getConn(); | |
$stmt = $conn->prepare($sql); | |
$stmt->bindParam("nome",$produto->nome); | |
$stmt->bindParam("preco",$produto->preco); | |
$stmt->bindParam("dataInclusao",$produto->dataInclusao); | |
$stmt->bindParam("idCategoria",$produto->idCategoria); | |
$stmt->bindParam("id",$id); | |
$stmt->execute(); | |
echo json_encode($produto); | |
} | |
function deleteProduto($id) | |
{ | |
$sql = "DELETE FROM produtos WHERE id=:id"; | |
$conn = getConn(); | |
$stmt = $conn->prepare($sql); | |
$stmt->bindParam("id",$id); | |
$stmt->execute(); | |
echo "{'message':'Produto apagado'}"; | |
} | |
function getProdutos() | |
{ | |
$sql = "SELECT *,Categorias.nome as nomeCategoria FROM Produtos,Categorias WHERE Categorias.id=Produtos.idCategoria"; | |
$stmt = getConn()->query($sql); | |
$produtos = $stmt->fetchAll(PDO::FETCH_OBJ); | |
echo "{\"produtos\":".json_encode($produtos)."}"; | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?xml version="1.0" encoding="UTF-8"?> | |
<project xmlns="http://maven.apache.org/POM/4.0.0" | |
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" | |
xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd"> | |
<modelVersion>4.0.0</modelVersion> | |
<groupId>groupId</groupId> | |
<artifactId>Servico</artifactId> | |
<version>1.0-SNAPSHOT</version> | |
</project> |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?xml version="1.0" encoding="UTF-8"?> | |
<module org.jetbrains.idea.maven.project.MavenProjectsManager.isMavenModule="true" type="JAVA_MODULE" version="4"> | |
<component name="NewModuleRootManager" inherit-compiler-output="false"> | |
<output url="file://$MODULE_DIR$/target/classes" /> | |
<output-test url="file://$MODULE_DIR$/target/test-classes" /> | |
<exclude-output /> | |
<content url="file://$MODULE_DIR$"> | |
<sourceFolder url="file://$MODULE_DIR$/src/main/java" isTestSource="false" /> | |
<sourceFolder url="file://$MODULE_DIR$/src/main/resources" isTestSource="false" /> | |
<sourceFolder url="file://$MODULE_DIR$/src/test/java" isTestSource="true" /> | |
<excludeFolder url="file://$MODULE_DIR$/target" /> | |
</content> | |
<orderEntry type="inheritedJdk" /> | |
<orderEntry type="sourceFolder" forTests="false" /> | |
</component> | |
</module> | |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment