import mysql.connector
# Establish connection
connection = mysql.connector.connect(host='localhost', database='your_database', user='your_username', password='your_password')
# Create cursor
cursor = connection.cursor()
# Execute SELECT statement
cursor.execute("SELECT * FROM your_table")
# Fetch results
rows = cursor.fetchall()
for row in rows:
print(row)
# Close cursor and connection
cursor.close()
connection.close()
import mysql.connector
# Establish connection
connection = mysql.connector.connect(host='localhost', database='your_database', user='your_username', password='your_password')
# Create cursor
cursor = connection.cursor()
# Execute INSERT statement
cursor.execute("INSERT INTO your_table (column1, column2) VALUES (%s, %s)", ("value1", "value2"))
# Commit transaction
connection.commit()
# Close cursor and connection
cursor.close()
connection.close()
import mysql.connector
# Establish connection
connection = mysql.connector.connect(host='localhost', database='your_database', user='your_username', password='your_password')
# Create cursor
cursor = connection.cursor()
# Execute UPDATE statement
cursor.execute("UPDATE your_table SET column1 = %s WHERE column2 = %s", ("new_value", "condition_value"))
# Commit transaction
connection.commit()
# Close cursor and connection
cursor.close()
connection.close()
import mysql.connector
# Establish connection
connection = mysql.connector.connect(host='localhost', database='your_database', user='your_username', password='your_password')
# Create cursor
cursor = connection.cursor()
# Execute DELETE statement
cursor.execute("DELETE FROM your_table WHERE column1 = %s", ("value_to_delete",))
# Commit transaction
connection.commit()
# Close cursor and connection
cursor.close()
connection.close()
#include<stdio.h>
#include<stdlib.h>
#include<string.h>
#include<sys/socket.h>
#include<sys/types.h>
#include<arpa/inet.h>
#include<netinet/in.h>
int main()
{
int s_sd,c_sd,cli_len,serv_len;
char sour[200],dest[200];
struct sockaddr_in serv,cli;
s_sd=socket(AF_INET,SOCK_STREAM,0);
serv.sin_family=AF_INET;
serv.sin_port=8005;
serv.sin_addr.s_addr=inet_addr("127.0.0.1");
serv_len=sizeof(serv);
bind(s_sd,(struct sockaddr*)&serv,serv_len);
if(listen(s_sd,5)<0)
printf("Can't listen");
if(s_sd<0)
error("Can't accept");
while(1)
{
printf("\nSERVER is waiting ...........\n");
cli_len=sizeof(cli);
c_sd=accept(s_sd,(struct sockaddr*)&cli,&cli_len);
for(;;)
{
read(c_sd,&sour,sizeof(sour));
printf("\nThe message from client is : %s\n",sour);
getchar();
printf("Enter the message for client :");
scanf("%[^\n]s",dest);
write(c_sd,&dest,sizeof(dest));
}
close(c_sd);
}
return 0;
//Client
#include<stdio.h>
#include<stdlib.h>
#include<string.h>
#include<unistd.h>
#include<sys/socket.h>
#include<sys/types.h>
#include<arpa/inet.h>
#include<netinet/in.h>
int main()
{
int sd,len,result;
char ch1[200],ch2[200];
struct sockaddr_in address;
sd=socket(AF_INET,SOCK_STREAM,0);
address.sin_family=AF_INET;
address.sin_port=8005;
address.sin_addr.s_addr=inet_addr("127.0.0.1");
len=sizeof(address);
result=connect(sd,(struct sockaddr*)&address,len);
if(result==-1)
{
printf("OOPS that is CONNECTION 1");
}
for(;;)
{
getchar();
printf("\n Enter the message to server :");
//gets(ch1);
scanf("%[^\n]s",ch1);
write(sd,&ch1,sizeof(ch1));
read(sd,&ch2,sizeof(ch2));
printf("\nThe message from server :");
puts(ch2);
printf("\n");
}
close(sd);
return 0;
//Server side program
#include <stdio.h>
#include <sys/types.h>
#include <sys/socket.h>
#include <netinet/in.h>
#include <arpa/inet.h>
#include <unistd.h>
int main()
{
int serv_sockfd, cli_sockfd;
int serv_len, cli_len;
struct sockaddr_in serv_address, cli_address;
char a[100], b[100];
serv_sockfd = socket(AF_INET,SOCK_STREAM,0)
serv_address.sin_family =AF_INET;
serv_address.sin_port =9001;
serv_address.sin_addr.s_addr = inet_addr("127.0.0.1");
serv_len= sizeof(serv_address);
bind(server_sockfd, (struct sockaddr*) &serv_address, serv_len);
listen(serv_sockfd, 5);
while(1)
{
printf("SERVER IS WAITING...");
cli_len=sizeof(cli_address);
cli_sockfd = accept(serv_sockfd, (struct sockaddr*)
&cli_address, &cli_len);
read(cli_sockfd, a, sizeof(a));
printf("reading message from client : ");
puts(a);
printf("Enter the message for client :");
scanf("%[^\n]s",b);
write(cli_sockfd, b,sizeof(b));
gets(b);
close(cli_sockfd);
}
}
//Client side program
#include <stdio.h>
#include <sys/types.h>
#include <sys/socket.h>
#include <netinet/in.h>
#include <arpa/inet.h>
#include <unistd.h>
int main()
{
int sockfd, len, result;
struct sockaddr_in address;
char name[100],ser[100];
sockfd = socket(AF_INET,SOCK_STREAM,0);
address.sin_family =AF_INET;
address.sin_port =9001;
address.sin_addr.s_addr = inet_addr("127.0.0.1");
len= sizeof(address);
result = connect(sockfd, (struct sockaddr *) &address, len);
if (result == -1)
{
perror(" Unable to connect ");
exit(1);
}
printf("Enter the message: ");
scanf("%[^\n]s",name);
write(sockfd, &name,sizeof(name));
read(sockfd, &ser,sizeof(ser));
printf("\n Reading from server: %c \n");
puts(ser);
close(sockfd);
return(0);
}
Comments
Post a Comment