i am not able to solve this error help me out

Member Avatar
Member Avatar
+0 forum 2

I am making a small example of adding, editing, deleting and saving the treeView directory tree into the SQL Server database, what must I design to store in the database and write code ?

Member Avatar
+0 forum 0

I am a beginner to php and am designing student information system where students need to enter 9 subject and its corresponding grade based on the number of sittings. Is there any better way to do this apart from what I have been doing? These are my codes: <form name="register" method="POST" action="process2.php" > <div class="col-md-12"> <div class="form-group"> <label>Select Number of Sitting(s)</label> <select name="sitting" id="sitting" class="form-control" onchange="showDiv(this)"> <option value="1">1</option> <option value="2">2</option> </select> </div> </div> <div class="output1" id="div1" name="onesitting"> <div class="col-md-6"> <div class="form-group"> <label>School Name</label> <input type="text" name="schoolname1" id="schoolname" class="form-control" placeholder="School Name" required> </div> </div> <div class="col-md-6"> <div class="form-group"> <label>Exam Type</label> <select …

Member Avatar
Member Avatar
+0 forum 2

i have manage to insert my checkbox array data into database. the problem is when i check multiple checkbox only the first data in array is inserted in database. i need when i check multiple checkbox, all the data i have check insert into database.can someone help me? this is my php code: <?php include ('connect.php'); $cat = implode(',', $_POST['check']); if(isset($_POST['submit'])) { for($i=0; $i<count($cat);$i++) { $p_id =$_GET ['sitter']; $price = $_POST ['price']; $pickup_date =$_POST ['pickup_date']; $dropoff_date =$_POST ['dropoff_date']; $numdays = $_POST ['numdays']; $total =$_POST ['test']; $sql2 = "INSERT INTO cat_sitter(sitter_fk,cat_fk, price, date_in, date_out,total_day, total)VALUES ('$p_id','" . $cat[$i] . "','$price','$pickup_date','$dropoff_date','$numdays', '$total')" …

Member Avatar
Member Avatar
+0 forum 1

hey, i am trying to insert multiple checkbox data in my database but having a littlt bit problem. When i am trying to insert checkbox data it inserts only id and nothing else. Here is my full code:- <?php include("config.php"); if(isset($_POST['save'])){ $contact_sms = $_POST['contact_sms']; $check[] = $_POST['check']; $firm_name = $_POST['firm_name']; var_dump($firm_name); $checkbox = $_POST['check']; for($i=0;$i<count($checkbox);$i++){ $bulksms="INSERT INTO bulk_sms (sent_sms,firmname_sms,contact_sms) VALUES('".$checkbox[$i]. "','".$row['firm_name']. "','$contact_sms')"; $smsquery=mysqli_query($conn, $bulksms); } } $sql="SELECT * FROM inventory_details where status ='0' AND role='0' ORDER BY position ASC, role ASC, visiter DESC limit 0,100"; $query=mysqli_query($conn, $sql); ?> <form method="post" action="" id="msform"> <?php $i=0; while($row=mysqli_fetch_assoc($query)){ $id = $row['id']; $firm_name = …

Member Avatar
+0 forum 0

Im using MongoDB with PHP. Im making a check user exist using their email.It can be check, but when I enter the existing user and click the confirm button, it display the 'echo' and also display an error about converted document to int. Below is what the error say and my code. **ERROR** Fatal error: Uncaught Error: Call to a member function count() on null in C:\xampp\htdocs\project\OrgChart-master\OrgChart-master\resetPasswordSuccess.php:36 Stack trace: #0 {main} thrown in C:\xampp\htdocs\project\OrgChart-master\OrgChart-master\resetPasswordSuccess.php on line 36 **CODE** <!-- MongoDB Conn With Email Check Function V1 (FUNCTIONING) --> <!--Line 36 is at if($result==0)--> <?php if(isset($_POST['registration'])) { $registration = ($_POST['registration']); if(!empty($registration)) …

Member Avatar
Member Avatar
+0 forum 1

Hello..can you help me to solve my issue I wanted to update the rows status automatically as from 0 to 1 after completion of day. I.e. update Status=1 after completion of whole day means update after 12 AM. which query should I write to execute above?

Member Avatar
Member Avatar
+0 forum 1

Hi guys, im a newbie in programming, please i need help in populating ms datagrid from ms sql table, can anyone suggest me something thnx

Member Avatar
Member Avatar
+0 forum 1

I am facing issues using logical operators to perform operations in SAP HANA. Can anyone help me?

Member Avatar
Member Avatar
+0 forum 1

Hello everyone, I am new to this daniweb community and I really hope you guys will help me with this as I am baffled at what I couldn't come up with or was it not possible to do that? I want to have a checkbox on either PHP page or on modal like I did below to be checked, then save (submit), and stored in the mysql database so users can have ability to hide or show the product's description every time we go there without it coming back when the page refresh or whatever...Is there any possible that it …

Member Avatar
Member Avatar
+0 forum 2

Please, why I got this error(SQL Error: ORA-00907: missing right parenthesis ) whats wrong in my code? CREATE TABLE DomeniuAB(ID_DOMAB NUMBER(10) constraint ID_DOMAB_PK PRIMARY KEY , DENUMIRE VARCHAR2(20) NOT NULL, DETALII VARCHAR2(20) NOT NULL, ISBNAB_CarteAB VARCHAR2(15), CONSTRAINT ISBNAB_FK FOREIGN KEY (ISBNAB_CarteAB) REFERENCES CarteAB(ISBNAB), CNPAB_AutorAB NUMBER(10), CONSTRAINT CNPAB_FK FOREING KEY (CNPAB_AutorAB) REFERENCES AutorAB(CNPAB));

Member Avatar
Member Avatar
+0 forum 3

[MYSQL] my query is:- SELECT * FROM (SELECT 'attendence' AS 'type',userAS 'username', STR_TO_DATE(in_time, '%d-%m-%Y %H:%i:%s') AS 'time_in', 'in_address' AS 'address_in', STR_TO_DATE(out_time, '%d-%m-%Y %H:%i:%s') AS 'time_out', 'out_address' AS 'address_out' FROM attendence UNION ALL SELECT 'visit', username, STR_TO_DATE(visit_time_in, '%d-%m-%Y %H:%i:%s'), location_in, STR_TO_DATE(visit_time_out, '%d-%m-%Y %H:%i:%s'), location_out FROM visits) t WHERE t.username = 'MCCuser0036' AND time_in BETWEEN STR_TO_DATE('01-01-2019', '%d-%m-%Y %H:%i:%s') AND STR_TO_DATE('27-04-2019', '%d-%m-%Y %H:%i:%s') ORDER BY time_in ASC; and result is:- +------------+-------------+---------------------+----------------------------------------------------------------------------------------------------------------------+---------------------+-----------------------------------------------------------------------------------------------------+ | type | username | time_in | address_in | time_out | address_out | +------------+-------------+---------------------+----------------------------------------------------------------------------------------------------------------------+---------------------+-----------------------------------------------------------------------------------------------------+ | attendence | MCCuser0036 | 2019-01-25 11:02:09 | in_address | 2019-01-25 11:02:10 | out_address | | visit | …

Member Avatar
Member Avatar
+0 forum 1

hello every one please can any body do this task for me please becouse our instructor in the university uploaded it and I dont have enough time becouse im studying for my final exams please any one and i will be helpfull for him/her :) this is the task Create a car rental system where customers rent cars for a given period of time. Car – a class for all cars. Holds car information and an array of rents. Implement several types of cars as subclasses: Small car – 4 passengers, Motor 1200, air-conditioner Medium car – 4 passengers, Motor …

Member Avatar
Member Avatar
+0 forum 2

I'm writing stored procedure with dynamic sql having dynamic table name as, CREATE OR replace PROCEDURE Pr_get_result (p_table_name IN VARCHAR2, p_object_Id IN VARCHAR2) IS p_prop_code VARCHAR2(50) := 'pH'; BEGIN EXECUTE IMMEDIATE 'DECLARE ' || ' TYPE ObjCurTyp IS REF CURSOR; ' || ' v_obj_cursor ObjCurTyp; ' || ' v_stmt_str VARCHAR2(32000); ' || ' v_obj_record ' || p_table_name || '%rowtype; '|| 'BEGIN ' || ' v_stmt_str := ''SELECT * FROM ( SELECT * FROM '|| p_table_name ||' where CREATED_DATE<= ( SELECT CREATED_DATE FROM '|| p_table_name ||' WHERE object_id='|| p_object_Id ||' AND PROPERTY_CODE='|| p_prop_code || ' ) Order By CREATED_DATE DESC ) …

Member Avatar
Member Avatar
+0 forum 1

Which SQL data types can be used in SAP HANA?

Member Avatar
Member Avatar
-1 forum 1

I'm a novice in PHP and I would like to know on how exactly could I define said row. Any helps/tips are appreciated. Thank you in advanced! function add_review() { if(isset($_POST['add_review'])){ (THE UNDEFINED ROW) **$product_id = $row['product_id'];** $review_name = escape_string($_POST['review_name']); $review_email = escape_string($_POST['review_email']); $review_content = escape_string($_POST['review_content']); $review_created = date("Y-m-d H:i:s"); $rating = escape_string($_POST['rating']); $review_query = query("INSERT INTO reviews(review_id, product_id, review_name, review_email, review_content, review_created, rating) VALUES('NULL', '$product_id', '$review_name', '$review_email' , '$review_content' , '$review_created' , '$rating')"); confirm_query($review_query); set_message("Thank you for the feedback!"); }}

Member Avatar
Member Avatar
+0 forum 1

Hi all, I am very new to PHP and MYSQL and have a class assignment I need help with. I am trying to make a page with an HTML form that will update my MYSQL database. You can view my pages online here: [URL="http://baileyjumper.aisites.com/Scripting-Week7/homework4/exercise-five.php"]http://baileyjumper.aisites.com/Scripting-Week7/homework4/exercise-five.php[/URL] I need help with the "Edit" section, if you look online. Here is the code for my Edit page: [CODE=PHP] <?php $hostname = "localhost";//host name $dbname = "baileyjumper_imd203";//database name $username = "baileyjumper_imd";//username you use to login to php my admin $password = "chris4ever";//password you use to login //CONNECTION OBJECT //This Keeps the Connection to the Databade …

Member Avatar
Member Avatar
+0 forum 21

Hi i am trying to fetch data from database into my dropdown menu in codeigniter, but havind error of 'undefined variable: unit_name' . this is my model file `public function get_unit_value() { $result = $this ->db ->select('id, unit_name') -> get('units') -> result_array(); $unit_name = array(); foreach($result as $r) { $unit_name[$r['id']] = $r['unit_name']; } $unit_name[''] = 'Select unit...'; return $unit_name; }` this is my controller `public function unit(){ $this->load->database(); $this->load->model('client_model'); $data['unit_name'] = $this ->client_model-> get_unit_value(); $this -> load -> view('add_quote', $data); }` this s my view file `<div class="panel panel-default"> <div class="panel-heading">The form</div> <div class="panel-body"> <!--dropdown input--> <?php echo form_dropdown('unit_name',$data['unit_name'], '', …

Member Avatar
Member Avatar
+0 forum 1

Got Client with need of **"online print shop"** Client is providing paper printing (like business cards, flyers), printing on cloths, office stationary, logo embroidery on any type of clothing. Client provided some examples. **Links** * [rockdesign](https://www.rockdesign.com/) * [moo](https://www.moo.com/ca/) * [readyprint](https://www.readyprint.ca/) * [vistaprint](https://www.vistaprint.ca/) * [printshop](https://printshop.ca/) * [printvenue](https://www.printvenue.com/) **Where do I start?** Which platform should I choose? 1. CorePHP 2. Wordpress 3. WooCommerce 4. Magento 5. Prestashop 6. WordPress Is there any plugin or script that should I go for???

Member Avatar
Member Avatar
+1 forum 14

I have a sp which has multiple resultset.I need to create another procedure which should execute the second resultset of 1st sp for ex SP1 gives two resultset I need to write sp2 which uses only the second resulset

Member Avatar
+0 forum 0

I have a sp which has multiple resultset.I need to create another procedure which should execute the second resultset of 1st sp for ex SP1 gives two resultset I need to write sp2 which uses only the second resulset

Member Avatar
+0 forum 0

i am unable to connect to the java database using wampserver it is not turning green

Member Avatar
Member Avatar
+0 forum 1

dear all i have a invoice table now in that datagrid table i have 4 columns itemcode itemdescription qty price now what i need is user come to itemcode and whenever he type itemcode, he should get a list of initial alphabetic itemnames like if i type A so itemcode must show all items codes related to A and when i get my required itemcode, after pressing enter it should fill the related field (item description,qty,price) please guide with codes thanks

Member Avatar
Member Avatar
+0 forum 7

I have a table where I want to update "time 2" row, in the user's last "time 1" entry. I was try this, but not function. UPDATE `temp` SET `time2`=NOW() WHERE user = 'kraso' (SELECT max(time1) FROM 'temp')

Member Avatar
Member Avatar
+0 forum 5

Hi, I'm new to php (Yii Framework) and SQL (phpMyAdmin). I have problem to ask. ![Capture11.PNG](/attachments/large/4/1e4d9bf0c9a482a977d0ccb0fa19260e.PNG) Currently the three dropdown menu from different table and each have different id called aircraft_type, aircraft_sn and aircraft_reg. I want to use only one table called aircraft. In this table have all three details and only have one id. What I want to do is, when user choose value from aircraft type, the aircraft serial number and aircraft registration will also automatically fill. Calling value from table aircraft only. So far the code I have is: 1)_form.php (project form) <div class="panel panel-bordered panel-success"> <!-- …

Member Avatar
+0 forum 0

Guys, do you know if I can use SQL in Mobirise? As it's a pain to set all coming mail to separate file manually out of Mobirise's forms. I'm not sure that it's possible to bring any changes to the code of the forms at all. Thanks

Member Avatar
Member Avatar
+0 forum 1

I need to create a database from the messages, coming from the Mobirise website builder's forms. What code should I use? This doesn't work. Could you please help me. $link = mysqli_connect('localhost', 'root', 'password'); if (!$link) { $output = 'Unable to connect to the database server.'; include 'output.html.php'; exit(); }

Member Avatar
+0 forum 0

i really need help, am new in programming and youtube is my teacher. i really need assistance to install Cryptomarket Trading System Installer in to my cpanel.

Member Avatar
Member Avatar
+0 forum 1

Hello everyone , I have find i script made in 2013 that use Mysql , Today the mysql has removed and remplaced by Mysqli or PDO Can any one help me please to convert the mysql code to mysqli Exemple : <?php $num_queries = 0; $total_time = 0; class ADO { function ADO($host,$user,$password,$database) { $this->connection=mysql_connect($host,$user,$password); if(!$this->connection) { echo "<br>Database Error!!!<br>".mysql_error(); } mysql_select_db($database); } function exec($sql) { // echo "<br />".$sql; //exit; // global $num_queries; // global $total_time; // $num_queries++; // $start_time = microtime(true); // echo "<br />".$num_queries." ".$sql; $result=mysql_query($sql,$this->connection) ; if(!$result) echo "<p>ERROR::".mysql_error()."<br><strong>".$sql."</strong></p>"; // $time_taken = round(microtime(true) - $start_time, 4 …

Member Avatar
Member Avatar
+0 forum 1

In Access I want to group and assign data according to conditions with 2 values 0 and 1 (true or false) and with the condition NGAYGIAO>= #01/01/2019# and NGAYGIAO <=# 31/01/2019# me How to write commands ? The data I put in the excel file consists of two sheets: Original data and Result, where Original data is the original data sheet that is the result of the problem I need, when running the access issue, ask you to help me with the problem. http://www.mediafire.com/file/hkkw519bw2k3o9h/baitap_data2.xls/file

Member Avatar
+0 forum 0

The End.