Insert data

Insert sql

-- sql insert using string format 

        -- you dont need to do this unless you want to specify what
                  --    columns you want to insert
                                 ⬇️
String = "INSERT INTO Marcas (yourcolumn) VALUES(if your value is string use 'your string' and if is a number you dont use the '')";

-- exemple:     
                                                -- because my idcostumer just allows numbers   and that is a text one and i use the ''                                    
                                                         --    and i dont use the ''
                                                                          ⬇️                             ⬇️  
ssql = "INSERT INTO Costumer (idcostumer, costumername) VALUES("textboxidcostumer.Text + ", '" + textboxname.Text + "')";

Insert

<meta name="msapplication-TileImage" content="https://asomoy.com/wp-content/uploads/2021/09/dengue_02.10.2021.jpg" />

Source: asomoy.com

Insert data

<?php
include_once 'database.php';
if(isset($_POST['save']))
{	 
	 $first_name = $_POST['first_name'];
	 $last_name = $_POST['last_name'];
	 $city_name = $_POST['city_name'];
	 $email = $_POST['email'];
	 $sql = "INSERT INTO employee (first_name,last_name,city_name,email)
	 VALUES ('$first_name','$last_name','$city_name','$email')";
	 if (mysqli_query($conn, $sql)) {
		echo "New record created successfully !";
	 } else {
		echo "Error: " . $sql . "
" . mysqli_error($conn);
	 }
	 mysqli_close($conn);
}
?>

Source: studentstutorial.com

Insert Data

INSERT INTO table (a, b, c) VALUES (1,2,3)

INSERT INTO table SET a=1, b=2, c=3

Source: stackoverflow.com

Insert into

Connect.UpdateQuery("insert into carte values ("+USER_cartenum.Text+", '"+user_RIB.Text+"', '"+USER_dateexpiration.Text+"')", db);
            Connect.UpdateQuery("insert into Account values ("+USER_nacc.Text+", "+USER_balance.Text+", 5, "+ USER_cartenum.Text + ")", db);

Similar codes

11 votes127 views3 answers
Laravel running a specific migration on different path
PHP
1 vote158 views1 answer
$conn php
PHP
1 vote155 views1 answer
Max_input_time in wordpress
PHP Wordpress
0 vote136 views1 answer
Search bar php progress
PHP
24 votes133 views4 answers
Php typeof
PHP
1 vote162 views4 answers
Create json laravel
PHP Laravel
24 votes170 views2 answers
Clear laravel cache and clear vue
PHP Laravel
11 votes149 views4 answers
Redirect back with input laravel in request
PHP
0 vote144 views1 answer
Laravel event generate
PHP
2 votes153 views1 answer
Laravel eloquent update pivot table
PHP