rabit_android's People
rabit_android's Issues
TODO List #34
- 새로 작성한 로그가 /maininfos 로는 안받아지네용??
- goal에는 사진 올리는거 아직 안했더라구용???
- 내 골리스트 -> 골로그 에서 사진있는 골로그가 있을 때, 새로고침을 하면 사진이 다른 몇 개의 골로그에도 나타나는 버그
- 내 골리스트 -> 골로그 에는 데이터 순서가 반대로 들어옴
- 새로고침 할 때 가장 아래로 가는 이유는 viewAdapter에서 첫번째 요소를 다른걸로 해서 뭐가 꼬인듯...
things to consider about 'goal'
- Have to save the number of the goals that user has.
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);
?>
fragment 참고 git
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)
)
Goal, DailyLog, Participant DDL
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
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
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.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.