Ufdjrw

How can I raise concerns with a new DM about XP splitting?

Can the electrostatic force be infinite in magnitude?

Can somebody explain Brexit in a few child-proof sentences?

Superhero words!

A workplace installs custom certificates on personal devices, can this be used to decrypt HTTPS traffic?

Can I rely on these GitHub repository files?

Organic chemistry Iodoform Reaction

Are Warlocks Arcane or Divine?

Teaching indefinite integrals that require special-casing

Partial sums of primes

What is the opposite of 'gravitas'?

Freedom of speech and where it applies

How do ultrasonic sensors differentiate between transmitted and received signals?

Lightning Web Component - do I need to track changes for every single input field in a form

How to check participants in at events?

Is exact Kanji stroke length important?

For airliners, what prevents wing strikes on landing in bad weather?

What if somebody invests in my application?

Simple recursive Sudoku solver

Can I create an upright 7-foot × 5-foot wall with the Minor Illusion spell?

Lifted its hind leg on or lifted its hind leg towards?

Why isn't KTEX's runway designation 10/28 instead of 9/27?

What do you call the infoboxes with text and sometimes images on the side of a page we find in textbooks?

Latex for-and in equation

how to insert data in previous register data in database queries?

How does database indexing work?How do I quickly rename a MySQL database (change schema name)?How to list the tables in a SQLite database file that was opened with ATTACH?How to output MySQL query results in CSV format?How do I connect to a MySQL Database in Python?How to 'insert if not exists' in MySQL?How to get size of mysql database?What are the options for storing hierarchical data in a relational database?How to get the sizes of the tables of a MySQL database?PHP no error detected but not showing properly

-1

I am developing an android application where I am registering an user by its username and after that again I want to register a candidate on same username. How to write php script(api) for this..Thanks in advanced

<?php
if($_SERVER['REQUEST_METHOD']=='POST')

 include 'config.php';

 $con = mysqli_connect($host,$user,$password,$db);

 $S_name = $_POST['StudentName'];
 $S_Phone = $_POST['StudentPhone'];
 $S_Class = $_POST['StudentClass'];

 $Sql_Query = "INSERT INTO registerDemo 
 (register_name,phone_number,class) 
 values ('$S_name','$S_Phone','$S_Class')";

 if(mysqli_query($con,$Sql_Query)) 
 echo 'Student Registered Successfully';
 else 
 echo 'Something went wrong';
 

mysqli_close($con);
?>

mysql database phpmyadmin

share|improve this question

edited Mar 7 at 11:40

F8xLag

85

asked Mar 7 at 10:22

Prashant DasPrashant Das

327

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Your script is wide open to SQL Injection Attack Even if you are escaping inputs, its not safe! Use prepared parameterized statements in either the MYSQLI_ or PDO API's
  
  – RiggsFolly
  Mar 7 at 10:28
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Sorry, I dont understand what you are asking here. Can you edit your question so it is more obvious what you are asking for help with please
  
  – RiggsFolly
  Mar 7 at 10:29
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Small Point You open the connection to the database INSIDE the IF but you close it OUTSIDE the IF? Move the close inside the IF
  
  – RiggsFolly
  Mar 7 at 10:30
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  How to write the php script so that I can insert (register_name,phone number and class) in registered username.
  
  – Prashant Das
  Mar 7 at 10:33
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Do you mean you have another table called registered that you want to place this data into? Or are you saying that the code you show us does not work
  
  – RiggsFolly
  Mar 7 at 10:34
  

  
  
  
  

 | 
show 4 more comments

-1

I am developing an android application where I am registering an user by its username and after that again I want to register a candidate on same username. How to write php script(api) for this..Thanks in advanced

<?php
if($_SERVER['REQUEST_METHOD']=='POST')

 include 'config.php';

 $con = mysqli_connect($host,$user,$password,$db);

 $S_name = $_POST['StudentName'];
 $S_Phone = $_POST['StudentPhone'];
 $S_Class = $_POST['StudentClass'];

 $Sql_Query = "INSERT INTO registerDemo 
 (register_name,phone_number,class) 
 values ('$S_name','$S_Phone','$S_Class')";

 if(mysqli_query($con,$Sql_Query)) 
 echo 'Student Registered Successfully';
 else 
 echo 'Something went wrong';
 

mysqli_close($con);
?>

mysql database phpmyadmin

share|improve this question

edited Mar 7 at 11:40

F8xLag

85

asked Mar 7 at 10:22

Prashant DasPrashant Das

327

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Your script is wide open to SQL Injection Attack Even if you are escaping inputs, its not safe! Use prepared parameterized statements in either the MYSQLI_ or PDO API's
  
  – RiggsFolly
  Mar 7 at 10:28
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Sorry, I dont understand what you are asking here. Can you edit your question so it is more obvious what you are asking for help with please
  
  – RiggsFolly
  Mar 7 at 10:29
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Small Point You open the connection to the database INSIDE the IF but you close it OUTSIDE the IF? Move the close inside the IF
  
  – RiggsFolly
  Mar 7 at 10:30
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  How to write the php script so that I can insert (register_name,phone number and class) in registered username.
  
  – Prashant Das
  Mar 7 at 10:33
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Do you mean you have another table called registered that you want to place this data into? Or are you saying that the code you show us does not work
  
  – RiggsFolly
  Mar 7 at 10:34
  

  
  
  
  

 | 
show 4 more comments

I am developing an android application where I am registering an user by its username and after that again I want to register a candidate on same username. How to write php script(api) for this..Thanks in advanced

<?php
if($_SERVER['REQUEST_METHOD']=='POST')

 include 'config.php';

 $con = mysqli_connect($host,$user,$password,$db);

 $S_name = $_POST['StudentName'];
 $S_Phone = $_POST['StudentPhone'];
 $S_Class = $_POST['StudentClass'];

 $Sql_Query = "INSERT INTO registerDemo 
 (register_name,phone_number,class) 
 values ('$S_name','$S_Phone','$S_Class')";

 if(mysqli_query($con,$Sql_Query)) 
 echo 'Student Registered Successfully';
 else 
 echo 'Something went wrong';
 

mysqli_close($con);
?>

mysql database phpmyadmin

share|improve this question

edited Mar 7 at 11:40

F8xLag

85

asked Mar 7 at 10:22

Prashant DasPrashant Das

327

<?php
if($_SERVER['REQUEST_METHOD']=='POST')

 include 'config.php';

 $con = mysqli_connect($host,$user,$password,$db);

 $S_name = $_POST['StudentName'];
 $S_Phone = $_POST['StudentPhone'];
 $S_Class = $_POST['StudentClass'];

 $Sql_Query = "INSERT INTO registerDemo 
 (register_name,phone_number,class) 
 values ('$S_name','$S_Phone','$S_Class')";

 if(mysqli_query($con,$Sql_Query)) 
 echo 'Student Registered Successfully';
 else 
 echo 'Something went wrong';
 

mysqli_close($con);
?>

share|improve this question

edited Mar 7 at 11:40

F8xLag

85

asked Mar 7 at 10:22

Prashant DasPrashant Das

327

share|improve this question

edited Mar 7 at 11:40

F8xLag

85

asked Mar 7 at 10:22

Prashant DasPrashant Das

327

edited Mar 7 at 11:40

F8xLag

85

edited Mar 7 at 11:40

F8xLag

85

asked Mar 7 at 10:22

Prashant DasPrashant Das

327

asked Mar 7 at 10:22

Prashant DasPrashant Das

327