Code Monkey home page Code Monkey logo

rabit_android's People

Contributors

cy118 avatar

Watchers

James Cloos avatar  avatar

Forkers

joddev cy118

rabit_android's Issues

TODO List #34

  • 새로 작성한 로그가 /maininfos 로는 안받아지네용??
  • goal에는 사진 올리는거 아직 안했더라구용???
  • 내 골리스트 -> 골로그 에서 사진있는 골로그가 있을 때, 새로고침을 하면 사진이 다른 몇 개의 골로그에도 나타나는 버그
  • 내 골리스트 -> 골로그 에는 데이터 순서가 반대로 들어옴
  • 새로고침 할 때 가장 아래로 가는 이유는 viewAdapter에서 첫번째 요소를 다른걸로 해서 뭐가 꼬인듯...

What I have to do until 5/19

  • make MyPage including GoalLlist which have participantList and dailyLogList

  • make new logo

  • fill application form of cf.snu.ac.kr

Register.php code that I used

<?php
    $con = mysqli_connect("localhost", "root", "password", "dbName");

    $name = $_POST["name"];
    $email = $_POST["email"];
    $password = $_POST["password"];
    $phone = $_POST["phone"];
    $age = $_POST["age"];

    $statement = mysqli_prepare($con, "INSERT INTO User VALUES (?, ?, ?, ?, ?)");
    mysqli_stmt_bind_param($statement, "ssssi", $name, $email, $password, $phone, $age);
    mysqli_stmt_execute($statement);

    $response = array();
    $response["success"] = false;

    while(mysqli_stmt_fetch($statement)) {
        $response["success"] = true;
    }
    echo json_encode($response);
?>

Login.php code that I used

<?php
    $con = mysqli_connect("localhost", "root", "password", "dbName");

    $email = $_POST["email"];
    $password = $_POST["password"];

    $statement = mysqli_prepare($con, "SELECT * FROM User WHERE email = ? AND password = ?");
    mysqli_stmt_bind_param($statement, "ss", $email, $password);
    mysqli_stmt_execute($statement);

     mysqli_stmt_store_result($statement);
     mysqli_stmt_bind_result($statement, $email);

    $response = array();
    $response["success"] = false;

    while(mysqli_stmt_fetch($statement)) {
        $response["success"] = true;
        $response["email"] = $email;
    }

    echo json_encode($response);
?>

User table DDL that I used

create table rabit.User(  
    name varchar(20) not null,  
    email varchar(20) not null,  
    password varchar(20) not null,  
    phone varchar(20),  
    age numeric(3,0),  
    primary key(email)  
)

When making register back-end

When making register back-end, you should make trigger:
trigger that check if phone number and age is null(' ') or not.
If it is null(' '), you should change it to real null(literally null).
I temporarily send '1' to Register.php instead of ' ', cause insert value ' ' to table makes an error.
Takes care of it!
And let me know when you treated it, so I can change my front-end code.

#28에 대한 TODO 보완사항

#28 에 대한 보완사항

  • 댓글을 작성하고 반영될때까지 추가 작성을 방지하는 기능이 필요
  • 응원하기도 비슷하게 반영

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.