[mysql] Forum Topics

I want to be able to insert the data from a range function into mysql table the range values comes from 2 textfields that are user inputted, for example the user inputs 1 and 50 the range function generates numbers from 1 to 50 in an array, my problem is …

Hi I"m sorry that there is no code, it's just a question in my mind .. How can I sort the request results as rows.In every row 4 results then the next row 4 results and so on.?

While extending a mysqli class, I ran into an issue with binding parameters. I've read that db names and table names should not be used as parameters, but while I was pondering this statement... SELECT SCHEMA_NAME FROM INFORMATION_SCHEMA.SCHEMATA WHERE SCHEMA_NAME = '$dbname' I thought, as the db name is a …

I have an update form where there is a student record that has a picture as well as other info. It is with the picture that I am having a problem. The form has a file field with id="picture" name="picture" and then a simple dynamic record call to display the …

Hello! I'm needing some help integrating HighCharts into my CodeIgniter application and getting data from my MySQL database! I've followed a YouTube video on actually integrating HighCharts and it was extremely straightforward. However, that method included a hardcoded array and I'm needing to generate an array from data stored in …

While learning php I found this common statement $add_tel_sql = "INSERT INTO telephone (master_id, date_added, date_modified, tel_number, type) VALUES ('".$master_id."', now(), now(), '".$safe_tel_number."', '".$_POST['tel_type']."')"; What I do not understand why in the '".$master_id."' we are using the " and also the dot. why we do not only use $master_id without …

I'm retriving a youtube link from mysql db with this code <?php //echo $embed; $yt_url=$embed; function get_youtube_id_from_url($url) { if (stristr($url,'youtu.be/')) { preg_match('/(https|http):\/\/(.*?)\/([a-zA-Z0-9_]{11})/i', $url, $final_ID);return $final_ID[3]; } else { preg_match('/(https|http):\/\/(.*?)\/(embed\/|watch\?v=|(.*?)&v=|v\/|e\/|.+\/|watch.*v=|)([a-zA-Z0-9_]{11})/i', $url, $IDD); return $IDD[5]; } } $variable= get_youtube_id_from_url($yt_url); ?> and extracting the id part of the link and placing it in …

..im new in PHP and and I want to know how to create html form that sends file(images) to phpmyadmin(database) consider that you have to choose the database first from the dropdown list of database.. then display it's table after choosen it.. please help.. here must be the sql flow.. …

i am trying to generate pdf file using fpdf selecting data from two different tables i.e. table custreg and table slabpay, but getting MySQL error: "Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in D:\inetpub\vhosts\kisan.net\httpdocs\greengold\exportpdf.php on line 124". Code: $strSQL = "SELECT custreg.mobno1, slabpay.ac_no, slabpay.cust_name, slabpay.install_no, GROUP_CONCAT(`slabpay.install_amt` …

HI Hope somebody can help. My query updates a colomn in tab1 from a row in tab2 but only if a colomn in tab1 is equal to that of a row in tab2. tab 1 has 360000 rows tab 2 has 477 rows The update query runs for ages and …

