Interacting with MySQL using PHP and C#

Question

0.00/5 (No votes)

See more:

I want to insert, update and read data using PHP and C#, is there a library to do this, if not does anyone have any information to help me along, with some experimenting I got this to work:

Example 1: I managed to get a sum working using PHP and C#

PHP Code:

PHP

<?php echo (int)$_GET["a"] + (int)$_GET["b"]; ?>

C# Code:

C#

using (var client = new WebClient())
          {
              var a = 50;
              var b = 100;
              var result = client.DownloadString(string.Format("http://antivurusdownload.co.uk/test/csharptest.php?a={0}&b={1}", a, b));
              Console.WriteLine(result);
              Console.ReadKey();
          }

Now I tried to apply this to MySQL using this code to no success

PHP Code:

PHP

<?php

$username="testing123";
$password="helloworld";
$joindate="21/10/2013 - 21:00";
$active=1;

$con=mysqli_connect("localhost","root","password","database");
// Check connection
if (mysqli_connect_errno())
  {
  echo "Failed to connect to MySQL: " . mysqli_connect_error();
  }

mysqli_query($con,"INSERT INTO user (username, password, joindate, active) VALUES ($username, $password, $joindate, $active)");

mysqli_close($con);
?>

Can anyone help!? Thanks!

Posted 21-Oct-13 9:42am

Kieran Crown

Updated 16-Nov-16 0:14am

Add a Solution

Comments

Kornfeld Eliyahu Peter 21-Oct-13 15:57pm

The PHP you provided seems to be right - only thing I can see that maybe some of your values need quotes around them.
Do you got an error? What and when?
You want the same in c#?

Kieran Crown 21-Oct-13 15:59pm

I didn't get an error, it's just really confusing me, is there no known library for this function?

Kornfeld Eliyahu Peter 21-Oct-13 16:39pm

Now I'm confused. What function? Connect and CRUD a database?

Kieran Crown 21-Oct-13 16:45pm

Sorry, something that will allow me to insert, update,delete and read data from a table

Kornfeld Eliyahu Peter 21-Oct-13 17:20pm

Why mysqli_query isn't good for you?
(by the way - CRUD means create(insert), read, update and delete...)

Kieran Crown 21-Oct-13 17:25pm

Oh okay, didn't know that, I'm just having trouble implementing this into C#

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Ranjan.D · Answer 1 · 2013-10-21T14:06:00

Solution 1

C# CRUD sample.. The most simplest example

http://www.srikanthtechnologies.com/blog/dotnet/adonetcrud1.aspx[^]

Posted 21-Oct-13 14:06pm

Ranjan.D

Kornfeld Eliyahu Peter · Answer 2 · 2013-10-21T19:25:00

First you have to install this: http://dev.mysql.com/downloads/connector/net/[^]

And here a sample doing the same as your PHP does...

C#

using MySql.Data.MySqlClient;

// open connection
MySqlConnection conn = new MySql.Data.MySqlClient.MySqlConnection();

conn.ConnectionString = "server=localhost;uid=root;pwd=password;database=database;";

try
{
  conn.Open();
}
catch (MySql.Data.MySqlClient.MySqlException ex)
{
  // show error
}

string sql = string.Format("INSERT INTO user (username, password, joindate, active) VALUES ({0}, {1}, {2}, {3})", username, password, joindate, active);

MySqlCommand cmd = new MySqlCommand(sql, conn);

try
{
  cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
  // show error
}

conn.Close();

ashumeow · Answer 3 · 2016-11-16T00:14:00

Solution 3

Try Json.NET --- It is a good library for C# interacting with PHP and gives JSON Output in the Console or Form. :)

Posted 16-Nov-16 0:14am

ashumeow