[mysql] Forum Topics

Hello, What's mysql syntax to delete all tables from database1 ?

I few weeks ago, I posted some code that I need help converting to MySQLi, now I need some help converting it to PDO. The code allows you to enter queries and commands and brings back the column headings and the information that I am looking for into a table. …

So I'm getting this error message from MYSQL when I load this page. The first message is what's it displaying on the PHP code, the 2nd message is the result of mysql_error(). [ICODE](1) Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in [I][redacted][/I] on line 19 (2) You …

Hello I need to filter data from database. Use selects the data he need from selectboxes and inputs. Not all inputs must be filled. Those that arent have value of -1. I have put together a SQL statement that should work. Probably would work without the prepare but I need …

this code runs at my other sample prog. but when I try to use it to my actual prog., it wont work. (variables changed, connection's ok) . . . cant show data at listview [CODE] Imports MySql.Data.MySqlClient Public Class Form1 Public sconnection As New MySqlConnection Private Sub Form1_Load() If sconnection.State …

Please help me to correct this, because its relpy: Access denied for user 'flasycom@localho'@'localhost' (using password: YES) and this is my database setup <?php //################################################################# //Only edit the following 4 varibles $SQLhost = /* SQL Host */ 'localhost'; $SQLuser = /* SQL Username */ 'flasycom_admin'; $SQLpass = /* SQL Password …

i have a login box, but when i click login, it will now display (SELECT*FROM members WHERE email='wareez' AND password ='lord' The login box is not working. also the registration form too will submit the form to the database but it did not load the user homepage after the successfull …

<?php session_start(); include_once("db_connect.php"); if(isset($_POST['update'])) { $ret_id=$_POST['ret_id']; $ret_name=$_POST['ret_name']; $ret_street=$_POST['ret_street']; $ret_city=$_POST['ret_city']; $ret_phone=$_POST['ret_phone']; $ret_fax=$_POST['ret_fax']; $ret_user_fname=$_POST['ret_user_fname']; $ret_user_lname=$_POST['ret_user_lname']; $ret_email=$_POST['ret_email']; // checking empty field if(empty($ret_name) || empty($ret_street) || empty($ret_city) || empty($ret_phone) || empty($ret_fax) || empty($ret_user_fname) || empty($ret_user_lname) || empty ($ret_email)) { if(empty($ret_name)) { echo "<font color='red'>Retailer Name field is empty.</font><br/>"; } if(empty($ret_street)) { echo "<font color='red'> …

I am trying to learn MySQL to, '1 call all records from base '2 count number of records and store number as maxID, '3 display 1st record set by the ID number, '4 -A - add one to ID number- display record set in frame1 :(working_on_page_refresh -B - mins one …

Hello , in a python application i wanted to insert datas to some columns of a table , the columns tha have as name "XS" , "S" , and "M" . i tried this query : `curso1.execute('INSERT INTO donnees (%s) VALUES (%s);',(liste1[i],qtetaillevar[i]))` , but when it compiles it , when …

I want to backup my database from vb.net 2010 and i am able to do this using mysqldump through vb.net 2010, but i want to backup my mysql database without useing mysqldump only by vb.net code. please help me ???

hi i am new to php and mysql, i am experimenting with a script for saving data to mysql database. and fetch the data on other page, i managed to get both of them without any trouble. But Here is the one problem. I added a additional input function to …

hello i try this form and script _____________________________________________________ <form action="insert.php" method="REQUEST">backend - insert new record<br> id: <input type="number" name="id"><br> manufacturer: <input type="text" name="manufacturer"><br> transferrate: <input type="text" name="transferrate"><br> cache: <input type="text" name="cache"><br> size: <input type="text" name="size"><br> RPM: <input type="text" name="RPM"><br> use: <input type="text" name="use"><br> price: <input type="text" name="price"><br> seller: <input type="text" …

hello i try this form and script _____________________________________________________ <form action="insert.php" method="REQUEST">backend - insert new record<br> id: <input type="number" name="id"><br> manufacturer: <input type="text" name="manufacturer"><br> transferrate: <input type="text" name="transferrate"><br> cache: <input type="text" name="cache"><br> size: <input type="text" name="size"><br> RPM: <input type="text" name="RPM"><br> use: <input type="text" name="use"><br> price: <input type="text" name="price"><br> seller: <input type="text" …

Hi! I need help with bulk export of files from database to folder. I have upgraded a system that i made and now instead of storing files to database i store it in folder and save path to database. Now i have a problem because there are around 1500 parts …

<?php $mysqli = mysqli_init(); $mysqli->real_connect("mysq.x.com","me","wordup","inthekitchin"); if ($mysqli->connect_errno) { echo "Failed to connect to MySQL: (" . $mysqli->connect_errno . ") " . $mysqli->connect_error; } $res = $mysqli->query("UPDATE plate1 SET potatoes =('$_POST[potatoes]') WHERE id =('$_POST[id]')"); $row = $res->fetch_assoc(); ?> returnes error `Fatal error: Call to a member function fetch_assoc() on a non-object …

i have created a database with username,age,contact,email.now i want a column in which we can show whether the user is active or not.what sholud we do?if we create a column named as status,what sholud be type of column?boolean or binary or something else...??? i am using php to edit delete …

`$data= "echo * from table1 where id=$_post[ID] "` can anyone see why this line duz not compute please ?

I am not able to insert data from CSV file with "¤" Character. Please help me to solve the problem. Thanks a lot in advanced. CSV File: FirstName¤LastName¤City¤Year |$| Bill¤Gates¤NW¤2013¤|$| David¤Beckham¤London¤2010¤|$| PHP Code: $csv_file = "Contacts.csv"; $csvfile = fopen($csv_file, 'r'); $theData = fgets($csvfile); $i = 1; do { $insert_csv = …

I have 3 tables as mentioned below: Users Code Name NW London 1 Bill ---- ---- Contacts Code Country 1 USA Location Country City USA NW I need to update Users.NW = 1 in the Users Table. There are other cities like NW, London, Paris etc. In respective cities i …

i creating a shopping website online for a store. and i wanted to add polls to get user input, than store in database. i wasnt sure how to set up tables. we going to have alost of questions. each question will have 3 to 4 answers. user can click on …

Please, anyone here to help me correct this code, it was telling me that could not connect to database. My site is flashysky.com database name : is flashysky please help me to correct it and send it to my email jimohwareez@gmail.com I will really appreciate if you can help me …

I installed a new script onto a Linux server using cpanel. > ERROR: Nothing parsed, nothing printed > Invalid query > SELECT * FROM `dating_country` WHERE `id` IN () > MySQL error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version …

What is the error in the folloing code? I am not able to add data to the table cmd.CommandText = "insert into master (FirstName, middlename, lastname, [addressline 1], [addressline 2], city, pincode, state, country, Nationality, sex, DOB) values ('" + textBox1.Text + "', '" + textBox2.Text + "', '" + …

I want to compare a date in a database to today's date and it they are equal. Display the contents of the related date in the database in datagridview on a new form. This is my code Private Sub TimerAppoint_Tick(sender As Object, e As EventArgs) Handles TimerAppoint.Tick Dim TheDate As …

I am trying to update the shirtnumbers in table crew, by the ID from the .php page before. <?php include('conect.php'); $page = (isset($_GET['page'])) ? $_GET['page'] : 1; $startPoint = $page - 1; $data = "UPDATE crew SET shirtnumber=$POST['shirtnumber'] WHERE ID=<?php $_GET['ID']?>"; $query = mysql_query($data); $data2 = mysql_fetch_array($query); $rowCount = 0; …

Dear Respected Members/Users, I Cannot add/insert mysql last insert id in the third table. Kindly please help me out in adding the para_id into the last insert query. I have demonstrated in the Image file which will help alot in getting my point. Waiting for response. thanks. 

why does this thing keeps on showing? what should i do? 

I have table with 3 columns. 1. room_id 2. date 3. price 4. availability I needed a list of rooms with the total price within selected dates. I could do that as follows: SELECT SUM (price) from table WHERE date BETWEEN ( 01.08 13 AND 05.08.13 ) Now i need …

hello guys i have created the below codes. the first one is the mysql select statement which works fine when i echo. the second one is an html/css table i created. i am stuck to the point where i can merge both of them so that i get a nice …

Hi All, I want to select rows from dynamic created tables i.e we have tables like web_analytics_mm_yy(ex: web_analytics_06_13, web_analytics_05_13, web_analytics_04_13 and so on) web_analytics -> table name mm_yy -> month_year. I know this can be acheived in PHP by using for loop { // CONSTRUCTING SQL STATEMENT USING // UNION …

firstly I apologise in advance if this has been asked 100 times over.. I've been ambushed by my company i "HAVE" to use an old Mysql 4.1 server something to do with an atiquated system still running that cannot be upgraded for x,y and z reasons. but they want a …

Hello I have a mysql table with 2 columns, Id and date. How can I insert one more Column "dayname" that will be filled through sql query with day names related to The value in the column "date". Thanks

I have a problem that I've racked my brain with for two weeks without success. I have a table named 'user_answers' containing columns 'user_answer_id' and 'user_name'. Each 'user_name' has 25 rows. I'm trying to compare/count the number of rows where user A and user B match answer_id. SELECT COUNT (*) …

Hello, I was wondering how i would create the Units table for this. Would i just set both Unit_ID and Customer_ID in the Units table as foreign keys or do i need to have a primary key like Customer_Unit_ID then have the two foreign keys? Customers Customer_ID Customer_Full_Name Contact_Name Address_1 …

There has got to be a better way of doing this. First of all pay no attention to the lack of validation and error checking. I just want the core of the script to work first. Also, Block 1 and Block 2 execute, Block 3 does not. Whats the best …

hi, i want to store date time whan i click radio button(name login time)in mysql. if i click logout radio button it should store logout time. ples help me... php and mysql code ...

Hey guys, here is the table structure: Table name: globalsettings column names: setting, value, description An example query could be this: $query = "SELECT * FROM globalsettings WHERE setting = 'name'"; Okay, so here is what I am trying to do (I am using PDO for DB activity, but just …

Hello Community, I was wondering if there is a way to limit users on how many database entries they can insert then once they have reached 100 (Max entried) entries it will delete old entries. So if the user has reached 100 entried and they try to insert another entry …

Hi All, I am a beginner in php and working on admin side of a small website. I have attached a PHP CKEDITOR to the admin page so that the admin may edit the pages text. Here, i am a bit confused about one thing and that is about how …

hi everyone im having issues with some results i need, basically i have a view page that needs to output results based on earnings per month. all results are collected and outputted in rows, is there anyway in php i can group all the results by the earning month instead …

[B]insert.php[/B] [CODE]<?php $dbun = "$_POST[dbun]"; $con = mysql_connect("localhost","root",""); if (!$con) { die('Could not connect: ' . mysql_error()); } mysql_select_db("my_db", $con); $sql="INSERT INTO $dbun (sn, date, particular, dr, cr) VALUES ('$_POST[sn]','$_POST[date]','$_POST[ptr]','$_POST[dr]','$_POST[cr]')"; if (!mysql_query($sql,$con)) { die('Error: ' . mysql_error()); } echo "1 record added"; mysql_close($con) ?> [/CODE] [B]DB name = my_db[/B] [B]user.php[/B] …

I need to store the values of a textarea tag using a form to submit the value and finally store to a mysql database table. Here is what I have, I am sure its something dumb, but its been a while since I have used php. [CODE] <?php if(isset($_POST['submit'])){ $con …

hi, i am new to mysql and also to php, i am trying to add a feature to a webpage, for showing some latest records from a mysql databse. i managed to show records from mysql database, but the problem is i only trying to show the first four records …

Hi, I am trying to learn how to use a data base to store photos and such, I can now get info into the base and can get all the records to display , this is not what I had planed, So that lead me on a surch for answers …

Currently I am designing a inventory system, however jumping straight into vb.net was easier said than done. At the moment, all the information stored goes to two places, one being a master file that has all the information ever inputted, and the other being an individual file that is created …

Hi all, I've been playing around with this for 30 odd minutes now and basically been making a right fool of myself... I want to make a function called `userInfo()` that uses the users email address, stored in `$_SESSION['auth'];`, to get any information required from sql. I'm using **MySQLi** and …

Hi there, This question relates to data structures, performance and approach to a problem. It is best explained with example so bear with me. For the record, I will be using a combination of PHP, MySQL and Apache server on a dedicated Linux server. The problem is how we would …

Hi folks. I'm developing a MySQL database driven, PHP web application that will be used by the general public and I'm starting to get a bit paranoid about database security. While creating the site I was using a single, full privileges database user to connect on each page that required …

Hi all, I wonder if you wonderful people can point me in the right direction?? I'm quite new to web programming, I'm OK at conventional C/C++ etc but just really getting into the whole webside thang. Anyway, I was wondering how I may solve the following. I want to have …