i have store an image into my database. but i am unable to display the image what i have done till now is under.... any help will be appreciated. thanks in advance! <? $query="SELECT * from testimonial"; $ret = mysqli_query($mysql,$query); if (isset($ret) && $ret->num_rows>0) { while($row=mysqli_fetch_array($ret)) { $body=$row['body']; $name=$row['name']; $image=$row['img']; …

Hi,i have some error for some help when i try to run this code below i got this error "Syntax error in UPDATE statement." at .ExecuteNonQuery() and i try to solve it for an hours but i can't , Anyone please help me !! and i use System.Data.Oledb ( sorry …

Hi I have an 'edit_profile' form. I'm having several issues with this form . There are some fields which are working fine and some aren't. This 1st issue is regarding the textarea fields When the user updates their profile, any field, the textarea adds characters which are bye<br /><br /><br …

[CODE]Hi Friends, I have written a code with some example script for generating report in PDF with PHP and MYSQL. But i am unable to fetch the data from my table. So Please help me to solve this issue. Thanks <?php $today=date('Y-m-d'); $hostname = "localhost"; $database = "bdname"; $username = …

i have managed to code this CSV file and it is working well..the only problem i am getting is the variable error on the form..i get this error ...Notice: Undefined variable: data in C:\xampp\htdocs\helper.php(527) : runtime-created function on line 22 how do i resolve the error? this this my sample …

Hi all, I have an array: [CODE]<?php $product_id = $_GET[id]; //the product id from the URL $action = $_GET[action]; //the action from the URL //if there is an product_id and that product_id doesn't exist display an error message if($product_id && !productExists($product_id)) { die("Error. Product Doesn't Exist"); } switch($action) { //decide …

Hi! Anyone can help me about my problem on HOW TO UPDATE TABLE USING THE CONTENTS FROM ANOTHER TABLE? Thank you in advance for those who can help me. Anyway, I'm using VB.Net 2010 I hope you guys can help

Hi Everyone, I am new to PDO PHP - I am getting to grips with the insert statements with bind_param. What I am a bit confused about is how to update a table where id = $var I have an image upload script that works fine, as it uploads the …

hellow every body i need sql comand works in vb6 with windows7 thank you

Hi guys I'm rich and I'm new to this forum and I hope I can help you guys as well as helping me! I have been to staffs uni and got a 2:2 in applied it so I know almost all the in's and out's about IT and PHP, I …

Hi, I have 5 tables..a.b,c,d,e While doing equi join : 1)a.id=b.id, b.id=c.id, c.id=d.id, d.id=e.id a.id=c.id, a.id=d.id b.id=d.id How internally equi join works.should i need all PK to Join Could you suggest me some tutorial which shows how internally works.

here is a code that would delete a page access from each user level but i have an error which is Notice: Undefined index: checkbox here is the code <?php $userId = $_GET['id']; $sql = mysql_query("select * from cms_userlevels where user_level='$userId'"); $row2 = mysql_fetch_array($sql); echo " <center> <table class='left'> <form …

Hello Community, I have recently been having a big of a look into connecting to a database using PDO but I'm not too sure what I should stick with, the normal way to connect to a MySql database or should I start using PDO. What would be better to use? …

How to follow and unfollow users? With following code, list of users appears. containing link to action.php If not following anyone goto action.php to follow that user from list or if following then show link for unfollow How to check from table **following** **condition check:** if ($following) { <a href='action.php?id=$uid&do=unfollow'>unfollow</a>"; …

Hello, I need some help here. I cannot make the right query. In my code, I want to insert a data into my database. But the id_number will have different values. Id_number have different values because its from a group. So with that group of id_number I want to insert …

hi there, looking to get some help. i have created a view which pulls together from different product tables a review date. the thing is that a client could have review dates for the same product and i need it to only display the most recent review date. i tried …

I want to search all record from database on multiple(comma separate) keyword like php,mysql or php with like . mydatabase record id skill 1 php,java 2 php 3 mysql 4 java,mysql,php if i search mysqlthen total record should be 2 and search php,java it should be total record should be …

If I had this: <html> <body> <form action="welcome.php" method="post"> Name: <input type="text" name="name"><br> E-mail: <input type="text" name="email"><br> <input type="submit"> </form> </body> </html> HOW DO I TAKE WHAT SOME TYPE INTO MYSQL. Do I create a table first ect. Examples pleases

I have a question that may be a bit complicated, so let me set it up with what I am working with first. I am dealing with a 3 x 10 matrix, which I’m sure you realize means on level 1 there are 3 potential positions, and on level 2 …

I am using mysql_fetch_assoc to retrieve and display an array; This is what I recieve upon loading the page: *Warning: mysql_fetch_assoc() expects parameter 1 to be resource* I have researched it and do not understand it. **Snippet* while ($row = mysql_fetch_assoc('$result')) { echo $row["emp_name"]; echo $row["emp address"]; } Thank you, …

please help me to display the multiple image from mysql this id my file for uploading multiple image $valid_formats = array("jpg", "jpeg", "png", "gif", "zip", "bmp", "pdf", "doc", "docx"); $max_file_size = 100000*100; //100 kb $path = "uploads/"; // Upload directory $count = 0; extract($_REQUEST); // Loop $_FILES to execute all …

Hallo, I am trying to fix my mysql search query: $data = mysql_query("SELECT * FROM static_content WHERE upper(image) or upper(title) or upper(content) LIKE'%$find%'"); Please help me to fix it. Is it correct? I mean where column image (change to upper case) or column title (change to upper case) or column …

Hi, below queries gives two rows like category_name high_value_complaints category_name high_value_duplicate_complaints I am trying to merge both queries category_name high_value_complaints high_value_duplicate_complaints I tried to join both tables but its giving category_name high_value_complaints category_name high_value_duplicate_complaints Need suggestions select category_name, count(distinct complaint3.id ) as high_value_complaints from complaint_category,assignment3,user3,complaint3_details, complaint3,complaint_tag ct where complaint3.complaint_category_id=complaint_category.id and …

Hi All, I'm battling to get this query to work. I have a select form that allows user to select dates. When he submits it it needs to remove weekends from the request. $DateStart='2013-09-01'; $DateStart='2013-09-05'; $DateSTR=strtotime($DateStart); $DateSTO=strtotime($DateStop); for($i=$DateSTR; $i<=$DateSTO; $i++){ $NewDate=strtotime($i); $DateCalc=date('D', $NewDate); $TotalCount++; if($DateCalc == 'Sat' || $DateCalc == …

*Yes, the reoccurring issue* I have yet to solve: Posting the contents (Saved to a DB) of a form to a redirected page. Everything works except the rendering of the form data on the redirected page. I've been trying everything that I can think of. I've been researching this for …

Hi, I have mysql database dump xxx.sql How can i convert xxx.sql to xxx.csv? Thanks

I am an Finance and Accounting professional and am interested in Application design and development. I have been trained in-house by my organisation in Core Java, PHP and MySQL. My experience includes the design and development of a PHP web application whch takes care of main activity of my organisation. …

I am using MYSQL MYISAM and php version 5.4.16,MYISAM and am doing a fulltext search based on the (product_name) column and i want to randomize the result but the problem is rand()not giving the random values. I tried something like this: SELECT `product_name`,`main_cat_id`,`sub_cat_id`,`prod_cat_id`,`prod_short_desc`,`com_id`,`product_id`,`product_ratings`, `min_order_quantity`, `fob`,`country_id`,`company_name`,`attributes`,`attr_values`,`verify`,`image`,`product_additionals` , MATCH (`product_name`)AGAINST ('"girls top"'IN …

Hi. I have a mysql field with a record like: [2,5,11]. I have a query like: $query = $this->select() ->from($this->_name) ->where('id = ?', $id); This query work if record is of integer type: 5. Is it possible to create a query to find 5 in the array? Please advise. Thanks.

hi..please help.. i have 2 tables tblStudents and tblGrades. in tblStudents, all details of students and in tblGrades, grades of the students. column "StudId" is their only common column.. in tblStudents: StudId LastName FirstName in tblGrades: columns are: StudId SubjectCode Grade what i want to achieve is to query on …

I am converting a PHP application from MySQL to PostgresSQL. The MySQL works flawlessly. The database for this application is a one to many relationship. I have a while loop nested inside another while loop <?php while ($movie_row = pg_fetch_array($movie, PGSQL_ASSOC)) { ?> [html code to echo various elements of …

Hi Can I use the ajax to update a form feild by get a value of another feild on the same page(without submiting the page). This process involves the mysql as well.

Hi I'm creating a website that uses a count query, to see how many things in the database match a variable. Table eg: Whats Liked User Liked By potatoes djiajgi computer djiajgi ......... Now, I'm trying to see people who like the same thing as you do, and am ordering …

I got a product table like this id | name | category 1 | name1 | 2,1,5,8,9 2 | name2 | 2,1 3 | name3 | 5,8 And I got a category table like this id | catname 1 | cat_name1 2 | cat_name2 5 | cat_name3 8 | cat_name3 …

how to disply mysql table data on same form and also edit update and delete these data on that form in wordpress

hi.please help me with mysql query. i have a table tblGrades with fields ID, Subject, Remarks. how can i create a stored procedure that will display the students that have subjects(user input) and Remarks='Passed'? the Subjects will depend on the user, therefore it may be one or two or three …

Hi, I'm creating a website where users can liket things and by liking things you'll see people who have liked the same thing on your home page. Now, currently my code shows people who like ONE same thing as you, but how would I make it so that if anyone …

Ok,I havent a clue how to do this. I have a mysql table for products, each has id as the primary key. I have an admin page where I upload products to this table or delet/hide them too. But I want a way where when I'm uploading the products to …

I would love to know whether this code is the correct manner to send mysql data to a remote database. $host = 'www.domain.tld'; $user = 'remote_user'; $pass = 'remote_password'; $time_end = microtime(true); //grant per;misions to connect to remote host if (!function_exists("ssh2_connect")) die("function ssh2_connect doesn't exist"); // log in at server1.example.com …