mysql

[Solved] How To Register user Form with all dynamic fields name in php

by

// Logic One Using For Loop <?php error_reporting(0); $con=mysql_connect(‘localhost’,’root’,”) or die(‘Not Connect’); mysql_select_db(‘multiple’,$con); if (isset($_POST[“submit”])){ $field_name = $_POST[‘values’]; $values = “”; for ($i = 0; $i < sizeof($field_name); $i++) { $values .= “(‘”.$field_name[$i].”‘)”; if ($i != sizeof($field_name) – 1) { $values .= “, “; } } $sql = mysql_query(“INSERT INTO php_test VALUES (” . $values.”)”); … Read more

[Solved] How to put search box in the database table using PHP and Mysql

by

There are a few things you will need to know to be able to do this. Firstly the security bit… Basically you want to never trust data that is submitted to your application. When accepting data for use in a MySQL statement, you could use PHP’s built in escape functions for MySQL. ref: http://php.net/manual/en/mysqli.real-escape-string.php You … Read more

[Solved] Print name of all activities with neither maximum nor minimum number of participants

by

You can use window functions if your mysql version is 8 or above select activity from (select activity, count(*) as cnt, max(count(*)) over () as maximum_cnt, min(count(*)) over () as minimum_cnt from friends group by activity) mytable where cnt not in (maximum_cnt, minimum_cnt); 4 solved Print name of all activities with neither maximum nor minimum … Read more

[Solved] how to connect to a mysql database [closed]

by

<?php $servername = “localhost”; $username = “Mark”; $password = “secret”; // Create connection $conn = new mysqli($servername, $username, $password); // Check connection if ($conn->connect_error) { die(“Connection failed: ” . $conn->connect_error); } echo “Connected successfully”; ?> 0 solved how to connect to a mysql database [closed]

[Solved] Can anyone please correct this SQL syntax exception

by

index is a keyword, if you use this as a column name try escaping it with tilts. (`) …. PreparedStatement ps=(PreparedStatement) dbConnection.prepareStatement(” select `index` from books where `index`=? “); …. solved Can anyone please correct this SQL syntax exception

[Solved] Display database structure from Delphi (rad studio)

by

As already explained to you in comments, your while loop should look something like this: while **not** FData.FDQuery1.Eof do **begin** ShowMessage(FData.FDQuery1.Fields[0].ToString); **FData.FDQuery1.Next;** end; (minus the asterisks, of course). However, that would not overcome the problem that your SQL is incorrect. So, try this instead: In a new Delphi project, place a TFDConnection, TFDQuery, TDataSource, TDataSource … Read more

[Solved] WCF, MySQL and Transaction

by

This can’t be the code that’s causing an issue. The error you are getting is coming from an attempt to return or pass in a MySqlTransaction to/from the service. That’s just simply not going to work. Also, why on earth are you exposing a Command object to the outside world via a public property? Furthermore, … Read more

[Solved] Migrating from MariaDB to MySQL – differences

by

Read this link https://mariadb.com/kb/en/library/mariadb-vs-mysql-compatibility/ which discusses in detail the compatibility issues between various versions of MariaDB and MySQL: And there was a toolkit called ESF Database Migration Toolkit Choose a Data Source Choose a Destination ESF Database Migration Toolkit ( http://www.easyfrom.net/ ): This toolkit dramatically cuts the effort, cost, and risk of migrating to/from any … Read more

[Solved] Show a short version [closed]

by

May be you have to use substr() function. echo substr($string,$start_pos,$end_pos); The above one will display the strings content from the starting position to the end position as specified as the arguments. Example $str=”Example string”; if(strlen($str) > 5) echo substr($str,0,5).’….’;//To show there is more content else echo $str; Ouptput Examp…. 4 solved Show a short version … Read more

[Solved] PHP MYSQL INSERT help no errors [closed]

by

The following worked for me: I have to point out that you can’t use $postedOn = now(); as a variable to post the current time/date. It needs to be entered as part of the VALUES I.e.: VALUES(:videoId,:username,NOW())”; Do note that I used $pdo as the connection variable. <?php $mysql_hostname=”xxx”; $mysql_username=”xxx”; $mysql_password = ‘xxx’; $mysql_dbname=”xxx”; try … Read more