>

Fórum

Fórum da RL System, voltado para analistas, programadores etc. Tudo sobre linguagem de programação e desenvolvimento Full Stack: Banco de Dados, Android, C#, Java, .NET, PHP, Node, Javascript, TypeScript, Front, HTML e muito mais.



Crud básico com php e mysql?


Bom dia, sou iniciante no android.
Preciso de um crud básico que salve os dados em uma aplicação php com banco mysql, alguém pode me ajudar?



12 Respostas


OLA Romario

veja esse site aqui

http://androidhive.info/2012/05/how-to-connect-android-with-php-mysql/




Obrigado André.




bom dia André

conseguir fazer esse exemplo, compila, abre no emulador, mais na hora de fazer a comunicação com o banco a aplicação para, o que pode ser?

uso o eclipse e o xampp




ola Romario...

vc esta colocando o ip da sua maquina???




sim, troquei o caminho pelo meu ip, o problema é que não me traz mensagem de erro, simplesmente fecha o aplicativo quando tento inserir ou pesquisar.





pode colocar o log do erro q ta gerando....




01-28 13:01:21.827: E/Buffer Error(21583): Error converting result java.lang.NullPointerException
01-28 13:01:21.857: E/JSON Parser(21583): Error parsing data org.json.JSONException: End of input at character 0 of
01-28 13:01:21.997: E/AndroidRuntime(21583): Uncaught handler: thread AsyncTask #1 exiting due to uncaught exception
01-28 13:01:22.027: E/AndroidRuntime(21583): FATAL EXCEPTION: AsyncTask #1
01-28 13:01:22.027: E/AndroidRuntime(21583): java.lang.RuntimeException: An error occured while executing doInBackground()
01-28 13:01:22.027: E/AndroidRuntime(21583): at android.os.AsyncTask$3.done(AsyncTask.java:278)
01-28 13:01:22.027: E/AndroidRuntime(21583): at java.util.concurrent.FutureTask$Sync.innerSetException(FutureTask.java:273)
01-28 13:01:22.027: E/AndroidRuntime(21583): at java.util.concurrent.FutureTask.setException(FutureTask.java:124)
01-28 13:01:22.027: E/AndroidRuntime(21583): at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:307)
01-28 13:01:22.027: E/AndroidRuntime(21583): at java.util.concurrent.FutureTask.run(FutureTask.java:137)
01-28 13:01:22.027: E/AndroidRuntime(21583): at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1076)
01-28 13:01:22.027: E/AndroidRuntime(21583): at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:569)
01-28 13:01:22.027: E/AndroidRuntime(21583): at java.lang.Thread.run(Thread.java:856)
01-28 13:01:22.027: E/AndroidRuntime(21583): Caused by: java.lang.NullPointerException
01-28 13:01:22.027: E/AndroidRuntime(21583): at com.example.androidhive.AllProductsActivity$LoadAllProducts.doInBackground(AllProductsActivity.java:130)
01-28 13:01:22.027: E/AndroidRuntime(21583): at com.example.androidhive.AllProductsActivity$LoadAllProducts.doInBackground(AllProductsActivity.java:1)
01-28 13:01:22.027: E/AndroidRuntime(21583): at android.os.AsyncTask$2.call(AsyncTask.java:264)
01-28 13:01:22.027: E/AndroidRuntime(21583): at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:305)
01-28 13:01:22.027: E/AndroidRuntime(21583): ... 4 more
01-28 13:01:22.427: E/WindowManager(21583): Activity com.example.androidhive.AllProductsActivity has leaked window com.android.internal.policy.impl.PhoneWindow$DecorView@41416b70 that was originally added here
01-28 13:01:22.427: E/WindowManager(21583): android.view.WindowLeaked: Activity com.example.androidhive.AllProductsActivity has leaked window com.android.internal.policy.impl.PhoneWindow$DecorView@41416b70 that was originally added here
01-28 13:01:22.427: E/WindowManager(21583): at android.view.ViewRootImpl.(ViewRootImpl.java:344)
01-28 13:01:22.427: E/WindowManager(21583): at android.view.WindowManagerImpl.addView(WindowManagerImpl.java:267)
01-28 13:01:22.427: E/WindowManager(21583): at android.view.WindowManagerImpl.addView(WindowManagerImpl.java:215)
01-28 13:01:22.427: E/WindowManager(21583): at android.view.WindowManagerImpl$CompatModeWrapper.addView(WindowManagerImpl.java:140)
01-28 13:01:22.427: E/WindowManager(21583): at android.view.Window$LocalWindowManager.addView(Window.java:537)
01-28 13:01:22.427: E/WindowManager(21583): at android.app.Dialog.show(Dialog.java:278)
01-28 13:01:22.427: E/WindowManager(21583): at com.example.androidhive.AllProductsActivity$LoadAllProducts.onPreExecute(AllProductsActivity.java:117)
01-28 13:01:22.427: E/WindowManager(21583): at android.os.AsyncTask.executeOnExecutor(AsyncTask.java:561)
01-28 13:01:22.427: E/WindowManager(21583): at android.os.AsyncTask.execute(AsyncTask.java:511)
01-28 13:01:22.427: E/WindowManager(21583): at com.example.androidhive.AllProductsActivity.onCreate(AllProductsActivity.java:57)
01-28 13:01:22.427: E/WindowManager(21583): at android.app.Activity.performCreate(Activity.java:4494)
01-28 13:01:22.427: E/WindowManager(21583): at android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1053)
01-28 13:01:22.427: E/WindowManager(21583): at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:1927)
01-28 13:01:22.427: E/WindowManager(21583): at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:1988)
01-28 13:01:22.427: E/WindowManager(21583): at android.app.ActivityThread.access$600(ActivityThread.java:125)
01-28 13:01:22.427: E/WindowManager(21583): at android.app.ActivityThread$H.handleMessage(ActivityThread.java:1154)
01-28 13:01:22.427: E/WindowManager(21583): at android.os.Handler.dispatchMessage(Handler.java:99)
01-28 13:01:22.427: E/WindowManager(21583): at android.os.Looper.loop(Looper.java:137)
01-28 13:01:22.427: E/WindowManager(21583): at android.app.ActivityThread.main(ActivityThread.java:4431)
01-28 13:01:22.427: E/WindowManager(21583): at java.lang.reflect.Method.invokeNative(Native Method)
01-28 13:01:22.427: E/WindowManager(21583): at java.lang.reflect.Method.invoke(Method.java:511)
01-28 13:01:22.427: E/WindowManager(21583): at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:843)
01-28 13:01:22.427: E/WindowManager(21583): at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:610)
01-28 13:01:22.427: E/WindowManager(21583): at dalvik.system.NativeStart.main(Native Method)




pq num faz com o wamp??

eu ja tive muitos problemas com o xampp




instalei o Wamp, mais da o mesmo erro.
Deixa eu te falar, esse é um projetinho acadêmico de uma pós que to fazendo, vc não teria um exemplo de crud salvando sem erros no banco mysql? coisa simples mesmo, já tentei vários ex mais nada funciona.




eu num tenho nao, :(

mas faz assim no wamp

Abra httpd.conf (arquivo de configuração Apache) arquivo de onde você instalou o Wamp Server e veja neste arquivo


Options Indexes FollowSymLinks Includes ExecCGI
AllowOverride all
Order Deny,Allow
Deny from all
Allow from 127.0.0.1


e


Options Indexes FollowSymLinks MultiViews
AllowOverride all
Order Deny,Allow
Deny from all
Allow from 127.0.0.1


Mude para


Options Indexes FollowSymLinks Includes ExecCGI
AllowOverride All
Order allow,deny
Allow from all

e


Options Indexes FollowSymLinks MultiViews
AllowOverride All
Order allow,deny
Allow from all




não tenho essas linhas no httpd.conf




no meu aparece........... entao reinstala o wamp.........